Order ID:89JHGSJE83839 | Style:APA/MLA/Harvard/Chicago | Pages:5-10 |
Instructions:
indicating identifiers and cardinality constraints
Q1. Ali has a large DVD movie collection. His friends like to borrow his DVD’s, and he needs a way to keep track of who has what. He maintains a list of friends, identified by unique FID’s (friend identifiers) and a list of DVD’s, identified by DVD_ID’s (DVD identifiers). With each friend is the name: First name and last name, and the all-important telephone numbers which he can call to get the DVD back. With each DVD is the star actor name and title. Whenever a friend borrows a
DVD, Ali will enter that fact into his database along with the date borrowed. Whenever the DVD gets returned, that fact, too, gets noted along with the date returned. Ali wants to keep a complete history of his friends’ borrowing habits so that he
can ask favors of the heavy borrowers (or perhaps refuse to make further loans to those who habitually do not return them quickly).
a). As a system analyst, construct a conceptual ER/ EER diagram for the DVD rental database. Be certain to indicate identifiers and cardinality constraints.
b). Based on the given case and your conceptual ER/ EER diagram, construct the logical relational model for the DVD rental database.
Q2. Production tracking is important in many manufacturing environments (e.g., the pharmaceuticals industry, childrens toys, etc.). The following ER diagram captures important information in the tracking of production. Specifically, the ER diagram captures relationships between production lots (or batches), individual production units, and raw materials. As a database designer, convert the below ER model into a well-structured relational model.
RUBRIC |
||||||
Excellent Quality 95-100%
|
Introduction
45-41 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned. |
Literature Support 91-84 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned. |
Methodology 58-53 points Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met. |
|||
Average Score 50-85% |
40-38 points More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided. |
83-76 points Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration. |
52-49 points Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met. |
|||
Poor Quality 0-45% |
37-1 points The background and/or significance are missing. No search history information is provided. |
75-1 points Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration. |
48-1 points There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met |
|||
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow |
indicating identifiers and cardinality constraints