Can someone help me with this question?

PURPOSE

This assignment requires student to draw a complete Entity Relationship Diagram (ERD) and create the relational database based on the given scenario with its business rules.

REQUIREMENT / ASSIGNMENT QUESTION - TASK 1 (DOCUMENTATION)

In line with the current situation of the COVID-19 pandemic in Malaysia, the Ministry of Tourism, Arts and Culture Malaysia has launched a domestic travel campaign to promote domestic holiday and to help boost local businesses.

Assume that you are assigned as a database designer for a Booking Database System for a local hotel located in the north of Malaysia. The company is planning to implement a database system in managing all information of their booking to ensure all their guests wishing to stay at their hotel comply with current procedures and practices in the new norms.

Therefore, as a database designer, you are required to propose a database design prior to its implementation by presenting the following:

1. Identify ALL possible entities that could exist in the business process (give suitable entity name), complete all the entities with suitable attributes together with assigned primary key. (Use your own assumption to determine the attributes.)
2. Identify ALL relationships, cardinality, and/or participation for each identified entity.
3. Draw an Entity Relationship Diagram (ERD) by clearly stating the relationships between entities, cardinalities and attributes with correct notation.
4. Based on ERD created in (c), convert it into relational schema. State the primary key and foreign key for each relational schema (relations).
5. Create all relevant relations (tables) based on relational schema in (d). Choose appropriate data types for each attribute. Indicate the primary key and foreign key in each relation (table) created.
6. Produce sample records for each relation (table) that observes the relational integrity rules. FIVE records per relations are enough.
7. Then, produce FIVE SQL queries that can be used to manipulate the data from each relation and show ALL the results from each of the queries. (The queries should include a simple query, query for sorting results, aggregate function, sub-queries and query to alter the existing tables.)

Note:

You are free to use any Databases Management System (DBMS) tool (using DDL SQL or GUI).

You should submit a printout (screen capture) of:

1. Each table which shows the table name, fields and sample records.
2. Each query in SQL View, so that the grader can see your SQL code.
3. The result of each query (in table format).