Relational Database Management
As indicated in the project description, each team will prepare a written and oral presentation of their project designed to explain the design of each of the systems to individuals that will be using the system. The written presentation will be written using APA standards and will contain
(1) a description of the company for whom you are designing the database;
(2) the specific division/section of the company that is requesting the database design;
(3) identify the entity types that are required to develop the database;
(4) provide the naming conventions that will be used in the design;
(5) identify all relationships that will be required between entities;
(6) determine and list all constraints that each of the entities will require;
(7) normalize the database to, at least, 3NF preferably BCNF;
(8) provide a copy of the final ERD developed in ERwin;
(9) provide the scripts forward engineered from ERwin; and, finally, (10) some sample data input screens and reports.