Database Design Create a relational database schema for the given database, whic

Question

Database Design

Create a relational database schema for the given database, which described by the following relations and Insert tuples (this is one large database, with each table separated by letter indication below). Model example can look like this, but obviously with relevant data pertaining to the information below.

A.

CAR (Serial_No, Model, Manufacturer, Price)
OPTION(Serial_No, Option_Name, Price)
SALE(Salesperson_ID, Serial_No, Date, Sale_Price)
SALESPERSON(Salesperson_ID, Name, Phone)

B.

SALESPERSON(Ssn, Name, Start_Year, Dept_No)
TRIP(Ssn, From_City, To_City, Departure_Date, Return_Date, Trip_ID)
EXPENSE(Trip_ID, Account#, Amount)

C.

CATALOG(Cno, Ctitle)
STUDENTS(Sid, Fname, Lname, Minit)
COURSES(Term, Sec_No, Cno)
ENROLLS(Sid, Term, Sec_No)

D.

SUPPLIER(Sno, Sname)
PART(Pno, Pname)
PROJECT(Jno, Jname)
SUPPLY(Sno, Pno, Jno)

E.

EMPLOYEE (Employee_Name, Street, City)
WORKS (Employee_Name, Company_Name, Salary)
COMPANY (Comapny _Name, City)
MANAGES (Employee_Name, Manager_Name)

DoB FirstName Year Semester Mark Grade Name LastName Student D Enroll Year Pro am ID Student N Enroll 1 Program CreditPoint YearStarted Contains ttempt Semester Year Course Year Started Name Course ID CreditPoint

Explanation / Answer

A.

Create table CAR (Serial_No number(20),Model varchar(20),Manufacturer varchar(20),Price varchar(30));

Create table OPTION (Serial_No number(20),Option_Name varchar(20),Price varchar(20));

Create table SALE (Serial_No number(20),Salesperson_ID varchar(20),Sale_Price varchar(20),Date date);

Create table SALESPERSON (Serial_No number(20),Model varchar(20),Manufacturer varchar(20));

B.

create table SALESPERSON(Ssn varchar(20), Name varchar(20), Start_Year number(5), Dept_No number (10));

create table TRIP(Ssn varchar(20), From_City varchar(10), To_City varchar (20), Departure_Date date, Return_Date date, Trip_ID varchar(20));

create table EXPENSE(Trip_ID varchar(20), Account# varchar(20), Amount varchar(10));

C.

create table CATALOG(Cno varchar(20), Ctitle vrchar(20));

create table STUDENTS(Sid varchar(20), Fname varchar(20), Lname varchar(20), Minit varchar(20));

create table COURSES(Term varchar(20), Sec_No varchar(20), Cno varchar(20));

create table ENROLLS(Sid varchar(20), Term varchar(20), Sec_No varchar(20));

D.

create table SUPPLIER(Sno varchar(20), Sname varchar(20));

create table PART(Pno varchar(20), Pname varchar(20));

create table PROJECT(Jno varchar(20), Jname varchar(20));

create table SUPPLY(Sno varchar(20), Pno varchar(20), Jno varchar(20));

E.

create table EMPLOYEE (Employee_Name varchar(20), Street varchar(20), City varchar(20));

create table WORKS (Employee_Name varchar(20), Company_Name varchar(20), Salary varchar(20));

create table COMPANY (Comapny _Name varchar(20), City varchar(20));

create table MANAGES (Employee_Name varchar(20), Manager_Name varchar(20)) ;

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.