Mysql

1.Design an Relational Model (RM) model of a database (DB) that will be useful for each of the chosen enterprises. (Hint: You may choose to translate the 2 ER model designs you created ).

2.The following aspects are required and should be captured in the project

a.There should be at least 20 - 30 relational schemas covering Entities in the associated ER design for each enterprise dB.

b.There should be at least 20 – 30 relational schemascovering (entity-to-entity) Relationships in the associated ER design, for each enterprise.

c.Implement the 2 enterprise relational DBs using either MySQL or SQLite

d.Populate the two DB with relational tables for all the relational schemas involved, with each table having at least 5 - 10 entries (tuples, records).

3.Document and present your design as a reportin the following form:

Title

Author

Date, Revision Number

Problem to Solve

Design (RM) model. (Provide details in an Appendix)

Discussion

Summary & Conclusions

Acknowledgments, (if any)

References, (if any)

Appendix:

Relational Schemas

Relational Tables

SQL scripts showing the Creation and Population (Loading) of the DBs.

Simple SQL queries, providing simple tests on the DBs.

ER diagrams (Chen diagrams) of the ER model, (reference or include your work for Project 1 here)

UML / OO diagrams, charts, maps of the ER model, (reference or include your work for Project 1 here).

A “data dictionary” (a kind of glossary) explaining terms and concepts that make it easy to understand your design and implementation