Drawing an ERD for the given situations and answering the given questions: Check that the attribute name follows the naming convention or not? check if there is any associative entity in the given ERD and write it if it is present in the ERD? Check is the given ERD allow the project to be created before it is assigned to any employee? How can we change the ERD if the billing rate changes in the middles of the project?

Question

Want to see the full answer?

Answer 1

Question

Chapter 2, Problem 2.39PAE

(a)

Program Plan Intro

Drawing an ERD for the given situations and answering the given questions:

Check that the attribute name follows the naming convention or not? check if there is any associative entity in the given ERD and write it if it is present in the ERD? Check is the given ERD allow the project to be created before it is assigned to any employee? How can we change the ERD if the billing rate changes in the middles of the project?

(b)

Program Plan Intro

Draw an ERD for the data and provide definitions of all the relationship in the solution.

(c)

Program Plan Intro

Draw an ERD for the data and model the section with another methods.

(d)

Program Plan Intro

Draw an ERD for the given situation. Answer whether you draw more than one relationship between physician and patient. Provide reason for same. Mention whether you include hospital as an entity type or not and if your ERD allow for the same patient to be admitted by different physicians over time. Ways in which you include on the ERD the need to represent the date on which a patient is admitted for each time he or she is admitted.

(e)

Program Plan Intro

Draw an ERD for the given situation. Assume that credit result is not reused for multiple credit requests. Redraw the ERD for this new situation using two entity types, and then redraw it again by using one entity type. Which of these two versions do you prefer, and why?

(f)

Program Plan Intro

Draw an ERD for this situation. After that consider a new attribute, Hourly Rate, which is the rate a consultant charges a company for each hour of his or her services. Redraw the ERD to include this new attribute. Now, consider that each time a consultant works for a company, a contract is written describing the terms for this consulting engagement. Contract has attributes such as Company ID, Consultant ID, and Contract Date. Assume that a consultant can still work foronly one company at a time, redraw the ERD for this new situation. Can we move any attributes to different entity types in this latest situation? As a final situation, now consider that although a consultant can work for only one company at a time, we now need to keep the complete history of all consulting engagements for each consultant and company. Draw an ERD for this final situation. Explain why these different changes to the situation led to different data models, if they did.

(g)

Program Plan Intro

Draw an ERD for the given situation:

(h)

Program Plan Intro

Draw an ERD for the given situation:

(i)

Program Plan Intro

Draw an ERD for the given situation:

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Modular Program Structure. Analysis of Structured Programming Examples. Ways to Reduce Coupling. Based on the given problem, create an algorithm and a block diagram, and write the program code: Function: y=xsin⁡x Interval: [0,π] Requirements: Create a graph of the function. Show the coordinates (x and y). Choose your own scale and show it in the block diagram. Create a block diagram based on the algorithm. Write the program code in Python. Requirements: Each step in the block diagram must be clearly shown. The graph of the function must be drawn and saved (in PNG format). Write the code in a modular way (functions and the main part should be separate). Please explain and describe the results in detail.

Based on the given problem, create an algorithm and a block diagram, and write the program code: Function: y=xsin⁡x Interval: [0,π] Requirements: Create a graph of the function. Show the coordinates (x and y). Choose your own scale and show it in the block diagram. Create a block diagram based on the algorithm. Write the program code in Python. Requirements: Each step in the block diagram must be clearly shown. The graph of the function must be drawn and saved (in PNG format). Write the code in a modular way (functions and the main part should be separate). Please explain and describe the results in detail.

Answer 2

Question

Chapter 2, Problem 2.39PAE

(a)

Program Plan Intro

Drawing an ERD for the given situations and answering the given questions:

Check that the attribute name follows the naming convention or not? check if there is any associative entity in the given ERD and write it if it is present in the ERD? Check is the given ERD allow the project to be created before it is assigned to any employee? How can we change the ERD if the billing rate changes in the middles of the project?

(b)

Program Plan Intro

Draw an ERD for the data and provide definitions of all the relationship in the solution.

(c)

Program Plan Intro

Draw an ERD for the data and model the section with another methods.

(d)

Program Plan Intro

Draw an ERD for the given situation. Answer whether you draw more than one relationship between physician and patient. Provide reason for same. Mention whether you include hospital as an entity type or not and if your ERD allow for the same patient to be admitted by different physicians over time. Ways in which you include on the ERD the need to represent the date on which a patient is admitted for each time he or she is admitted.

