Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Requirements Deliverable 1 must contain an analysis of the intended database system, and a conceptual schema. It must describe the problems encountered in this phase

Requirements Deliverable 1 must contain an analysis of the intended database system, and a conceptual schema. It must describe the problems encountered in this phase and justify the solutions. What is expected: 1. Outline the goals of this phase of the project. 2. Analyze the entire application for Woodys Automotive and compose with an Extended ER diagram. Use the notation for E/R model constructs and additional notation for specialization/generalization hierarchies we learned in class. Show entity types, relationship types (including class/subclass relationship types), and attributes. Show different types of attributes (simple/composite, single-valued/multi- valued, stored/derived) if needed. Show roles on recursive relationship types. Show key attributes (only one key per entity type should be shown on the ER diagram. Include structural constraints (cardinalities ratio and participation constraints). Use both notations for the constraints of relationship types on the diagram as an exercise (the traditional one and the (min,max) notation). Use some diagram editor to draw a clean diagram. Hand-written diagrams will not be accepted. 3. Mention any assumptions you made in doing the above that go beyond what is given in the project description. In particular, mention all assumptions that led you in determining structural constraints. 4. Make a list of constraints that apply over and above what you can show in the diagram. In particular, make a list of additional keys for entity types (if there are any). 5. Besides the above, comment on the difficulties you faced in doing this conceptual design task. NOTE: The above specification will drive your subsequent phases. As in any actual design and implementation, you will be revising what you do here as you proceed through the phases. Please be explicit and detailed when writing your deliverable. This will help you in the long run!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Management System MCQs Multiple Choice Questions And Answers

Authors: Arshad Iqbal

1st Edition

1073328554, 978-1073328550

More Books

Students also viewed these Databases questions

Question

2. How will the team select a leader?

Answered: 1 week ago