AllTheTimeWorld.com

Database Design

Understand the Importance of designing a data system that is flexible, reliable, accurate and robust.

In order to do this you will:

• Compare the advantages and disadvantages of files vs. database and know when to use each.
• Know the basic terminology of databases: files, fields, tables, entities, records, keys
• Be able to draw ERD: Entity Relationship Diagrams
• • Implement the ERD into the Database Design.
• Be able to create a Normalized database and explain the concepts.
• Understand some of the coding schemes and their importance
• Compare data mining and data warehousing
• Understand the difference between Logical and Physical records and storage
• Discuss Data Control issues

Please study the material at each of the links below.

1. Database Terminology
   
   

2. Data Types and Other Issues
   
   
3. No repeating fields: Where do the repeating fields go?
   
   
4. Case Study: Babysitter Database
   
   
5. Case Study: Babysitter Database, What if?
   
   
6. Normalization in DBMS
   
   
7. Database normalization with examples
   
   
8. Example: Enrollment database