(e)

Program Plan Intro

Draw an ERD for the given situation. Assume that credit result is not reused for multiple credit requests. Redraw the ERD for this new situation using two entity types, and then redraw it again by using one entity type. Which of these two versions do you prefer, and why?

(f)

Program Plan Intro

Draw an ERD for this situation. After that consider a new attribute, Hourly Rate, which is the rate a consultant charges a company for each hour of his or her services. Redraw the ERD to include this new attribute. Now, consider that each time a consultant works for a company, a contract is written describing the terms for this consulting engagement. Contract has attributes such as Company ID, Consultant ID, and Contract Date. Assume that a consultant can still work foronly one company at a time, redraw the ERD for this new situation. Can we move any attributes to different entity types in this latest situation? As a final situation, now consider that although a consultant can work for only one company at a time, we now need to keep the complete history of all consulting engagements for each consultant and company. Draw an ERD for this final situation. Explain why these different changes to the situation led to different data models, if they did.

(g)

Program Plan Intro

Draw an ERD for the given situation:

(h)

Program Plan Intro

Draw an ERD for the given situation:

(i)

Program Plan Intro

Draw an ERD for the given situation:

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Question

Chapter 2, Problem 2.39PAE

(a)

Program Plan Intro

Drawing an ERD for the given situations and answering the given questions:

Check that the attribute name follows the naming convention or not? check if there is any associative entity in the given ERD and write it if it is present in the ERD? Check is the given ERD allow the project to be created before it is assigned to any employee? How can we change the ERD if the billing rate changes in the middles of the project?

(b)

Program Plan Intro

Draw an ERD for the data and provide definitions of all the relationship in the solution.

(c)

Program Plan Intro

Draw an ERD for the data and model the section with another methods.

(d)

Program Plan Intro

Draw an ERD for the given situation. Answer whether you draw more than one relationship between physician and patient. Provide reason for same. Mention whether you include hospital as an entity type or not and if your ERD allow for the same patient to be admitted by different physicians over time. Ways in which you include on the ERD the need to represent the date on which a patient is admitted for each time he or she is admitted.

(e)

Program Plan Intro

Draw an ERD for the given situation. Assume that credit result is not reused for multiple credit requests. Redraw the ERD for this new situation using two entity types, and then redraw it again by using one entity type. Which of these two versions do you prefer, and why?

(f)

Program Plan Intro

Draw an ERD for this situation. After that consider a new attribute, Hourly Rate, which is the rate a consultant charges a company for each hour of his or her services. Redraw the ERD to include this new attribute. Now, consider that each time a consultant works for a company, a contract is written describing the terms for this consulting engagement. Contract has attributes such as Company ID, Consultant ID, and Contract Date. Assume that a consultant can still work foronly one company at a time, redraw the ERD for this new situation. Can we move any attributes to different entity types in this latest situation? As a final situation, now consider that although a consultant can work for only one company at a time, we now need to keep the complete history of all consulting engagements for each consultant and company. Draw an ERD for this final situation. Explain why these different changes to the situation led to different data models, if they did.

(g)

Program Plan Intro

Draw an ERD for the given situation:

(h)

Program Plan Intro

Draw an ERD for the given situation:

(i)

Program Plan Intro

Draw an ERD for the given situation:

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Question

Chapter 2, Problem 2.39PAE

(a)

Program Plan Intro

Drawing an ERD for the given situations and answering the given questions:

Check that the attribute name follows the naming convention or not? check if there is any associative entity in the given ERD and write it if it is present in the ERD? Check is the given ERD allow the project to be created before it is assigned to any employee? How can we change the ERD if the billing rate changes in the middles of the project?

(b)

Program Plan Intro

Draw an ERD for the data and provide definitions of all the relationship in the solution.

(c)

Program Plan Intro

Draw an ERD for the data and model the section with another methods.

(d)

Program Plan Intro

Draw an ERD for the given situation. Answer whether you draw more than one relationship between physician and patient. Provide reason for same. Mention whether you include hospital as an entity type or not and if your ERD allow for the same patient to be admitted by different physicians over time. Ways in which you include on the ERD the need to represent the date on which a patient is admitted for each time he or she is admitted.

(e)

Program Plan Intro

