Lab 07 - Data Design - Student Answers

pdf

School

Purdue University *

*We aren’t endorsed by this school

Course

180

Subject

Business

Date

Feb 20, 2024

Type

pdf

Pages

Uploaded by HighnessPartridge943

CNIT 180 Lab 7: Data Design EXERCISES Complete the exercises assigned by your instructor by drawing the assigned models. Save each diagram. Copy and paste each diagram into Lab 07 – Data Design – Student Answers. Save that document to your home directory. Close that document. Attach Lab 07 – Data Design – Student Answers to the Lab 07 Assignment in Brightspace and submit. 1. Draw a data design (ERD) that would track information recorded on the employee time card shown below. Determine needed entities, attributes, data types, primary and foreign keys, and relationships. Make assumptions where necessary. Answer: (copy and paste ERD)

CNIT 180 Lab 7: Data Design 2. The table shown below is part of an office inventory database. Assume that Item ID is the primary key. Identify the design problems and draw a revised table structure that corrects those problems. Draw a well-designed ERD. Include entities, attributes, data types, primary and foreign keys, and relationships. Make assumptions where necessary. Answer: (Design Problems) The group names have repetitions that are not required for example: Department, Department name. Plus, the department head could be of multiple departments. Corrected Table Structure: Department name Department Dept head Marketing MK Jane Thompson Engineering ENG Ahmad Rashere Item ID Description Dept Dept Name Dept Head Quan Cost/Unit Inventory Value 4011 5 ft desk MK Marketing Jane Thompson 5 200 1000 4020 File cabinet MK Marketing Jane Thompson 10 75 750 4005 Executive chair MK Marketing Jane Thompson 5 100 500 4036 5 ft desk ENG Engineering Ahmad Rashere 7 200 1400 Item Id Description Cost/Unit 4011 5 ft desk 200 4020 File Cabinet 75 4005 Executive chair 100 4036 5 ft desk 200 Item Id Quantity Inventory Value Department 4011 5 1000 MK 4020 10 750 MK 4005 5 500 MK 4063 7 1400 ENG

CNIT 180 Lab 7: Data Design Copy and paste ERD:

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

CNIT 180 Lab 7: Data Design 3. Design the data for an upholstery shop database based on the order entry form below. Draw a well-designed ERD. Include entities, attributes, data types, primary and foreign keys, and relationships. Make assumptions where necessary.

CNIT 180 Lab 7: Data Design Answer: copy and paste ERD:

Related Documents

WashingtonD-IndustryTrends.docx

WashingtonD-IndustryTrendsTemplate.docx

WashingtonD-Fact Sheet.docx

ISEN 350 - Problem Set M4.pdf

WashingtonD-CriticalThinking.docx

BUS 601 HW1.docx

Chapter 2.docx

MAR4802 Lesson 04- Assignment.docx

GEB4935 Chapter 1 Submission -2.pdf

GEB4935 Chapter 1 Submission .pdf

GEB4935 Chapter 1 Submission -3.pdf

MAR4802 Lesson 01- Assignment.docx

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:Cengage,

Purchasing and Supply Chain Management

Operations Management

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Cengage Learning

MARKETING 2018

Marketing

ISBN:9780357033753

Author:Pride

Publisher:CENGAGE L

SEE MORE TEXTBOOKS

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L