In Microsoft Word, write the SQL statements to create the database and tables. W
ID: 3662224 • Letter: I
Question
In Microsoft Word, write the SQL statements to create the database and tables.
Write SQL statements to populate the tables. Run the SQL statements in Microsoft Access for populating the tables.
Creating tables:
CREATE TABLE Student (
Student_ID number primary key,
Student_Name varchar2(20) not null,
Phone_Number number(10),
Year timestamp,
Course_ID number references Course
);
CREATE TABLE Course (
Course_ID number primary key,
Course_Name varchar2(20) not null,
Faculty_ID number references Faculty,
Duration number,
Number_of_seats number not null
);
CREATE TABLE Faculty (
Faculty_ID number primary key,
Faculty_Name varchar2(20) not null,
Course_ID number references Course,
Phone_Number number
);
CREATE TABLE Scholarship(
Scholarship_ID number primary key,
Scholarship_Name varchar2(20) not null,
TotalAmount number,
Student_ID number references Student
);
CREATE TABLE DisciplinaryAction
DisciplinaryAction_ID number primary key,
DisciplinaryAction_Name varchar2(20) not null,
DisciplinaryAction_Period number,
Student_ID number references Student
);
CREATE DATABASE Car_Rental(
Car_Rental_ID int primary key,
Agency varchar(25),
Size varchar(25),
Make varchar(25),
Model varchar(25),
Daily_Cost Currency
);
In Microsoft Word, write the SQL statements to create the database and tables.
Write SQL statements to populate the tables. Run the SQL statements in Microsoft Access for populating the tables.
Creating tables:
CREATE TABLE Student (
Student_ID number primary key,
Student_Name varchar2(20) not null,
Phone_Number number(10),
Year timestamp,
Course_ID number references Course
);
CREATE TABLE Course (
Course_ID number primary key,
Course_Name varchar2(20) not null,
Faculty_ID number references Faculty,
Duration number,
Number_of_seats number not null
);
CREATE TABLE Faculty (
Faculty_ID number primary key,
Faculty_Name varchar2(20) not null,
Course_ID number references Course,
Phone_Number number
);
CREATE TABLE Scholarship(
Scholarship_ID number primary key,
Scholarship_Name varchar2(20) not null,
TotalAmount number,
Student_ID number references Student
);
CREATE TABLE DisciplinaryAction
DisciplinaryAction_ID number primary key,
DisciplinaryAction_Name varchar2(20) not null,
DisciplinaryAction_Period number,
Student_ID number references Student
);
CREATE DATABASE Car_Rental(
Car_Rental_ID int primary key,
Agency varchar(25),
Size varchar(25),
Make varchar(25),
Model varchar(25),
Daily_Cost Currency
);
Explanation / Answer
Creating tables:
CREATE TABLE Student(
Student_ID number primary key,
Student_Name TEXT(20) not null,
Phone_Number TEXT(10),
Year timestamp,
Course_ID number references Course
);
CREATE TABLE Course(
Course_ID number primary key,
Course_Name TEXT(20) not null,
Faculty_ID number references Faculty,
Duration number,
Number_of_seats number not null
);
CREATE TABLE Faculty(
Faculty_ID number primary key,
Faculty_Name TEXT(20) not null,
Course_ID number references Course,
Phone_Number number
);
CREATE TABLE Scholarship(
Scholarship_ID number primary key,
Scholarship_Name TEXT(20) not null,
TotalAmount number,
Student_ID number references Student
);
CREATE TABLE DisciplinaryAction(
DisciplinaryAction_ID number primary key,
DisciplinaryAction_Name TEXT(20) not null,
DisciplinaryAction_Period number,
Student_ID number references Student
);
After creating the database, we insert data into tables
Insert values Table student:
INSERT INTO student VALUES (1,'Armando', '987654321', '1978-12-13', 1);
INSERT INTO student VALUES (2,'John', '963852741', '1968-01-23', 1);
INSERT INTO student VALUES (3,'Maria', '147258369', '1958-11-30', 1);
INSERT INTO student VALUES (4,'Nicholas', '951753624', '1998-09-03', 1);
Insert values Table Course:
INSERT INTO Course VALUES (1,'Math', 1, 30, 20);
INSERT INTO Course VALUES (2,'Physical', 2, 40, 30);
INSERT INTO Course VALUES (3,'Biology', 2, 30, 25);
INSERT INTO Course VALUES (4,'Art', 1, 20, 35);
Insert values Table Faculty:
INSERT INTO Faculty VALUES (1,'Oxford', 1, '147258369');
INSERT INTO Faculty VALUES (2,'MIT', 2, '258369147');
Insert values Table Scholarship:
INSERT INTO Scholarship VALUES (1,'Dining area', 500, 1);
INSERT INTO Scholarship VALUES (2,'Dining area', 300, 2);
INSERT INTO Scholarship VALUES (3,'Cleaning', 1500, 3);
Insert values Table DisciplinaryAction:
INSERT INTO DisciplinaryAction VALUES (1,'Suspension', 10, 1);
INSERT INTO DisciplinaryAction VALUES (2,'Suspension', 3, 3);
INSERT INTO DisciplinaryAction VALUES (3,'Expulsion', 3, 4);
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.