Project covers CLO 3 – “Develop relational database for business cases”

SWS 351 – MIS
Database Project
Project covers CLO 3 – “Develop relational database for business cases”
Total of 20 Marks
You have been tasked to design and build a working database for your small startup company in
Dubai. Write a report using the SDLC model below outlining the steps taken in each phase to
develop your database. Your report should include:
a) A cover page with your details (0.5 Marks)
b) A TOC outlining the layout of your report (0.5 Marks)
c) Technical & economic feasibility studies for phase 1 (3 Marks)
d) Detail user requirements including business rules for phase 2 (3 Marks)
e) Detailed system design that includes your final DB proposal with all required tables and
fields, entity relationship (ER) diagrams and a sample GUI for the database for phase 3 (6
Marks)
f) Detailed code for the implementation of your database showing SQL code to create DB
and tables with all necessary keys (Primary & Foreign), code to insert, modify, and delete
data into the tables, and a sample SQL code to retrieve data for phase 4 (5 Marks)
g) What conversion strategy you intend to adopt in the installation of the DB and how you
plan to maintain the new software for phase 5 (2 Mark)
Pick one of the topics below for your project. The project can be done individually or as a group
of 2 students. Submit your report using the TurnitIn link on Moodle by 2pm of the due date. No
late submissions will be accepted. A similarity score of more than 20% will result in a grade of
zero.
1. Apartment Booking
Canadian Apt Rentals own several apt buildings in Dubai. Each building has a name (short name
and full name), description, address, phone number and manager in charge of it.
Several apts are offered for rental in different buildings across the city. These apts must be
identified based on the apt type (beach front, city view, ocean view, family apt, luxury, economy,
etc.), apt number, bathroom count, bedroom count, other rooms available.
Guests can book an apt any day of the year and must indicate the booking start and end date and
display the booking status. The reservation system must also record the guest first name, last
name, DOB, and gender.
2. Customer Events Reservations
Canadian Event Master is a small company that manages customer bookings for events in Dubai.
Each event is classified by the event type (religious or not, music, stand-up comedy etc.), venue,
event name, and the dates the events begin and end. Each venue has a certain seat capacity.
Customers can book an event indicating the number of seats they need. Customer seating is on a
first-come-first-serve basis. Booking customers must provide their names, phone number, email
address, physical address, payment method, and the details of their payments.
3. Health Center Patient Reservation
Canadian Health Systems is a private company that handles patient clinic reservations in Dubai.
Patients call to make appointments to see a doctor and record any medications issued from the
clinic pharmacy.
A patient is required to provide their first, middle, and last names when booking an appointment.
They also need to provide their DOB, gender, and home address. Doctor appointments require
the patient details and the doctor information they want to see, including the date and time of
the appointment. Patients medications and prescriptions are saved with information including
the medication type (headache, stomachache, flue, cold, skin care, etc.), medication name,
description, and cost.
4. Driving School Reservation
Canadian Driving Institution is one of the premier driving schools in Dubai. Customers can make
reservations on any driving lessons based on their needs. Different lessons are listed on their
website with prices for each. Lesson reservations must indicate lesson date, time, price, vehicle
detail, the staff who will instruct, and lesson status code (completed, cancelled, in progress, etc.).
Customers details are saved in the DB, such as the date they became customers, DOB, customer
status (Good, bad, regular, etc.), first and last name, amount of fees outstanding, email address,
and phone number. Lesson payments are recorded separately indicating payment method (credit
card, cash), date and time, and amount paid.