Entity Relationship Diagram for Ace Software, Inc.

Entity Relationship Diagram:
Figure 1: Entity Relationship Diagram of Ace Software, Inc.
(Source: Created by Author)

1. Create Tables:
CREATE TABLE Customer
(
accountNumber NUMBER(11),
cus_name VARCHAR2(200),
street VARCHAR2(200),
city VARCHAR2(200),
zip NUMBER(6),
contactNumber NUMBER(10),
CONSTRAINT customer_pk PRIMARY KEY (accountNumber)
);
CREATE TABLE Customer_Rent
(
rentID NUMBER(11),
customer NUMBER(11),
rentDate DATE,
expectedReturnDate DATE,
actualReturnDate DATE,

totalPay NUMBER(6,2),
CONSTRAINT rent_pk PRIMARY KEY (rentID),
FOREIGN KEY (customer) REFERENCES Customer (accountNumber) ON DELETE
SET NULL
);
CREATE TABLE Fees
(
feeID NUMBER(11),
rentID NUMBER(11),
type VARCHAR2(200),
amount NUMBER(6,2),
CONSTRAINT fees_pk PRIMARY KEY (feeID),
FOREIGN KEY (rentID) REFERENCES Customer_Rent (rentID)
);
CREATE TABLE Movie
(
movieID NUMBER(11),
title VARCHAR2(200),
genre VARCHAR2(200),