Draw an ERD for the given situation. Assume that credit result is not reused for multiple credit requests. Redraw the ERD for this new situation using two entity types, and then redraw it again by using one entity type. Which of these two versions do you prefer, and why?

(f)

Program Plan Intro

Draw an ERD for this situation. After that consider a new attribute, Hourly Rate, which is the rate a consultant charges a company for each hour of his or her services. Redraw the ERD to include this new attribute. Now, consider that each time a consultant works for a company, a contract is written describing the terms for this consulting engagement. Contract has attributes such as Company ID, Consultant ID, and Contract Date. Assume that a consultant can still work foronly one company at a time, redraw the ERD for this new situation. Can we move any attributes to different entity types in this latest situation? As a final situation, now consider that although a consultant can work for only one company at a time, we now need to keep the complete history of all consulting engagements for each consultant and company. Draw an ERD for this final situation. Explain why these different changes to the situation led to different data models, if they did.

(g)

Program Plan Intro

Draw an ERD for the given situation:

(h)

Program Plan Intro

Draw an ERD for the given situation:

(i)

Program Plan Intro

Draw an ERD for the given situation:

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Chapter 2, Problem 2.39PAE

(a)

Program Plan Intro

Drawing an ERD for the given situations and answering the given questions:

Check that the attribute name follows the naming convention or not? check if there is any associative entity in the given ERD and write it if it is present in the ERD? Check is the given ERD allow the project to be created before it is assigned to any employee? How can we change the ERD if the billing rate changes in the middles of the project?

(b)

Program Plan Intro

Draw an ERD for the data and provide definitions of all the relationship in the solution.

(c)

Program Plan Intro

Draw an ERD for the data and model the section with another methods.

(d)

Program Plan Intro

Draw an ERD for the given situation. Answer whether you draw more than one relationship between physician and patient. Provide reason for same. Mention whether you include hospital as an entity type or not and if your ERD allow for the same patient to be admitted by different physicians over time. Ways in which you include on the ERD the need to represent the date on which a patient is admitted for each time he or she is admitted.

(e)

Program Plan Intro

Draw an ERD for the given situation. Assume that credit result is not reused for multiple credit requests. Redraw the ERD for this new situation using two entity types, and then redraw it again by using one entity type. Which of these two versions do you prefer, and why?

(f)

Program Plan Intro

Draw an ERD for this situation. After that consider a new attribute, Hourly Rate, which is the rate a consultant charges a company for each hour of his or her services. Redraw the ERD to include this new attribute. Now, consider that each time a consultant works for a company, a contract is written describing the terms for this consulting engagement. Contract has attributes such as Company ID, Consultant ID, and Contract Date. Assume that a consultant can still work foronly one company at a time, redraw the ERD for this new situation. Can we move any attributes to different entity types in this latest situation? As a final situation, now consider that although a consultant can work for only one company at a time, we now need to keep the complete history of all consulting engagements for each consultant and company. Draw an ERD for this final situation. Explain why these different changes to the situation led to different data models, if they did.

(g)

Program Plan Intro

Draw an ERD for the given situation:

(h)

Program Plan Intro

Draw an ERD for the given situation:

(i)

Program Plan Intro

Draw an ERD for the given situation:

Answer 6

Chapter 2, Problem 2.39PAE

(a)

Program Plan Intro

Drawing an ERD for the given situations and answering the given questions:

Check that the attribute name follows the naming convention or not? check if there is any associative entity in the given ERD and write it if it is present in the ERD? Check is the given ERD allow the project to be created before it is assigned to any employee? How can we change the ERD if the billing rate changes in the middles of the project?

Answer 7

Chapter 2, Problem 2.39PAE

(a)

Program Plan Intro

Drawing an ERD for the given situations and answering the given questions:

Check that the attribute name follows the naming convention or not? check if there is any associative entity in the given ERD and write it if it is present in the ERD? Check is the given ERD allow the project to be created before it is assigned to any employee? How can we change the ERD if the billing rate changes in the middles of the project?

Answer 8

(b)

Program Plan Intro

Draw an ERD for the data and provide definitions of all the relationship in the solution.

Answer 9

(b)

Program Plan Intro

Draw an ERD for the data and provide definitions of all the relationship in the solution.

Answer 10

(c)

Program Plan Intro

Draw an ERD for the data and model the section with another methods.

Answer 11

(c)

