Data storage is a critical component of most information systems. This chapter teaches the design and construction of physical databases. You will know that you have mastered the tools and techniques of database design when you can: Compare and contrast conventional files and modern, relational databases; define and give examples of fields, records, files, and databases; describe a modern data architecture that includes files, operational databases, data warehouses, personal databases, and work group databases;. | Chapter 14 Database Design Chapter 14 – Database Design Objectives Compare and contrast conventional files and modern, relational databases. Define and give examples of fields, records, files, and databases. Describe modern data architecture of files, operational databases, data warehouses, personal databases, and work group databases. Compare roles of systems analyst, database administrator, and data administrator. Describe architecture of database management system Describe how a relational database implements entities, attributes, and relationships from a logical data model. Transform a logical data model into a physical, relational database schema. Generate SQL to create the database structure in a schema. 14- Chapter 14 – Database Design 14- Chapter 14 – Database Design Conventional Files versus the Database File – a collection of similar records. Files are unrelated to each other except in the code of an application program. Data storage is built around the applications | Chapter 14 Database Design Chapter 14 – Database Design Objectives Compare and contrast conventional files and modern, relational databases. Define and give examples of fields, records, files, and databases. Describe modern data architecture of files, operational databases, data warehouses, personal databases, and work group databases. Compare roles of systems analyst, database administrator, and data administrator. Describe architecture of database management system Describe how a relational database implements entities, attributes, and relationships from a logical data model. Transform a logical data model into a physical, relational database schema. Generate SQL to create the database structure in a schema. 14- Chapter 14 – Database Design 14- Chapter 14 – Database Design Conventional Files versus the Database File – a collection of similar records. Files are unrelated to each other except in the code of an application program. Data storage is built around the applications that use the files. Database – a collection of interrelated files Records in one file (or table) are physically related to records in another file (or table). Applications are built around the integrated database 14- Chapter 14 – Database Design Files versus Database 14- Chapter 14 – Database Design Pros and Cons of Conventional Files Pros Easy to design because of their single-application focus Excellent performance due to optimized organization for a single application Cons Harder to adapt to sharing across applications Harder to adapt to new requirements Need to duplicate attributes in several files. 14- Chapter 14 – Database Design Pros and Cons of Databases Pros Data independence from applications increases adaptability and flexibility Superior scalability Ability to share data across applications Less, and controlled redundancy (total non-redundancy is not achievable) Cons More complex than file technology Somewhat slower performance Investment in DBMS and database
