Reference no: EM132279397
Phase 2 of your Personal Collection Database Application
Mapping from E/R Model to Relational Design
Project Description
Entity-Relationship to Relational Schema:
(a) A copy of your updated E/R Data Model from Phase#1 of your PC-DBA. Please use MySQL Workbench or a similar software system to generate your updated diagram. Hand-drawn diagrams will not be accepted at this point. The course material on Canvas includes several tutorial videos about the MySQL Workbench.
(b) Use the methods for transforming an E/R diagram to Database Relations described in the text or the supplementary lecture notes and videos posted on the course's Canvas website, to produce a set of relations from your E/R Data Model. Specify your relational schema using the notation described in these resources, and be sure to indicate key attributes.
(c) For each Database Relation, add your comments to respond to the following question:
Are there any flaws in the relational database schema you get from part (b) above?
Normalization:
1. Are there any opportunities to combine relations without introducing redundancy? If so, indicate which, and if not, tell that there are none.
2. Are there any examples relation schemas that violate the Third Normal Form (3NF) or BoyceCodd Normal Form (BCNF)? If so, do you want to decompose them?
Please note that in the Design phase, you may knowingly decide to violate 3NF, BCNF or 4NF when you prefer to avoid
decomposition of a big relation R, because you anticipate frequent queries on R and if R is decomposed into R1 and R2, then that will lead to frequent expensive joins of R1 and R2.
3. For each opportunity to combine or decompose relations, decide whether or not to do so, and explain your reasoning briefly (e.g., tell what queries you expect will be typical for your database, and tell how the design you pick facilitates them).
4. Is there anything you still don't like about the schema (e.g., attribute names, relation structure, duplicated information, etc.)? If so, modify the relational schema to something you prefer.
5. You will be working with this schema quite a bit, so it's worth spending some time to make sure you're happy with it.
Please submit a pdf document that includes your E/R Diagram and your response to the above issues.
|
Combinations of independent and dependent variables
: In a few combinations of independent and dependent variables that you could test using a regression analysis and what types of results could the regression
|
|
Review of the user population for a business network
: Modern organizations realize that, no matter what they manufacture or what activities they perform, well-running networking technology.
|
|
Identify some common certifications for digital forensic
: Depending on copyright, the documentary "The KGB, the Computer and Me" may be available for viewing on public video-streaming services.
|
|
Who determines what is a bad product
: Who determines what is a "bad" product? One can consider cigarettes, which are pretty clearly bad for you, and they're an easy target; but Marketing Professor
|
|
Are there any opportunities to combine relations
: Are there any opportunities to combine relations without introducing redundancy? If so, indicate which, and if not, tell that there are none.
|
|
How many databases do you interact with daily
: Consider your daily interaction with technology, including your phone, PC, and all of your activities using the Internet.
|
|
Overall assessment of the effectiveness of a marketing
: Which term describes the service used by researchers in an attempt to provide an overall assessment of the effectiveness of a marketing campaign across
|
|
Can the behavioral model of health care utilization
: Can the Behavioral Model of Health Care Utilization be used to explain not only the use of health services but behavior? Explain your response
|
|
Explain the open system interconnection model
: Identify and discuss the seven layers of the Open System Interconnection (OSI) model and their importance on TCP/IP operation.
|