Question: Customer ( CustomerRef , CustomerFirstName , CustomerSurname , CustomerAddress , CustomerTel) OrderItemNo( OderItemNo , OderNo, PartNo, OrderQty) Orders ( OrderNo , CustomerRef, OrderDate) PartTypes (

Customer (CustomerRef , CustomerFirstName , CustomerSurname , CustomerAddress , CustomerTel)

OrderItemNo(OderItemNo, OderNo, PartNo, OrderQty)

Orders (OrderNo, CustomerRef, OrderDate)

PartTypes (PartTypeCode, PartTypeDescription)

PurchaseOder(PONo , PODate , PartNo , POQty)

Supplier(SupplierRef, SupplierName, SupplierAddress, SupplierContact, SupplierTel)

Part(PartNo, PartName, PartUnit, SupplierRef, StockLevel, MinStockLevel, CosttPrice, SalePrice, Location, PartType)

a) Draw an Entity-Relationship diagram for this database using UML notation. Be sure to include all the entities mentioned above, together with attributes (including primary key attributes), relationships and multiplicity constraints. Note that generalisation/specification will be involved in the ER diagram

b) Translate the ER diagram to relations, represented by their schema. Make sure that you apply the correct translation strategies based on the type of relationships in the ER diagram.

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 Databases Questions!

Tables : Customer ( CustomerRef , CustomerFirstName , CustomerSurname , CustomerAddress , CustomerTel) OrderItemNo( OderItemNo , OderNo, PartNo, OrderQty) Orders ( OrderNo , CustomerRef, OrderDate)...

The Marketing Department has asked you to develop a query that will tell them the total number of orders placed by each customer. In the query output they want the customer name listed starting with...

Modify your query to include all students, regardless of whether they registered in Adv. Pastels, starting October 1, 2013. Include, in this order, Customer LastName, CustomerFirstName, Phone,...

3.53 Write and run an SQL query to list all students registered in Adv Pastels starting on October 1, 2019. Include, in this order, Course. CourseDate, Fee. CustomerlastName, CustomerFirstName, and...

Write and run an SQL query to list all students registered in Adv. Pastels starting on October 1, 2013. Include in this order, Course, CourseDate, Customer Last Name, Customer FirstName, Phone, Fee,...

Java Homework question: The assignment says I need to make applyInterest an abstract method and then to define find interest in checkingAccount and savingAccount. When I call...

Populate the tables with data. The following is a set of tables for the Art Course database shown in Figure 1-10. For the data for these tables, use the data shown in Figure 1-10. where: CUSTOMER...

MySQL Q.1) (25 points) Use the ex database for this question. Write a query that replicates the result set below, matching all data and format aspects, including column headers: customer name...

checking and savings accounts are subclasses of the abstract class bank account. The assignment says thAT New accounts are to be created as shown in the main method below (EX:...

Write and run an SQL query to list all students and courses they are registered for. Include, in this order, CustomerNumber, Customer Last Name, Customer FirstName, Phone, CourseNumber, and Amount...

The cost of equity from retained earnings can be expressed as the constant growth rate of dividends O the sum of the expected dividend yield and the expected capital gains yield the difference...

The future value of an investment is how much it will be worth at some time in the future assuming a constant growth rate. The future value formula below can be used to compute how much an investment...

Your hit rate is also called your sales rate true 4 . 4 .

a. The heat of sublimation for a substance is 72.9 kJ/mol. How much energy is needed to sublime 15.0 grams of the substance? (Molar mass given = 128.17 g/mol) b. How much energy is needed to heat...

What tends to skew and distort Average Salaries in most Gender Pay Equity Studies?

The FedScope employment database has a number of Dimension Tables and a Single Fact Table, as shown in Table 7.1. Which columns/data elements in the Fact Table would be most useful in Pay Equity...

After Defining and Building a Multidimensional OLAP Cube, what is stored in the Cube?