Get in Touch

IDB Assignment Question

IDB Assignment Question
Assignment world

assignment_nepal_world

227 posts 56K followers 1,666 following Assignment World Nepal โœจ Education ๐Ÿ‡ฌ๐Ÿ‡ง๐Ÿ‡ณ๐Ÿ‡ต๐Ÿ‡บ๐Ÿ‡ฒ๐Ÿ‡ฉ๐Ÿ‡ฐ๐Ÿ‡ธ๐Ÿ‡ช๐Ÿ‡จ๐Ÿ‡ญ Sunderland,British,Islington and others Secure๐Ÿค๐Ÿ”/Fast delivery๐Ÿšš ๐Ÿ“ˆ A+ Solutions ๐ŸŽ“๐Ÿ“ Turnitin Verified #THESIS๐Ÿงพ #FYP๐ŸŽ“ assignmentnepalworld.com

IDB Assignment Question

CT042-3-1-IDB Group Assignment Page 1 of 4

Module Learning Outcomes:

โ€ข Apply redundancy control in designing a database.

โ€ข Demonstrate a database solution using an appropriate tool based on a case study.

Case Study:

Hotel Booking Management System

X Hotel is a growing hotel business who owns multiple branches throughout various states in Malaysia. As their business expands, X Hotel wants to implement an online booking system to facilitate and manage customer bookings. The system should handle various aspects of hotel operations including room availability, customer information, room reservation, and billing. Your team is assigned to design and implement a database system for the Hotel Booking Management System.

Scenario:

โ€ข Given that X Hotel has multiple branches, each branch is managed by its own manager. The details of each branch manager need to be recorded in the database, as it is valuable for internal communication and enhancing customer service.

โ€ข Each branch offers different number of rooms, which can be summarized into three types: standard double, standard twin, and deluxe double. The database should store details for each room such as its capacity, room rate, etc.

โ€ข Customers must first register as members before making room reservation. During the registration process, they are required to provide their first name, last name, contact number, email address and mailing address. The system should prevent customers from registering with the same email address more than once.

โ€ข Customer can reserve multiple rooms at a single branch with one booking provided the rooms are available. Reservations for different branches must be made separately. Each reservation must include details like booking date, check-in and check-out date, and emergency contact. Besides, the system allows customer to add special requests and preferences for each booking such as late check-in, non-smoking room, etc.

โ€ข Invoice will be sent once customer made the payment. Every invoice has an invoice identification number and total amount paid. To ensure high level of customer satisfaction, customers can leave rating as a score (1=Very Dissatisfied, 2=Dissatisfied, 3=Neutral, 4=Satisfied, 5=Very Satisfied) along with short text review after their stay.

*Note: you may make any other assumptions after discussing them with module lecturer

Level 1 Asia Pacific University of Information & Technology 072024

CT042-3-1-IDB Group Assignment Page 2 of 4

Coursework Details:

1. In this assignment, you are required to design, implement, and document a database system for a hotel booking management system.

2. Create the following queries using Data Manipulation Language (DML) โ€“ student must be able to explain the queries.

i. Display the customers who have not make any reservation since the beginning of 2023. The result should include first name, last name, email address, and contact number.

ii. Display the monthly revenue for the year 2023 and sort the results in descending order by monthly revenue.

iii. Display all customers have make more than 3 reservations in the year of 2023. iv. Display the average rating and total number of reviews for each room type at the Kuala Lumpur branch.

v. Display the total revenue generated by each branch for the year 2023. vi. Display the names of customers and the total amount they spent in the year of 2023.

vii. Display the average and total spending by gender for the year 2023. viii. Display the branch id, address, managerโ€™s name, and the total number of rooms for each branch.

ix. Display the customer with highest number of reservations and show their average amount spent for the year 2023.

x. Display the customer who have stayed more than one branch in 2023.

Level 1 Asia Pacific University of Information & Technology 072024

CT042-3-1-IDB Group Assignment Page 3 of 4

3. Deliverables – Minimum requirement of your documentation:

Part

Component

1

a) Database and Database Management System

โ€ข Discuss the disadvantages of file-based system, relate your discussion to the case study

โ€ข Discuss the advantages of Database and DBMS, functions of DBMS, relate your discussion to the case study

1

b) Business Rules & Normalization

โ€ข Generate a list of business rules

โ€ข Provide an example of UNF according to case study, then perform normalization up to 3NF clearly showing all the steps with explanation

1

c) Entity Relationship Diagram

โ€ข Design the database using chenโ€™s or crowโ€™s foot notation, draw the ERD with any suitable tools such as Visio. All entities, attributes, relationship and constraints should be shown clearly.

2

d) Database Schema

โ€ข Re-submit the Entity Relationship Diagram, you may make changes to the ERD submitted in Part 1

โ€ข Generate the database diagram from the DBMS

2

e) SQL-Data Definition Language (DDL)

โ€ข Create all tables with suitable data types and constraint

โ€ข Screen shot all tables with its data

โ€ข Screen shot all query statements

2

f) SQL-Data Manipulation Language (DML)

โ€ข Write SQL statements to answer question (2) above

โ€ข Screen shot all query statements together with its executed result

Level 1 Asia Pacific University of Information & Technology 072024

CT042-3-1-IDB Group Assignment Page 4 of 4

General Requirements:

In this assignment you are required to:

โ€ข Work a group of 3-4 members.

โ€ข Design and implement a solution to a business problem.

โ€ข Implement the solution using any Enterprise DBMS.

โ€ข Document the solution as set out in the assignment requirements.

โ€ข Submit the document online according to the date and time given below. โ€ข Each group member is required to participate in all tasks / discussions together. โ€ข Presentation schedules will be published at a later date through MS TEAMS.

Note: It is acceptable for discrete activities of this assignment to be undertaken by individual group members. However, it is essential that all group members understand the presentation in its entirety. At the end of the demonstration your group will be asked a series of questions to explore your understanding and analysis of the given problem. Responses to these questions such as โ€œI donโ€™t know because I didn’t work on that part of the assignmentโ€ are not acceptable and will result in a penalty for either the entire group or specific individual(s).

Part

Assessment Criteria:

Marks

Allocation

Online

Submission Date

1

a) Database and Database Management System b) Business Rules & Normalization

c) Entity Relationship Diagram

8%

12%

20%

Week 8

29 September

2024

11.59pm

2

d) Database Schema

e) SQL-Data Definition Language (DDL) f) SQL-Data Manipulation Language (DML)

18%

12%

30%

Week 12

27 October 2024 11.59pm

Level 1 Asia Pacific University of Information & Technology 072024

728 Comments

  148. dะ“ั–nde puedo comprar viagra en usa sin receta [url=https://confiapharma.com/#]farmacia en venezuela online[/url] donde puedo comprar antibioticos sin receta

  152. test de antigenos farmacia online [url=https://confiapharma.shop/#]comprar zamene sin receta[/url] se puede comprar paracetamol sin receta en francia

  155. ordonnance pour radio [url=https://pharmacieexpress.shop/#]Pharmacie Express[/url] ordonnance en ligne gratuite

  354. Medicijn Punt [url=http://medicijnpunt.com/#]frenadol kopen in nederland[/url] online apotheek recept

  361. online pharmacy reviews reddit [url=http://pharmaconnectusa.com/#]PharmaConnectUSA[/url] pfizer viagra online pharmacy

  365. mon bะ“ยฉbะ“ยฉ de 3 mois commence sa nuit ะ“ย  18h [url=http://pharmaconfiance.com/#]Pharma Confiance[/url] Pharma Confiance

  476. parafarmacia o farmacia [url=https://farmaciaasequible.shop/#]misoprostol espaะ“ยฑa[/url] top farmacia

  549. medicine in mexico pharmacies [url=https://meximedsexpress.shop/#]MexiMeds Express[/url] medication from mexico pharmacy

  557. indian pharmacies safe [url=https://indomedsusa.shop/#]india pharmacy mail order[/url] mail order pharmacy india

  561. AebgEmoli [url=http://medismartpharmacy.com/#]list of online pharmacies[/url] care rx pharmacy tallahassee fl

  564. online isotretinoin pharmacy [url=https://medismartpharmacy.shop/#]online pharmacy delivery usa[/url] finasteride india pharmacy

  566. reputable indian pharmacies [url=http://indomedsusa.com/#]buy medicines online in india[/url] IndoMeds USA

  574. MexiMeds Express [url=http://meximedsexpress.com/#]MexiMeds Express[/url] ะฟยปั—best mexican online pharmacies

  644. Isotretinoin From Canada [url=https://isotretinoinfromcanada.com/#]Isotretinoin From Canada[/url] Accutane for sale

  649. tadalafil online no rx [url=https://tadalafilfromindia.shop/#]tadalafil 5mg tablets price[/url] Cialis without prescription

Leave a Reply

Your email address will not be published. Required fields are marked *