INFS1603 Study Guide - Final Guide: Second Normal Form, First Normal Form, Third Normal Form

• School: UNSW, UNSW Sydney
• Department: Information Systems
• Course: INFS1603
• Professor: All

Document Summary

What a database is, the various types of databases & why they are valuable assets for decision making . Evolution of modern databases from file systems 4. The main components of database system 4. The main characteristics of entity relationship components 8. How relationships between entities are defined, refined & incorporated into the database design. Methods to converting entity type to relations 9. Stages & role of normalisation in the database design process 10. Difference between data & information: data raw, unprocessed facts (ubiquitous & pervasive) Information data processed & presented in a form of human interpretation: characteristics of quality information (5), accurate, timely, relevant, just barely sufficient, worth its cost. What a database is, the various types of databases & why they are. Function of dbms: data dictionary management, data storage management . 1 site: distributed database supports data across 2 or more independent sites, cloud database database created & maintained using cloud data services.