During the systems analysis phase, a logical model of the system was created. Next, the analyst must look at how data will be organized, stored, and managed. These are important issues that affect data quality and consistency.
Understanding data design concepts is essential for the analyst to design the databases used to store, edit, retrieve data of the designed system.
At the end of this week, you will be able to:
- Explain file-oriented systems and how they differ from database management systems
- Explain data design terminology, including entities, fields, common fields, records, files, tables, and key fields
- Describe data relationships, draw an entity-relationship diagram, define cardinality, and use cardinality notation
- Explain the concept of normalization
- Explain the importance of codes and describe various coding schemes
- Explain data warehousing and data mining
- Differentiate between logical and physical storage and records
- Explain data control measures
- Read Module 9: Data Design.
- Participate in Module 9 SCR Case Simulation: Data Design.
- Visit the following resource links specific to AirTable:
- Take the Unit 9 Test.