Assignment Preparation: Activities include watching the Lynda.com videos, independent student reading, and research.
- Watch Ch. 3, “Database Modeling: Tables,” of the Lynda.com “Foundations of Programming Databases” video.
- Watch Ch. 4, “Database Modeling: Relationships,” of the Lynda.com “Foundations of Programming Databases” video.
- Watch Ch. 5, “Database Modeling: Optimization,” of the Lynda.com “Foundations of Programming Databases” video.
Resources: Huffman Trucking Virtual Organization
Review the information currently housed in Huffman Trucking’s database, in the Entities and Attributes for Fleet Truck Maintenance file on the virtual Organizations site.
Create a Microsoft® Visio® entity-relationship diagram (ERD), based on the relations in the Entities and Attributes for Fleet Truck Maintenance file and any additional information needed to normalize the database.
- Notate primary keys in each table with solid underlining.
- Notate foreign keys in each table with dashed underlining.
- Notate new attributes that do not exist in the existing database with italic font.
Create normalized tables in a Microsoft® Word document or a Microsoft® Excel® spreadsheet for the fleet truck maintenance database. Indicate primary keys, foreign keys, and new attributes as in the entity relationship diagram.
0 comments