Creating a new database:

The below are the steps to create new database:

Click “File->New” and then choose on the option “Blank desktop database”.

Provide the name of the database and click “Create”.

In the menu bar, click on the “create” menu and click on “Table”.

“Table1” will be created, Right click and choose “design view”.

A “Save As” dialog box appears type the name of the table and click “OK”.

Specify the required field name and data type.

Creation of the table Drone:

The below is the creation of table Drone:

Design view of table Drone

Creation of the table Video:

The below is the creation of table Video:

Design view of table Video

Creation of the table Facility:

The below is the creation of table Facility:

Design view of table Facility

Creation of the table Analysis:

The below is the creation of table Analysis:

Design view of table Analysis

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 5, Problem 5.9CE5

Chapter 5, Problem 5.11CE5

Students have asked these similar questions

Expand the database design you created in exercise1 so that it will also support the following situation: a specific therapist handles each therapy (a therapist can handle more than one). Along with all the details concerning sessions listed in exercise1, list the ID, last name, and first name of the therapist assigned to handle the request.

To get started, you will need to make a transaction in the database that you can use. During the subsequent discussion, we are going to concentrate mostly on the positive features of the organization.

Create a class diagram for the Sports Physical Therapy database, as shown in Figures 1-21 through 1-24 in Chapter 1. If you need to make any assumptions when preparing the diagram, document those assumptions.

Chapter 5 Solutions

Using MIS (10th Edition)

Ch. 5.2 - Prob. 1EGDQ Ch. 5.2 - Prob. 2EGDQ Ch. 5.2 - Prob. 3EGDQ Ch. 5.2 - Prob. 4EGDQ Ch. 5.2 - Prob. 5EGDQ Ch. 5.2 - Prob. 6EGDQ Ch. 5.2 - Prob. 7EGDQ Ch. 5.2 - Consider the adage Never ask a question for which...Ch. 5.3 - Prob. 1SAQ Ch. 5.3 - Prob. 2SAQ

Ch. 5.3 - Prob. 3SAQ Ch. 5.3 - Prob. 4SAQ Ch. 5.8 - Prob. 1SGDQ Ch. 5.8 - Prob. 3SGDQ Ch. 5.8 - Prob. 4SGDQ Ch. 5.8 - Prob. 5.1ARQ Ch. 5.8 - Prob. 5.2ARQ Ch. 5.8 - Prob. 5.3ARQ Ch. 5.8 - Prob. 5.4ARQ Ch. 5.8 - How are data models used for database development?...Ch. 5.8 - Prob. 5.6ARQ Ch. 5.8 - Prob. 5.7ARQ Ch. 5.8 - Prob. 5.8ARQ Ch. 5 - Draw an entity-relationship diagram that shows the...Ch. 5 - Consider the relationship between Adviser and...Ch. 5 - Prob. 5.3UYK Ch. 5 - Prob. 5.4UYK Ch. 5 - Study Figure 5-28 to understand the entities and...Ch. 5 - Working with your team, develop a list of seven...Ch. 5 - Modify the E-R model in Figure 5-28 to include a...Ch. 5 - Discuss the advantages and disadvantages of the...Ch. 5 - Transform the data model in Figure 5-28 into a...Ch. 5 - Prob. 5.1CE5 Ch. 5 - Fill your database with sample data. Because you...Ch. 5 - Prob. 5.12CE5 Ch. 5 - Explain why a one-table database could be stored...Ch. 5 - Prob. 5.14CS5 Ch. 5 - Examine the columns in Figure 5-33. Name three...Ch. 5 - Prob. 5.16CS5 Ch. 5 - Prob. 5.17CS5 Ch. 5 - Explain the statement A database is an abstraction...Ch. 5 - Prob. 5.19CS5 Ch. 5 - Prob. 5.2MML Ch. 5 - Prob. 5.21MML

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.