Question: Create a working database in Microsoft Access for a specific type of business (like hotel or travel agency) 1. Construct the ER diagram (that shows

Create a working database in Microsoft Access for a specific type of business (like hotel or travel agency)

1. Construct the ER diagram (that shows all tables, relationships, attributes and primary keys)

2. Construct the relational Schema (that shows all tables and attributes and primary keys) in this form: TableName (PrimaryKey, Attribute 1, Attribute 2, etc).

3. List of all the functionalities that your database will do/support with a brief explanation of each functionality (e.g. it will allow storage of reservations for a hotel, or it will allow to search for the details of the purchase in a travel agency).

4. Design and submit the MS Access file that has a list and also analyse each function in depth.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Overview This assignment requires you to convert a UML class diagram into a relational model, physically create tables in Microsoft Access, and enter data into the tables. The main purpose of this...

Uploaded our Context Diagram, Was hoping someone could check for the validity of it according to the assignment. Bank Merc hand i Consignor se/ G oods Fees Cont racts Unso ld M ercha ndise / goo ds...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

SEE problem 4.25 which is attached in pdf format. I need detailed and correct answer 148 PART TWO / Databases Purchasing agent Order goods Merchandise inventory Vendor Receive goods Receiving clerk...

BA630 - Systems Analysis & Design Exercise (Team Project) Maximum Word Count: 4000 words The purpose of this project is to pull several ideas together that we have covered throughout the semester and...

Dan Tragg insists on using only the highest quality blanks in the manufacturing of his surfboards. Traggs uses a list of approved vendors with whom they have established a good relationship over the...

P L U G - I N T3 Problem Solving Using Excel 2010 LEARN IN G OUT C O ME S 1. 2. 3. 4. 5. Describe how to create and sort a list using Excel. Explain why you would use conditional formatting using...

ProjectDan Tragg insists on using only the highest quality blanks in the manufacturing of his surfboards. Traggs uses a list of approved vendors with whom they have established a good relationship...

Write structural formulas for all the constitutional isomers of (a) C3H8 (b) C3H6 (c) C3H4

You have been assigned to the audit of Phillips Inc., a chain of convenience stores. As part of the audit planning, you decide to perform the following tests: 1. Perform a walkthrough of purchase...

16.17 The following data represent the number of hours that two different types of scientific pocket calculators operate before a recharge is required. Calculator A 5.5 5.6 6.3 4.6 5.3 5.0 6.2 5.8...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

What are Decision Trees?

What is meant by the Term Glass Ceiling?

What Interface is used to develop Data Mining Structures in SQL Server Analytical Databases?