Program Plan Intro

Draw an ERD for the data and model the section with another methods.

Answer 12

(d)

Program Plan Intro

Draw an ERD for the given situation. Answer whether you draw more than one relationship between physician and patient. Provide reason for same. Mention whether you include hospital as an entity type or not and if your ERD allow for the same patient to be admitted by different physicians over time. Ways in which you include on the ERD the need to represent the date on which a patient is admitted for each time he or she is admitted.

Answer 13

(d)

Program Plan Intro

Draw an ERD for the given situation. Answer whether you draw more than one relationship between physician and patient. Provide reason for same. Mention whether you include hospital as an entity type or not and if your ERD allow for the same patient to be admitted by different physicians over time. Ways in which you include on the ERD the need to represent the date on which a patient is admitted for each time he or she is admitted.

Answer 14

(e)

Program Plan Intro

Draw an ERD for the given situation. Assume that credit result is not reused for multiple credit requests. Redraw the ERD for this new situation using two entity types, and then redraw it again by using one entity type. Which of these two versions do you prefer, and why?

Answer 15

(e)

Program Plan Intro

Draw an ERD for the given situation. Assume that credit result is not reused for multiple credit requests. Redraw the ERD for this new situation using two entity types, and then redraw it again by using one entity type. Which of these two versions do you prefer, and why?

Answer 16

(f)

Program Plan Intro

Draw an ERD for this situation. After that consider a new attribute, Hourly Rate, which is the rate a consultant charges a company for each hour of his or her services. Redraw the ERD to include this new attribute. Now, consider that each time a consultant works for a company, a contract is written describing the terms for this consulting engagement. Contract has attributes such as Company ID, Consultant ID, and Contract Date. Assume that a consultant can still work foronly one company at a time, redraw the ERD for this new situation. Can we move any attributes to different entity types in this latest situation? As a final situation, now consider that although a consultant can work for only one company at a time, we now need to keep the complete history of all consulting engagements for each consultant and company. Draw an ERD for this final situation. Explain why these different changes to the situation led to different data models, if they did.

Answer 17

(f)

Program Plan Intro

Draw an ERD for this situation. After that consider a new attribute, Hourly Rate, which is the rate a consultant charges a company for each hour of his or her services. Redraw the ERD to include this new attribute. Now, consider that each time a consultant works for a company, a contract is written describing the terms for this consulting engagement. Contract has attributes such as Company ID, Consultant ID, and Contract Date. Assume that a consultant can still work foronly one company at a time, redraw the ERD for this new situation. Can we move any attributes to different entity types in this latest situation? As a final situation, now consider that although a consultant can work for only one company at a time, we now need to keep the complete history of all consulting engagements for each consultant and company. Draw an ERD for this final situation. Explain why these different changes to the situation led to different data models, if they did.

Answer 18

(g)

Program Plan Intro

Draw an ERD for the given situation:

Answer 19

(g)

Program Plan Intro

Draw an ERD for the given situation:

Answer 20

(h)

Program Plan Intro

Draw an ERD for the given situation:

Answer 21

(h)

Program Plan Intro

Draw an ERD for the given situation:

Answer 22

(i)

Program Plan Intro

Draw an ERD for the given situation:

Answer 23

(i)

Program Plan Intro

Draw an ERD for the given situation:

Answer 24

Expert Solution & Answer

Answer 25

Expert Solution & Answer

Answer 26

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 27

Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Match the following terms and definitions....Ch. 2 - Contrast the following terms: stored attribute;...Ch. 2 - Prob. 2.4RQ Ch. 2 - Prob. 2.5RQ Ch. 2 - Prob. 2.6RQ Ch. 2 - State six general guidelines for naming data...Ch. 2 - Prob. 2.8RQ Ch. 2 - Prob. 2.9RQ Ch. 2 - State three conditions that suggest the designer...

Concept explainers

Draw an ERD for the data and provide definitions of all the relationship in the solution.

Draw an ERD for the data and model the section with another methods.

Draw an ERD for the given situation. Assume that credit result is not reused for multiple credit requests. Redraw the ERD for this new situation using two entity types, and then redraw it again by using one entity type. Which of these two versions do you prefer, and why?

Draw an ERD for the given situation:

Draw an ERD for the given situation:

Draw an ERD for the given situation:

Want to see the full answer?

Chapter 2 Solutions