Question: Please write a sql code according to this mapping. ER DIAGRAM MAPPING - CUSTOMER [cust id, name , surname, adress, phone_number] - STAFF [staff id,

Please write a sql code according to this mapping.

ER DIAGRAM MAPPING - CUSTOMER [cust id, name , surname, adress, phone_number] - STAFF [staff id, name, surname, hire_date, inventory_id] inventory_id is FK refers to INVENTORY - PRODUCTS[product id, product_name, colour, brand_name, price, category name] - INVENTORY[inventory id, quantity] - HAS [inventory id, product id] inventory_id is FK refers to inventory, product_id is FK refers to PRODUCT - PLACES[customer id, order id] customer_id is FK refers to CUSTOMER, order_id is FK refers to ORDER - INCLUDES[product id, order id] product_id is FK refers to PRODUCT, order_id is FK refers to ORDER - ORDER[customer id, staff id, _product_id, order id, order date, payment_type, total_amount] cust_id is FK refers to CUSTOMER, staff_id is FK refers to STAFF, product_id is FK refers to PRODUCT - BAGS[product id ] product id is FK refers to PRODUCT - SHOES[product_id,_shoe_size] product_id is FK refers to PRODUCT

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!

This our Database Design & Management Project homework and our team dismiss and I alone I need a help very quickly, Down here Project Guidelines ; we did until step 3 but we get fall grades so...

Read and analyse the following specification of a sample database domain. The Eliore \& Eline Inc law firm This firm assists two types of customers; the business people and the public. They are three...

Please write the SQL code in SQL Developer to complete the tasks below. Then click on Write Submission and copy and paste the code into the submission box. This assignment should be completed no...

(Total 10 points) Coursera hires you as a database analyst. You find that the database structure of Coursera is outdated. So, you become a team leader for the new database project. Now, you want to...

1- Select a software application and select one module of that application (For example, UniversitySystem -> Courses registration Module). " I choose the diagram down below." 2- Create the scenarios...

we have these tables: please write the SQL code for the following questions \begin{tabular}{|l|l|l|l|l|l|l|} \hline \multicolumn{6}{|c|}{ employee } & \\ \hline employeeid & \( \begin{array}{l}\text...

Please write a SQL code. . Create a grouped report summarizing data in the PurchaseHistory table by ProductNumber. The report should provide the last date (most recent) that a product was purchased,...

4. (Total 10 points) Coursera hires you as a database analyst. You find that the database structure of Coursera is outdated. So, you become a team leader for the new database project. Now, you want...

Presented below are four statements which you are to identify as true or false. If false, explain why the statement is false. 1. GAAP is the term used to indicate the whole body of FASB authoritative...

For a Y-connected three-phase, eight-pole, interior permanent magnet synchronous motor: the stator coil resistance is 5.67 ml, La = 100 H and L, = 200 H, and the open-circuit phase voltage is Ve = 20...

Due 1 0 a number of lawuits relued to tovic wartec, a major chemical menfacturer has recently experienced a market reevalua ieterest beine paid semiannally. The face value of the bood is $ 1 , 0 0 0...

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

1 It is difficult to manage this process logistically and structurally. Control is difficult and success is highly dependent on the enthusiasm of the team rather than on formalized procedures. A...

2 Are organizational forms and work practices involving lateral and temporal flexibility in the European Union transferable to other regions across the globe?

3 How can knowledge management systems be employed across cultures to better understand and incorporate implicit knowledge within each cultural context?