Question
Part II: Complete an entity relationship diagram in 3NF for problem #5 on page 239 in our text (12th edition). Use both the data in
Part II: Complete an entity relationship diagram in 3NF for problem #5 on page 239 in our text (12th edition). Use both the data in the tables as well as the description of the problems. Complete only the ERD, not the other requirements (descriptions, business rules, etc.).
Notes Your database should be a generic database that will work for new data going forward, not just the example data that is in the figure. Use your understanding of the world to make decisions. Assume the most typical case.Note that for the problems from our text the author chose to draw the rows as columns and columns as rows.Follow the rules that we learned in class, including but not limited to:Use dash or solid lines for weak and strong entities.We can no longer use many-to-many relationships or ternary relationships.Include connectivities (tick marks and circles)Include verbs on relationships only when there is more than one relationship between the same two entities.You must use Visio to draw your diagrams.
Formatting Notes Do not include to much extra verbiage around your problem. This includes things like notes, the problem itself, or long explanations of the choice you made. If you do include extras make sure you use formatting to make it easy for me to find your answer.Be sure to minimize the number of times that relationship lines cross each other. This makes the diagram difficult to read. With diagrams with ten or less entities it is generally possible to rearrange the diagram so that no lines cross.Each diagram should be complete. Do not include any this line continues on the other diagram references.To give yourself more space you can decrease the margins in MS Word to 1/4".Your homework should be submitted as a single MS Word document. Use the snipping tool in MS Windows to create an image of your Visio diagram to paste into your MS Word document.Don't forget to mark your primary keys and foreign keys in Visio with the PK and FK icons.
cation tsTU CLASS), this dependency is not as obvious as you mightihitiay be For example, a student is considered a junior if the student has completed between 61 and 90 credit hours 5. To keep track of office furniture, computers, printers, and other office equipment, the FOUNDIT Company uses the table structure shown in Table P6.5. TABLE P6.5 ATTRIBUTE NAME ITEM ID ITEM LABEL ROOM NUMBER BLDG CODE BLDG NAME BLDG MANAGER SAMPLE VALUE 231134-678 HP DeskJet 895Cse 325 NTC Nottooclear I. B. Rightonit SAMPLE VALUE 342245-225 HP Toner 325 NTC Nottooclear .B. Rightonit SAMPLE VALUE 254668-449 DT Scanner 123 CSF Canseefar May B. Next a. Given that information, write the relational schema and draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies. b. Write the relational schema and create a set of dependency diagrams that meet ttribtes to meet the naming conventions, and cre
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started