Reference no: EM13187731
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
|
How far does the boat coast in the first minute
: suppose a motorboat is moving at 40ft/s when its motor suddenly quits and that 10s later the boat has slowed to 20ft/s. assume that the resistance it encounters while coasting is proportional to the square of the velocity (v'=-k(v^2)) how far does..
|
|
How many units should each plant produce to maximize profit
: ] A perfectly competitive firm faces a market price of $10 for its output X. It own two plants, A and B whose total costs are TC sub A = 10 + 2X + (.25X)2, TC sub B = 15 + .4X + (.1X)2, How many units should each plant produce to maximize profit at t..
|
|
Find the line integral
: Find the line integral of f(x,y,z)=x+y+z over the straight-line segment from (2,1,4) to (1,-2,2). The answer is 4(sqrt(14)). Can you show the work.
|
|
Compute the normalization factor
: Normalize the harmonic oscillator wavefunctions for v=0 and v=1 (?0, ?1) by evaluating the appropriate integrals. Confirm your answer by calculating the normalization factor
|
|
Design an relational model model
: Design an Relational Model (RM) model of a database (DB) that will be useful for each of the chosen enterprises and Implement the 2 enterprise relational DBs using either MySQL or SQLite
|
|
What cost would an accounting statement revelat
: Suppose a firm produces bicycles. Will the firm's accounting statement reflecte the opportunity cost of the bicycles Why or why not What cost would an accounting statement revelat Should current decisions be based on accounting cost
|
|
Use of the one factor between-subject analysis of variance
: Which of the following is not a necessary assumption underlying the use of the one factor between-subject Analysis of Variance technique?
|
|
Death and dying in the classroom
: Articles from journals, literature, no books Topic how to teach elementary students about death and dying in the classroom especially fourth graders APA form bibliography title, who wrote the article date and pulisher.
|
|
State what is the theoretical yield of agcl
: What is the theoretical yield of AgCl if 30.2 mL of 0.1000 M AgNO3 reacts with an excess of 0.1000 M HCl
|