Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Quality of your hand-written diagram (understand how to develop a conceptual data model): 2 points. The quality of your Visio diagram (know how to transform

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Quality of your hand-written diagram (understand how to develop a conceptual data model): 2 points. The quality of your Visio diagram (know how to transform your conceptual diagram to logical relational data model): 1 point Consistency b/w your hand-written diagram and Visio diagram (You did not change the meaning of your diagram during the transformation): 1 point A small local manufacturing company wants you to develop a database, which is currently using Excel spreadsheets to maintain all the transaction data. A systems analyst has been working with users and documented initial mock design of user interface as data requirements. (gnore the poor quality of interface design. These are just for identifying what data need to be gathered from a user and what information needs to be presented to the user.) Based on the mock designs of user interface, you need to design a relational database. You must complete the following steps as you go through the conceptual data modeling phase and the logical database design phase of the database development phases 1. (This step corresponds to the 1t phase of the database development process and prepare you for Exam1) Hand- of instructions (page 5) to know how to show a many-to-many relationship with attributes tes on paper that covers all of the four mock write one conceptual data model with no designs shown on pages 3-4. If your diagra a. Do NOI use an associative entity. en, you will lose 1 point. /-to-many relationships. See the end of the 1 5

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

Practical Neo4j

Authors: Gregory Jordan

1st Edition

1484200225, 9781484200223

More Books

Students also viewed these Databases questions