MANAGEMENT INFORMATION SYSTEM ASSIGNEMNT

CLO 3 Develop relational database for business cases CLO4 Utilize Internet and business applications to appraise business solutions

the topic is . Yoga Zen Reservation

Yoga Zena Studio is one of the premier Yoga schools in Dubai. Customers can make reservations on any Yoga classes based on their needs. Different classes are listed on their website with prices for each. class reservations must indicate class date, time, price, class level, the teacher who will teach, and lesson status code (completed, cancelled, in progress).

Customers details are saved in the DB, such as the date they became customers, DOB, customer status (New, regular), first and last name, amount of fees outstanding, email address, and phone number. Class payments are recorded separately indicating payment method (credit card, cash), date and time, and amount paid.

Deliverable 1: Report (11 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 Table of content outlining the layout of your report (0.5 Marks)
• c) Technical & economic feasibility studies for phase 1 (2 Marks)
• d) Detail user requirements including business rules for phase 2 (2 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 (3 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 (2 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 (1 Marks)