(THIS QUESTION HAS BEEN REJECTED MULTIPLE TIMES, PROVIDE PROPER REASONING BEFORE YOU REJECT AGAIN, NOT LOOKING TO FILL ALL THE DATA IN THE TABLE BUT SAMPLE QUERIES) I need help with sql queries to create a database and appropriate tables as listedNeed tables created, set constraints on attributes, set the relationship between the entities in the DB.(Looking for detailed SQL queries.)example: CREATE DATABASE my_records;use my_records;Create TablesCREATE TABLE `parts` (`parts_num` varchar(255) NOT NULL,`description_parts` varchar(255) NOT NULL); ### Scenario 2 - Educational Database Design ExampleThis is a sample list table used by a company to track parts that they sell and the orders that they receive for purchasing those parts. This table is not a database, but a flat one table file. The goal is to design a database for the company so they no longer have to rely on a simple 1 table list system for data management. By analyzing the table below, you will identify the distinct entities and attributes necessary to design a logical level Entity Relationship Diagram (ERD) for the company.#### Sample List Table| OrderNum | OrderDate | PartNum | Description | NumOrdered | QuotedPrice ||----------|------------|---------|-------------------|-------------|--------------|| 21608 | 10/20/2010 | AT94 | Iron | 11 | $21.95 || 21610 | 10/20/2010 | DR93 | Gas Range | 1 | $495.00 || 21610 | 10/20/2010 | DW11 | Washer | 1 | $399.99 || 21613 | 10/21/2010 | KL62 | Dryer | 4 | $329.95 || 21614 | 10/21/2010 | KT03 | Dishwasher | 2 | $595.00 || 21617 | 10/23/2010 | BV06 | Home Gym | 2 | $794.95 || 21617 | 10/23/2010 | CD52 | Microwave Oven | 4 | $150.00 || 21619 | 10/23/2010 | DR93 | Gas Range | 1 | $495.00 || 21523 | 10/23/2010 | KV29 | Treadmill | 2 | $1290.00 |### Analysis for Entity Relationship Diagram (ERD)#### Identified Entities and Attributes:1. **Orders** - OrderNum (Primary Key) - OrderDate2. **Parts** - PartNum (Primary Key) - Description - QuotedPrice3. **OrderDetails**

The dependency diagram for the given table is as follows: The table needs to be broken down into…

Answered: This is a simple list table of a…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

(THIS QUESTION HAS BEEN REJECTED MULTIPLE TIMES, PROVIDE PROPER REASONING BEFORE YOU REJECT AGAIN, NOT LOOKING TO FILL ALL THE DATA IN THE TABLE BUT SAMPLE QUERIES)

I need help with sql queries to create a database and appropriate tables as listed

Need tables created, set constraints on attributes, set the relationship between the entities in the DB.

(Looking for detailed SQL queries.)

example:

CREATE DATABASE my_records;
use my_records;

Create Tables

CREATE TABLE `parts` (

`parts_num` varchar(255) NOT NULL,
`description_parts` varchar(255) NOT NULL
);

### Scenario 2 - Educational Database Design Example

This is a sample list table used by a company to track parts that they sell and the orders that they receive for purchasing those parts. This table is not a database, but a flat one table file. The goal is to design a database for the company so they no longer have to rely on a simple 1 table list system for data management. By analyzing the table below, you will identify the distinct entities and attributes necessary to design a logical level Entity Relationship Diagram (ERD) for the company.

#### Sample List Table

| OrderNum | OrderDate | PartNum | Description | NumOrdered | QuotedPrice |
|----------|------------|---------|-------------------|-------------|--------------|
| 21608 | 10/20/2010 | AT94 | Iron | 11 | $21.95 |
| 21610 | 10/20/2010 | DR93 | Gas Range | 1 | $495.00 |
| 21610 | 10/20/2010 | DW11 | Washer | 1 | $399.99 |
| 21613 | 10/21/2010 | KL62 | Dryer | 4 | $329.95 |
| 21614 | 10/21/2010 | KT03 | Dishwasher | 2 | $595.00 |
| 21617 | 10/23/2010 | BV06 | Home Gym | 2 | $794.95 |
| 21617 | 10/23/2010 | CD52 | Microwave Oven | 4 | $150.00 |
| 21619 | 10/23/2010 | DR93 | Gas Range | 1 | $495.00 |
| 21523 | 10/23/2010 | KV29 | Treadmill | 2 | $1290.00 |

### Analysis for Entity Relationship Diagram (ERD)

#### Identified Entities and Attributes:

1. **Orders**
- OrderNum (Primary Key)
- OrderDate

2. **Parts**
- PartNum (Primary Key)
- Description
- QuotedPrice

3. **OrderDetails**

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions