2023 1 Design an Relational Model RM model of a database DB that will be useful for each | Assignment Collections
Computer Science 2023 Mysql
2023 1 Design an Relational Model RM model of a database DB that will be useful for each | Assignment Collections
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
We give our students 100% satisfaction with their assignments, which is one of the most important reasons students prefer us to other helpers. Our professional group and planners have more than ten years of rich experience. The only reason is that we have successfully helped more than 100000 students with their assignments on our inception days. Our expert group has more than 2200 professionals in different topics, and that is not all; we get more than 300 jobs every day more than 90% of the assignment get the conversion for payment.