QuestionQuestion

Write DDL and DML queries of the project.
Make a database for your own imaginary business.
Get SQL code to create these tables:
Store Location - {ID, Address, Phone Num, Store Manager}
Vehicles - {ID, License Plate, Make, Model}
Department - {ID, Dept. Name, Manager, Num of Employees}
Project - {ID, Store Location, Date of Completion, Inventory used}
Employee - {ID, Name, SSN, Department}
Dependents - {ID, Employee ID, Name, Age}
Customer - {ID, Name, Phone Num, Address, Order}
Orders - {ID, Customer ID, Date of Arrival, Price}
Distributors - {ID, Phone Number, Product Offered, Order ID}
Inventory - {ID, Price, Distributor, In Stock}

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

CREATE TABLE [Customer](
[ID] [int] NOT NULL PRIMARY KEY ,
[Name] [nvarchar](50) NULL,
[PhoneNum] [nvarchar](20) NULL,
[Address] [nvarchar](50) NULL,
[Order] [int] NULL
)
GO
CREATE TABLE [Department](
[ID] [int] NOT NULL PRIMARY KEY ,
[DeptName] [nvarchar](50) NULL,
[ManagerID] [int] NULL,
[NumberOfEmployee] [int] NULL
)
GO
CREATE TABLE [Dependents](
[ID] [int] NOT NULL PRIMARY KEY ,
[EmpoyeeID] [int] NULL,
[Name] [nvarchar](50) NULL,
[Age] [int...
$18.00 for this solution

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Computer Science - Other Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats