Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
tabase management Diagram to be drawn for given statement.  Downvote for illogical diagram.

tabase management Diagram to be drawn for given statement.  Downvote for illogical diagram.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Database management

Diagram to be drawn for given statement. 

Downvote for illogical diagram. 

 

 

Section A: Produce a report on the features of MYSQL Data Base. Section B: Relational Data Base Modeling: Develop a Conceptual, Logical and physical Data Base Model (ER Diagram) : Entity Rclationship (ER) Modcling and Normalization Learning by doing it. Prerequisite: Basic knowledge about ER Modeling. It is recommended to read the NOTES, if you have not done so before proceeding further. Here we are going to design an Entity Relationship (ER) model for a MIKA LODGE database. Say we have the following statements. 1. A Motel (Mika Lodge) is a hive of numerous operations such as front office, booking, and reservation, banquet, finance, HR, inventory, material management, quality management, security, energy management, housekeeping, CRM and more. The Motel has some rooms, and these rooms are of different categories. By room category, cach room has the different price. The Motel has some employees to manage the services provided to 3. 4. customers. The customer can book the room either online or by cash payment at the hotel, 5. 6. The customer record is stored in the Motels' database which contains customer identity, his address, check in time, check out time, etc. 7. The Motel provides food and beverages to their customers and generates the bill for this at the time of their check out. DMarks) REQUIRED: a) Draw an Entity Relation Diagram showing relationships and attributes. b) Normalize the tables up to 3rd Normal Form. c) All works must be presentable in graphical form, either PowerPoint or paper. Step 1: Identify the Entities Stem 2 : Identify the relationships Step 3: Identify the key attributes Step 4: Identify other relevant attributes Step 5: Normalise tables Step 6: Populate the Data Base on the chosen database system. Step 7. Produce possible reports that can used for decision support.
Transcribed Image Text:Section A: Produce a report on the features of MYSQL Data Base. Section B: Relational Data Base Modeling: Develop a Conceptual, Logical and physical Data Base Model (ER Diagram) : Entity Rclationship (ER) Modcling and Normalization Learning by doing it. Prerequisite: Basic knowledge about ER Modeling. It is recommended to read the NOTES, if you have not done so before proceeding further. Here we are going to design an Entity Relationship (ER) model for a MIKA LODGE database. Say we have the following statements. 1. A Motel (Mika Lodge) is a hive of numerous operations such as front office, booking, and reservation, banquet, finance, HR, inventory, material management, quality management, security, energy management, housekeeping, CRM and more. The Motel has some rooms, and these rooms are of different categories. By room category, cach room has the different price. The Motel has some employees to manage the services provided to 3. 4. customers. The customer can book the room either online or by cash payment at the hotel, 5. 6. The customer record is stored in the Motels' database which contains customer identity, his address, check in time, check out time, etc. 7. The Motel provides food and beverages to their customers and generates the bill for this at the time of their check out. DMarks) REQUIRED: a) Draw an Entity Relation Diagram showing relationships and attributes. b) Normalize the tables up to 3rd Normal Form. c) All works must be presentable in graphical form, either PowerPoint or paper. Step 1: Identify the Entities Stem 2 : Identify the relationships Step 3: Identify the key attributes Step 4: Identify other relevant attributes Step 5: Normalise tables Step 6: Populate the Data Base on the chosen database system. Step 7. Produce possible reports that can used for decision support.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS