Now that Tshepo knows that you are an expert with ERDS, he wants you to review a UMLERD that an intern created for anoth

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Now that Tshepo knows that you are an expert with ERDS, he wants you to review a UMLERD that an intern created for anoth

Post by answerhappygod »

Now That Tshepo Knows That You Are An Expert With Erds He Wants You To Review A Umlerd That An Intern Created For Anoth 1
Now That Tshepo Knows That You Are An Expert With Erds He Wants You To Review A Umlerd That An Intern Created For Anoth 1 (31.07 KiB) Viewed 37 times
Now that Tshepo knows that you are an expert with ERDS, he wants you to review a UMLERD that an intern created for another project. Below is the UML ERD and the business rules used to create it. Which 10 changes would you propose should be made to the ERD to improve its quality, so that it can be successfully implemented in a relational database? You can make annotations on the diagram and/or describe the changes in text. 1. 2. All tables in the database must have surrogate primary keys A product consists of one or more parts. Not all parts captured in the system are part of a product yet, and a part can be used in many products. 3. Each part is supplied by at least one supplier, but multiple suppliers could potentially supply the same part. 4. The following information must be stored for each product description. Proprietary information of ACME Technologies. Do not communicate with unauthorised third parties. Project ACME Grey - Business Rules The independent state of Education P 222 21, 22, 23 Product Product ID EPKS Producer Nouve Address supplies 0 Product ID FK3 Part ID {FC} Part Part ID 2PE3 Supplier ID SA Description of 2022
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply