NEWSPAPER BUSINESS OWNER Newspaper Name Street City Zip_Code Tel_No Fax_No Conta

Question

NEWSPAPER BUSINESS OWNER Newspaper Name Street City Zip_Code Tel_No Fax_No Contact Name B_Owner No Contact Name BusinessType One possible relational schema for Assignment #2 ADVERTISEMENT OWNER Advert No Ad_Date Newspaper Name CostAd_Detail Property_No Owner NoNameTel No Street City Zip_Code OwnerType PROPERTY _NOT_FOR_RENT Property No WithdrawalDate PROPERTY F Property No Street AreaCity Zip_Code |Type RoomsRForRent Branch No Owner NoS Responsible_ Staff INSPECTION InspectionDate CommentsStaff No Property No

Explanation / Answer

Below is the script to create the Database Schema for mentioned tables in the image,

**************************************************************************************************************

CREATE DATABASE IF NOT EXISTS ADVERTISEMENT;
USE ADVERTISEMENT;

CREATE TABLE IF NOT EXISTS NEWSPAPER(
Newspaper_Name varchar2(50) PRIMARY KEY,
Street varchar2(50),
City varchar2(50),
Zip_Code varchar2(10),
Tel_No varchar2(20),
Fax_No varchar2(50),
Contact_Name varchar2(50)
)

CREATE TABLE IF NOT EXISTS BUSINESS_OWNER(
B_OWNER_No varchar2(50) REFERENCES OWNER(Owner_No),
Contact_Name varchar2(50),
Business_Type varchar2(50)
)

CREATE TABLE IF NOT EXISTS ADVERTISEMENT(
Advert_No varchar2(50) PRIMARY KEY,
Ad_Date date,
Newspaper_Name varchar2(50) REFERENCES NEWSPAPER(Newspaper_Name),
Cost double,
Ad_Detail varchar2(150),
Property_No varchar2(20) REFERENCES PROPERTY_FOR_RENT(Property_No)
)

CREATE TABLE IF NOT EXISTS PROPERTY_FOR_RENT(
Property_No varchar2(20) PRIMARY KEY,
Street varchar2(20),
Area varchar2(20),
City varchar2(20),
Zip_Code varchar2(10),
Type varchar2(20),
Rooms varchar2(20),
Rent double,
ForRent varchar2(20),
Branch_No varchar2(20) REFERENCES BRANCH(Branch_No),
Owner_No varchar2(20) REFERENCES BRANCH(Owner_No),
Responsible_No varchar2(20) REFERENCES RESPONSIBLITY(Responsible_No)
)

CREATE TABLE IF NOT EXISTS
OWNER(
OWNER_No varchar2(50) PRIMARY KEY,
Name varchar2(20),
Tel_No varchar2(20),
Street varchar2(20),
City varchar2(20),
Zip_Code varchar2(20),
OwnerType varchar2(20)
)

CREATE TABLE IF NOT EXISTS
PROPERTY_NOT_FOR_RENT(
Property_No varchar2(20) REFERENCES PROPERTY_FOR_RENT(Property_No),
WithdrawlDate date)

CREATE TABLE IF NOT EXISTS
INSPECTION(
InspectionDate date PRIMARY KEY,
Comments varchar2(20) ,
Staff_No varchar2(20) REFERENCES STAFF(Staff_No),
Property_No varchar2(20) REFERENCES PROPERTY_FOR_RENT(Property_No)
)

********************************************************************************************************

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

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