Question: Consider the following ERD for the ABC Sales Database. CUSTOMER NVOICE LINE PK INY NUMBER contains PKFK1 INV NUMBER PK LINE NUMBER FK1 CUS CODE

Consider the following ERD for the ABC Sales

Consider the following ERD for the ABC Sales Database. CUSTOMER NVOICE LINE PK INY NUMBER contains PKFK1 INV NUMBER PK LINE NUMBER FK1 CUS CODE NV DATE K2 PK CUS CODE generates HE CUS LNAME CUS FNAME CUS INITIAL CUS AREACODE CUS PHONE CUS BALANCE P_CODE LINE UNITS LINE PRICE is found in VENDOR PRODUCT P_CODE PK V_CODE PK It supplies - 04 V_NAME V_CONTACT V_AREACODE V PHONE V_STATE V ORDER P_DESCRIPT P_INDATE P_QOH P MIN P PRICE DISCOUNT V CODE FK1 The database management team of the ABC Sales Company is looking to redesign the current system to integrate other functioning areas within the company into the current database system. Since you have previous knowledge of the ABC Sales System, you have been hired to present a solution to integrate the Human Resources functioning unit into the current system. You have been asked to develop a fully functional logical model (ERD) for the ABC Sales that includes entities of the Human Resources. You have to identify entities that can be used to develop the physical model of the system. Task: Not all entity requirements are determined at this point, therefore ABC SALES is looking for your expertise in assisting them with the design. You must research and come up with a possible solution for ABC Sales database team. It is important to look at the different areas to be considered in the design and based on your research and knowledge to make reasonable assumptions regarding each area. You will have to make assumptions in determining the entities, attributes/columns, the datatypes, relationships, primary/foreign key constraints, and cardinality. Your Entity Relationship Diagram (ERD) has to follow the rules of Normalization and adhere to 3rd Norm Form in your design

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!