System Analysis and Design

Running head: SYSTEM ANALYSIS AND DESIGN
System Analysis and Design
Name of the Student:
Name of the University:
Author Note

1
SYSTEM ANALYSIS AND DESIGN
List of Entities and Attributes
The identified list of entities is provided below:
 Staffs
 Addresses
 Customer
 Rentals
 Reservation
 Vehicle
 Vehicle Category
The identified list of attributes for each of the entities are provided below:
 Staffs: StaffNumber, FName, LName, HomeAddress, Gender, DateOfBirth,
OfficeNumber, OfficePhoneNumber
 Addresses: HomeAddress, StreetNumber, Suburd, Post-Code, City, State
 Customer: CustomerNumber, FirstName, LastName, HomeAddress, Gender,
DateOfBirth, TelephoneNumber, DriverLicenseNumber
 Rentals: RentID, RegistrationNumber, CustomerNumber, Borrow_Date, Return_Date,
TotalCost, StaffNumber, VehicleCondition
 Reservation: ReservationID, RegistrationNumber, CustomerNumber,
ReservationPeriod, TotalCost, StaffNumber, VehicleCondition
 Vehicle: RegistrationNumber, CategoryName, Make, Model, Colour,
Rental_Price/Day
 Vehicle Category: CategoryName, Rental_Charges, NumberOSeats
After the identification of the list of entities and attributes the logical model can be
created as defined below:

2
SYSTEM ANALYSIS AND DESIGN
Staffs (StaffNumber (primary key), FName, LName, HomeAddress (foreign key), Gender,
DateOfBirth, OfficeNumber, OfficePhoneNumber)
Addresses: HomeAddress (primary key), StreetNumber, Suburd, Post-Code, City, State
Customer: CustomerNumber (primary key), FirstName, LastName, HomeAddress (foreign
key), Gender, DateOfBirth, TelephoneNumber, DriverLicenseNumber
Rentals: RentID (primary key), RegistrationNumber (foreign key), CustomerNumber (foreign
key), Borrow_Date, Return_Date, TotalCost, StaffNumber, VehicleCondition
Reservation: ReservationID (primary key), RegistrationNumber (foreign key),
CustomerNumber (foreign key), ReservationPeriod, TotalCost, StaffNumber,
VehicleCondition
Vehicle: RegistrationNumber (primary key), CategoryName (foreign key), Make, Model,
Colour, Rental_Price/Day
Vehicle Category: CategoryName (primary key), Rental_Charges, NumberOSeats