Answered step by step
Verified Expert Solution
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, 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...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