Reference no: EM13326756
1.Choose 2 enterprises(businesses, corporations, companies, institutions) from one or more economic, organizational, institutional or industrial sector of interest to you. See the Appendix for suggestions and examples.
2.Suggestion: Beconcretein your choices, e.g., Wal-Mart, American Express, GE,Toyota, Uncle Ralph's Deli & Grill, MTA, Amtrak,York College, New York University, NYC Board of Education, CUNY,Universityof California,American Museumof Natural History, National Gallery of Japan, Omni Airlines, etc.
3.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 in Project 1).
4.The following aspects are required and should be captured in the project
a.There should be at least20 - 30 relational schemas covering Entitiesin the associated ER design for each enterprise dB.b.There should be at least20 - 30 relational schemas covering (entity-to-entity)Relationships in the associated ER design, for each enterprise.c.Implement the 2 enterprise relational DBs using either MySQL or SQLited. Populate the two DB with relational tables for all the relational schemas involved, with each table having at least5 - 10entries (tuples, records).
5.Document and present your design as a report in 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)
|
Find the angular frequency of the charged particle
: A charged particle of mass m and charge +q is placed in the vertical electrical field E(x)= A-Cx, Find expression describing the angular frequency of the charged particle oscillations
|
|
Compute the budgeted fixed cost per labor
: Compute the budgeted fixed cost per labor hour for the fixed overhead separately for each plant and compute the variable overhead spending variance and the variable overhead efficiency variance separately for each plant.
|
|
Determine her speed at the start of the slide
: A cross-country skier slides horizontally along the snow and comes to rest after sliding a distance of 28 m. determine her speed at the start of the slide
|
|
How much energy does this involve
: A lightning flash may transfer up to 30 C of charge through a potential difference of 10^8 V. How much energy does this involve
|
|
Design an relational model
: Choose 2 enterprises(businesses, corporations, companies, institutions) from one or more economic, organizational, institutional or industrial sector of interest to you. See the Appendix for suggestions and examples.
|
|
What is the magnitude and direction of the velocity
: in its daily prow of the neighborhood a cat makes a displacement of 100m due north followed by an 80m displacement east. what is the magnitude and direction of the velocity
|
|
What is the angle of the road above the horizontal
: a road rises 1ft for every 100ft it travels horizontally it is said to have a 15 grade. if the road you are traveling on has a 5 % grade what is the angle of the road above the horizontal
|
|
What is the frequency of the reflected sound
: A bat emits chirping sounds of frequency 75 kHz while hunting for moths to eat. The bat flies east at 8 m/s. What is the frequency of the reflected sound detected by the bat
|
|
Analyzing the detailed requirements of your prototype data
: Design a database prototype that includes diagrams, data dictionary, design decisions, limitations, etc. The database should consist of at least four tables, two different user roles, and two reports.
|