Create a database, AIMS2710-Access Project. You have

Create a database

Assignment Help Database Management System

Reference no: EM131723195

Access Project

You have recently been hired by Sharbaf and Associates, a small sized firm that offers consulting IT innovative services for the various industries. Your job is to create a database. The database should contain the following criteria information:

At least three tables (primary key for each table).

At least 6 attributes (field) for the table 1, at least 5 attributes (field) for the table 2, and 3.

Each table should have at least 10 records.

Establish Entity Relationship Diagram (ERD) for the tables(1:1, 1:M, and M:M).

Create forms for the tables.

Create a query for the tables (establish your criteria for each table).

Create a report for the tables.

Hint: If you are using Microsoft Access, use the wizard to generate the queries. Good Luck!

Reference no: EM131723195

Questions Cloud

Define culture and cultural competence : Discuss your civic responsibility related to the issue you chose to write about in this essay. Discuss effective participation in civic engagement activities.

Calculate the? firm monopoly power : Given the information? above, use the Lerner Index of Monopoly Power to calculate the? firm's monopoly power.

Compute maximum dollar amount of real estate loans : The lending function of depository institutions is highly regulated and this chapter gives some examples of the structure of these regulations for national.

Explain how the medicare advantage program : Explain how the Medicare Advantage program is intended to benefit consumers, insurers, and the government. If Medicare Advantage participants

Create a database : AIMS2710-Access Project. You have recently been hired by Sharbaf and Associates, Your job is to create a database

Develop a fire inspection form for commercial occupancies : Develop a fire inspection form for commercial occupancies. Keep in mind, these type of structures will most likely have some sort of fire protection system.

Mean for designing effective randomized controlled trials : What is a “spillover,” and what does it mean for designing effective randomized controlled trials

Strengths and weaknesses of the safe drinking water act : What are the strengths and weaknesses of the Safe Drinking Water Act?

What is the minimum size loan or credit line rogers : Under the guidelines for taking collateral discussed in this chapter, what is the minimum size loan or credit line Rogers is likely to receive.

User Account

All Pages