“Database design has five purposes: Structure the data in stable structures, called normalized tables , that are not likely to change over time and that have minimal redundancy. Develop a logical database design that reflects the actual data requirements that exist in the forms (hard copy and computer displays) and reports of an information system. This is why database design is often done in parallel with the design of the human interface of an information system. Develop a logical database design from which we can do physical database design. Because most information systems today use relational database management systems, logical database design usually uses a relational database model, which represents data in simple tables with common columns to link related tables. Translate a relational database model into a technical file and database design that balances several performance factors. Choose data storage technologies (such as Read/Write DVD or optical disc) that will efficiently, accurately, and securely process database activities.” (Modern Systems Analysis and Design, 8th ed, Joseph Valacich)
Objectives:
- describe the database design process, its outcomes, and the relational database model;
- describe normalization and the rules for second and third normal form;
- transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations;
- merge normalized relations from separate user views into a consolidated set of well-structured relations; and
- describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed.
Topics:
From Modern Systems Analysis and Design:
9. Database Design
9.1. Relational Database Model
9.1.1. Normalization
9.2. Physical Database Design
From CISA:
3.1. System Development Methodologies
3.1.1. Software Development Methods
3.1.2. System Development Tools and Productivity Aids
3.1.2.1. Fourth Generation Languages
3.1.2.1.1. Query and Report Generators
3.1.2.1.2. Embedded Databases
3.1.2.1.3. Relational Databases
3.2. Control Identification and Design
3.2.1. Input/Origination Controls
3.2.1.1. Input Authorization
3.2.1.2. Batch Controls and Balancing
3.2.1.3. Error Reporting and Handling
3.2.2. Processing Procedures and Controls
3.2.2.1. Data Validation and Editing Procedures
3.2.2.2. Processing Controls
3.2.2.3. Data File Control Procedures
3.2.3. Data Integrity Testing
3.2.3.1. Online Transaction Processing Systems
3.2.3.1.1. Atomicity
3.2.3.1.2. Consistency
3.2.3.1.3. Isolation
3.2.3.1.4. Durability
From Secure Software Design:
1.4. Class Security Analysis
In this unit, plan to:
- Participate in the class discussion thread
- Read the assigned topics in CISA
- Read the assigned readings from Secure Software Design
- Read chapter 9 in Modern Systems Analysis and Design