Grand Canyon University Database Management Concepts and Design Discussion Questions

User Generated

unonan123

Writing

Grand Canyon University

Description

DQ 1 

Who would be the ideal candidate(s) from whom to elicit information during the requirements gathering and analysis phase of the database project? Explain why.

DQ 2 

Typically, a patient staying in a hospital receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M relationship between patient and order. Similarly, each order can include several medications, creating a 1:M relationship between order and medication.

  1. Identify different entities from this scenario.
  2. Create an entity-relationship diagram illustrating 1:1 and 1: many relationships.
  3. Compare your ERD with another classmate's and discuss the differences each of you had.


Typically, a patient staying in a hospital receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M relationship between patient and order. Similarly, each order can include several medications, creating a 1:M relationship between order and medication.

  1. Identify different entities from this scenario.
  2. Create an entity-relationship diagram illustrating 1:1 and 1: many relationships.
  3. Compare your ERD with another classmate's and discuss the differences each of you had.

TIPs: You can create your entity relationship diagram by typing in your search engine: free entity relationship program. There are many free programs for creating these diagrams, but ALL of them take time to learn to use. (Microsoft Visio, OmniGraffle, LucidChart, and MySQL are few of these programs that will give free trials to create entity-relationship diagrams. In addition, you can simply create diagrams by utilizing Microsoft Word, PowerPoint Shapes, or SmartArt.) Please add a photo of your ERD to the post so that your classmates can discuss it. After students have added this information, you can create a reply to discuss your classmates ERD.

Please allow yourself time to learn to utilize whatever program that you use. You can also use PowerPoint, but this also takes time if you have never created an ERD before. There are many different kinds of ERD diagrams such as (Crow, Chen, UML) (pick one you would like to use, as there is not a specific diagram format for this DQ). You will be utilizing one of the programs again to create an ERD for your database design.

Please see Figure 4.6 and Figure 4.35 in Chapter 4 of your eBook for an example of an ERD (Entity-Relationship Diagram).

Please see Chapter 13 of your eBook and see Figure 13.12 of an example of an ERD diagram.

Please note you can use a Snipping tool in Windows to take a picture of your diagrams and insert the picture(s) into a Word document. You will not be able to upload the diagram in the program you pick to make your ERD such as Visio or other diagram programs.

Please see section 2.3 in Chapter 2 of your eBook the discusses Data Model Basic Building Blocks as this will help to get you started with the cardinalities between your entity-attributes.

You can set-up a data dictionary so that you understand the concept-- as you will be creating one down the road—so take the time to digest some of this now: You can set this up like a table in a word document and please see TABLE 8.2 in your eBook to see the required items in a data dictionary. (You will need a data dictionary just like TABLE 8.2 for Part 2 of your Proposal.

Have I mentioned how important TABLE 8.2 is to view in your e-text?????!!!!!!!!!

Naming conventions will be needed for your data dictionary and ERD (schema) diagram. Please see table 6.7 in your eBook and review the information related to naming conventions. The naming conventions will need to work in SQLfiddle. (I have added additional resources in files in the Topic 2 Resources).

Naming conventions will be needed for your data dictionary and ERD schema) diagram. Please see table 6.7 in your eBook and review the information related to naming conventions. The naming conventions will need to work in SQLfiddle. (I have added additional resources in files in the Topic 2 Resources). 

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.

DQ 1
Ideal Candidates for The Requirement Gathering Phase of a Database Project
The analysis phase enables database designers to understand the needs of the potential users
of their final product. Therefore, potential database users form the ideal candidates from which the
information about database requirements should be elicited. Sophisticated users responsible for
database maintenance are the first category of candidates that need to be consulted when defining
database requi...


Anonymous
Just what I needed…Fantastic!

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Related Tags