Step 1. Using Oracle, create the tables identified below in the following order:

Question

Step 1.

Using Oracle, create the tables identified below in the following order:

DATABASE TABLES:

Apartment_Building_TBL (BuildingID, BuildingName, Street, City, State, Zip, Phone)
Employer_TBL (EmployerID, CompanyName, Street, City, State, Zip, Phone, ContractDiscount)
Apartment_Type_TBL(ApartmentTypeID, ApartmentType, PricePerNight)
Apartment_TBL (ApartmentID, AptNumber, AptFloor, BuildingID, ApartmentTypeID, AptAvailable)
Trainee_TBL (TraineeID, LastName, FirstName, PermStreet, PermCity, PermState, PermZip, PermPhone, EmployerID)
Apartment_Rental_TBL (RentalID, CheckInDate, CheckOutDate, ApartmentPhone, ApartmentID, TraineeID)

STRUCTURE NOTES:

Help will be much appreciated.

Explanation / Answer

1)

create table Apartment_Building_TBL

(BuildingID Number(2),

BuildingName varchar2(50) not null,

Street varchar2(50),

City varchar2(50),

State varchar2(50),

Zip Number,

Phone Number,

CONSTRAINT ABTBL_BuildID_PK PRIMARY KEY (BuildingID));

2)

create table Employer_TBL

(EmployerID Number(2),

CompanyName varchar2(50) not null,

Street varchar2(50),

City varchar2(50),

State varchar2(50),

Zip number,

Phone number,

ContractDiscount number(20,3),

CONSTRAINT EmpTbl_EmpID_PK PRIMARY KEY (EmployerID));

3)

create table Apartment_Type_TBL

(ApartmentTypeID number(2),

ApartmentType varchar2(50),

PricePerNight number(20,2),

CONSTRAINT ApmntTypeTbl_ApmntTypeID_PK PRIMARY KEY (ApartmentTypeID));

4)

create table Apartment_TBL

(ApartmentID number(2),

AptNumber number,

AptFloor varchar2(25),

BuildingID number(2),

ApartmentTypeID number(2),

AptAvailable Varchar2(3),

CONSTRAINT ApmntTbl_ApmntID_PK PRIMARY KEY (ApartmentID),

CONSTRAINT ABTBL_BuildID_FK FOREIGN KEY (BuildingID) REFERENCES Apartment_Building_TBL(BuildingID),

CONSTRAINT ApmntTypeTbl_ApmntTypeID_FK FOREIGN KEY (ApartmentTypeID) REFERENCES Apartment_Type_TBL(ApartmentTypeID));

5)

create table Trainee_TBL

(TraineeID Number(2),

LastName varchar2(25) not null,

FirstName varchar2(25) not null,

PermStreet varchar2(25),

PermCity varchar2(25),

PermState varchar2(25),

PermZip number,

PermPhone number,

EmployerID number(2),

CONSTRAINT TrainTbl_TrainID_PK PRIMARY KEY (TraineeID),

CONSTRAINT EmpTbl_EmpID_FK FOREIGN KEY (EmployerID) REFERENCES Employer_TBL(EmployerID));

6)

create table Apartment_Rental_TBL

(RentalID number(2),

CheckInDate date,

CheckOutDate date,

ApartmentPhone number,

ApartmentID number(2),

TraineeID number(2),

CONSTRAINT RentalTbl_RentID_PK PRIMARY KEY (RentalID),

CONSTRAINT ApmntTbl_ApmntID_FK FOREIGN KEY (ApartmentID) REFERENCES Apartment_TBL(ApartmentID),

CONSTRAINT TrainTbl_TrainID_FK FOREIGN KEY (TraineeID) REFERENCES Trainee_TBL(TraineeID));

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

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