INFS1603 Lecture Notes - Lecture 1: Database, Data Redundancy, Relational Database
Document Summary
1. 1 introduction to databases: er model -> relational model , sql ddl implement table model in oracle, sql dml get data in/out of database, merge, update, designing the database, then creating and using the database. 1. 2 data vs information: data: meaningful facts concerning such as people, places, events or concepts, stored in databases: a collection of data that exists over a long period of time. Includes end user data (e. g. dob) and metadata (e. g. Includes end user data (e. g. dob) and metadata (e. g. dd/mm/yyyy: purpose: help people keep track of things, managed through a dbms. Information: data that has been processed and presented in a form for human interpretation, often with the purpose of revealing trends or patterns. 1. 4 handling data: manual filing systems -> computerized filing systems via data files -> database systems. 1. 5 advantages of dbms: reduced data inconsistency and anomalies, reduced data redundancy and improved data sharing.