Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Lakeside Assembly Inc. sells products assembled from parts purchased from various vendors. For each vendor, vendor id, company name, and contact person are stored.

Lakeside Assembly Inc. sells products assembled from parts purchased from various vendors. For each vendor,

Lakeside Assembly Inc. sells products assembled from parts purchased from various vendors. For each vendor, vendor id, company name, and contact person are stored. Some vendors do not assign a contact person. For parts, part id, part description, and part cost are stored. For products, product id, product name, and selling price are stored. . Name the first tab P02-02a 1. Identify and draw the entities 2. Add the attributes associated with each entity and identify them as mandatory or optional 3. Identify candidate keys for each entity . . Specify the UID/PK for each entity Specify all other candidate keys as unique keys (UKS) Name the second tab P02-02b P02-02b (Ex 8) Each part is purchased from one specific vendor. Of course, each vendor may supply several parts. Usually, but not always, a vendor relationship is established before any parts are purchased. Each product is assembled from one or more parts. Each part is unique and is used in the assembly of one specific product. Modify the ERD and include the ERD language. Enhance the ER diagram . Include relationships and ER language .

Step by Step Solution

3.32 Rating (152 Votes )

There are 3 Steps involved in it

Step: 1

P022a Entity is as follow vendor vendor id company name contact person products product id product n... 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_2

Step: 3

blur-text-image_3

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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions

Question

Prepare Journal Entries for a Job Order Cost System? p-214

Answered: 1 week ago