ITSS 4300 Lecture Notes - Lecture 3: Contact Manager, Enterprise Resource Planning, Sql
9 Sep 2016
School
Department
Course
Professor
Document Summary
Store information that is too complicated for a spreadsheet or list. Easier to search even if redundant: multiple list. Allows to have difference in charge per visit. Add customer id to vehicles table: excel list. If there is change in advisor, you have to change department, email and admin. Redundancy (single list: each row stands on its own, repetitive. Multiple themes: needed info may appear in lists only if info on other themes is also present. Purpose of database is to help people track things of interest to them. Column names are written with an initial capital letter: compound names are written with capital letter on each word. Projection selecting attributes from database and putting it on your screen. Data recorded facts and figures: exm. birth year. Information knowledge derived from data: exm. age. Data mining analyzing large data to generate new information. Users database application dmbs database. Smartphones applications) sql dbms database.
