D3: DB Specification & Implementation: After you have developed the conceptual E-R model for GG, convert that data model into a relational database design for Garden Glory. Then develop the specifications for database implementation, indicating data types, Pks, and FKs. Implement the design and create the GG Database and execute a variety of queries to test the functionality of your DB. Document your database design and the processing results accordingly. You can also refer to the GG project questions in 5.
1. For each entity in the E-R model, specify a table structure, determine the data types and additional column properties using the metadata tables (use the Template table Figure D3.1 below as a guide for metadata table format and see Figure 5-26 on page 342 in the textbook for an example), identify primary keys and foreign keys, and verify normalization on the resulting tables.
2. Describe how you have represented weak entities, supertype and subtype entities, if any exist.
3. Document referential integrity constraint enforcement actions; use the Template table Figure D3.2 below as a guide and see Figure 5-29 on page 347 in the textbook for an example.
4. Document any business rules that you think might be important. Describe how you would validate that your design is a good representation of the data model upon which it is based.
5. Implement your DB design in MS Access. Create tables, create relationships, enter sample data ( see the sample data in previous deliverables and/or feel free to make up some sample data as appropriate), create data entry forms and reports as necessary, and use SQL or QBE to query the DB and test its operational performance.