Question: Need SQL Query of this ERD. help me please. DoD Payment Payment ID (PK) Payment type 1.1 Payment date Total price Update to 1.1 1..1

Need SQL Query of this ERD. help me please.

DoD Payment Payment ID (PK) Payment type 1.1 Payment date Total price Update to 1.1 1..1 Staff inform Staff ID (PK) Staff Name Position Telephone No E-Mail Address 0.. 1.. 1..1 Customer Customer ID (PK) Customer Name E-Mail Address Telephone No. Address Ordered product Item quantity 1.. Deliver Shipment Shipment ID {PK) Shipment type Shipment Company name Shipment price 1..1 1..1 Admin Send Product Supplier Supplier ID {PK) Supplier Name E-Mail Address Telephone No 1... Admin_id {pk) Admin name Admin password * , , , 1.- Buy D Product Product ID (PK) Product Name Product category Product price Add 0.. 1.. 1... Check buyDate Order quantity Total order price

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!

need perfrom select, join, Sum, Avg, Alter table of this --Customer Table. create table customers Customer_id number(10) primary key. customer_name varchar(10). mail varchar(201. telephone number)...

need perfrom select, join, Sum, Avg, Alter table of this. DoD Payment Payment ID (PK) Payment type 1.1 Payment date Total price Update to 1.1 1..1 Staff inform Staff ID (PK) Staff Name Position...

please do Conceptual Design (cERD) Logical ERD with relational schema Normalization DoD Payment Payment ID (PK) Payment type 1.1 Payment date Total price Update to 1.1 1..1 Staff inform Staff ID (PK)...

need to do Relational database schemas. Set of queries (minimum 15 queries ) for each transaction for all users. ERD Do Payment Payment ID {PK) Payment type Payment date Total price Update to 1..1...

need perfrom select, join, Sum, Avg, Alter table of this. ERD Do Payment Payment ID {PK) Payment type Payment date Total price Update to 1..1 1..1 1..1 Staff 1..1 Inform Staff ID (PK) Staff Name...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

This policy will be reviewed no later than 5 years of its authorisation date. At this point it will need to be re-authorised by the relevant authority at Xxz Financial Services Version Published...

using mysql command line Mediveron Clinic is a family clinic that provides a wide range of family health services, including advice on health problems, vaccinations, examinations and treatment,...

Prepare a Statement of Advice (SOA) for the Martins interviewed for Assignment 1. The case study information is attached as a picture at the bottom of the page. As this assignment is to be a SOA for...

If you are creating a model and one of the key considerations is which port of entry you should use, why would you model the port like you would model a warehouse? What costs would be relevant for...

Suppose you started up your own landscaping business. A customer paid you $170 in advance to mow his or her lawn while he or she was on vacation. You performed landscaping services for a local...

If the child's interest and dividend income in 2 0 2 3 ( including capital gain distributions ) total less than _ _ _ _ _ _ _ _ , the child's parent may be able to choose to include that income on...

Data-Driven Business Modeling Q1. Determine the optimal allocation plan for employees in the five groups to the four stations. Formulate the problem by an integer program in a mathematical model....

=+Duration (and especially the number of days out of the home country in a particular tax year) usually has important tax ramifications for the employee (and for the employer, if it is taking...

=+3 What is the anticipated duration of the international assignment? Is it a shortterm assignment (usually less than one year and probably within the same calendar/tax year) or long-term...

=+4 What happens with the IA at the end of the assignment? What are the repatriation plans for the IA upon completion of the assignment? Is the employee returning to the home country, continuing in...