Solution-Please identify the attributes and primary keys

Please identify the attributes and primary keys

Assignment Help Project Management

Reference no: EM132485388

A small surgery center needs help to create database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments using the following business rules:

Patients can have many doctors and many doctors can see many patients.

Patients can have many procedures and many procedures are done on patients.

Doctors can have multiple appointments. (hint: these are many to many relationships, so associative tables need to be added)

1. Please identify the attributes and primary keys needed for each of the entities.

2. Identify the data types you would use for each of the attributes.

3. Determine the relationships between the entities and find the one-to-many and many-to-many relationships.

o Use the ER matrix to determine the relationships.

4. Create ER diagram using Visio including the associative tables based on your analysis.

5. Identify all foreign keys needed in the database design.

6. Create the database and relationships in Access and populate the tables using the spreadsheets.

7. To use the database as the main office application, what other entities and attributes might be needed?

Reference no: EM132485388

Questions Cloud

Calculate net present value for method : Calculate net present value for Method 1 and Method 2. (Do not round intermediate calculations and round your answers to 2 decimal places.)

Project close-lessons learned sessions : In the project schedule, you have scheduled project close-lessons learned sessions to occur throughout the project. What are three benefits for doing this?

Kinds of operating expenses : They also have to consider the expenses they will face to operate the car after they buy it. What kinds of operating expenses should they include?

What is the? price by book ratio : There are 54,000 shares of common stock outstanding. What is the? price/book ratio? What does this indicate about how shareholders view? Chang, Inc.?

Please identify the attributes and primary keys : 1. Please identify the attributes and primary keys needed for each of the entities.

Challenges addressed by lean : Which of the following is one of the challenges addressed by lean?

Write out which accounts increased for each transaction : For each situation, write out which accounts increased or decreased for each transaction and the amount of the increase or decrease.

What percent of annual life-cycle cost is related to fuel : If the MARR is 15% per year, what is the annual equivalent life-cycle cost of the gas turbine? What percent of annual life-cycle cost is related to fuel?

What will the earnings per share be after the merger : What will the earnings per share be after the merger? Firm XY is planning on merging with Firm YZ. Firm XY will pay Firm YZ's shareholders the current value

User Account

All Pages

Please identify the attributes and primary keys

Reference no: EM132485388

Reference no: EM132485388

Questions Cloud

Reviews

Write a Review

Project Management Questions & Answers

Create a project schedule and align resources

Managerial roles and gap analysis

Questionaire on project management

Describe the market growth rate for product

Prepare a work plan and project schedule - gantt chart

Project risk management approach

Black-scholes options pricing model

Describe the features or characteristics of product

Write paper on inventory management system

Analysis of the overall project risk

Investment and performance analysis

Distribution strategy and project management

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT