(Solution) IDTag % = Natural Primary Key # = Foreign Key Data Type %IdentificationNumber Integer Style Text [VARCHAR] #PetID @ = Surrogate Primary Key Name | Snapessays.com


(Solution) IDTag % = Natural Primary Key # = Foreign Key Data Type %IdentificationNumber Integer Style Text [VARCHAR] #PetID @ = Surrogate Primary Key Name


Hello,Please let me know who can assist me ASAP.Course Project: Stage 2—Entity RelationshipsNote: Before you begin this stage, review the HINF 6130 "Pharmacy Mini Clinic" Course Project Rubric. This week, you will continue your Course Project by completing Stage 2. This stage will be a component in your "Pharmacy Mini Clinic" Course Project and will be due on Day 5.To prepare for this stage of the Course Project, view the "Relational Schema" video located under the Week 2 Learning Resources. In particular, pay close attention to the description of the three types of keys used in relational databases. Then, review the "Perspective" section on pages 196-199 of your Health Care Information Systems text and pages 134-135 of your Adaptive Health Management Information Systems text. Finally, familiarize yourself with the Stage 2 Example PowerPoint slide (which shows the diagram for the pet shop data with entity relationships created in Microsoft PowerPoint), as well as the Project Supporting Document.Stage 2 Example PowerPointProject Supporting DocumentTo complete this stage of the Course Project, you will need to download the Stage 2 Template linked below as well as open your saved PowerPoint from Week 1.Stage 2 TemplateTip: To facilitate transferring the information from the Stage 1 Template slide to the Stage 2 slide, you can copy the Stage 1 slide into the Stage 2 presentation, which will enable you to switch back and forth between two slides to get the necessary information as opposed to two different presentations. After you transfer the information that you need, you can delete the Stage 1 slide from the presentation before submitting your Stage 2 work. Identify which of the described attributes in Week 1 could be used as a unique identifier (called the primary key) for each entity and type it into the correct field. Then, add the other attributes under each entity. Please note that there is an additional table in the Stage 2 Template, "VaccineIssued." This additional table essentially takes data from each of the three existing tables (Patient, InsuranceCompany, and Vaccine), thereby serving as a link or connection between all of the tables; it also contains one surrogate primary key as well as three foreign keys. Please refer to the Stage 2 Example PowerPoint as needed to complete your assignment. Create a name for the surrogate primary key that makes sense to you, then add the surrogate primary key into the table. Finally, add the three foreign keys into the table. (See the "Keys" section of the Project Supporting Document.) Next, determine the relationships between the entities; whether they are one-to-one, one-to-many, many-to-many, or many-to-one. Review the "Relationships" section of the Project Supporting Document for assistance with entity relationships. Once the relationships are determined, refer to the PowerPoint "Tips" sections of the Project Supporting Document, which will show you how to insert arrows, draw arrows, and name the arrows to show entity relationships. Your entity relationships should look similar to those in the Stage 2 Example PowerPoint.***Please see week one project to be combine or add to week two project in the correct attributes space.Pet

 

Name

 

Data Type

 

Name

 

Text [VARCHAR]

 

Age

 

Integer

 

Species

 

Text [VARCHAR]

 

@

 

PetID

 

Integer

 

#

 

OwnerID

 

Integer

 

#

 

FavoriteFood

 

Integer

 

IDTag

 

Name

 

Data Type

 

%

 

IdentificationNumber

 

Integer

 

Style

 

Text [VARCHAR]

 

#

 

PetID

 

Integer

 

PetOwner

 

Name

 

Data Type

 

FirstName

 

Text [VARCHAR]

 

LastName

 

Text [VARCHAR]

 

Address

 

Text [VARCHAR]

 

@

 

OwnerID

 

Integer

 

Toy

 

Name

 

Data Type

 

Description

 

Text [VARCHAR]

 

Price

 

Decimal

 

@

 

ToyID

 

Integer

 

PetFood

 

Name

 

Data Type

 

Name

 

Text [VARCHAR]

 

Price

 

Decimal

 

@

 

FavoriteFood

 

Integer

 

One-to-many

 

relationship

 

Many-to-one

 

relationship

 

One-to-one

 

relationship

 

One-to-many

 

relationship

 

PetToy

 

Name

 

Data Type

 

#

 

PetID

 

Integer

 

#

 

ToyID

 

Integer

 

One-to-many

 

relationship

 

@ = Surrogate Primary Key

 

# = Foreign Key

 

% = Natural Primary Key

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: May 23, 2022

Solution~00021147718980.zip (25.37 KB)


This attachment is locked

Our expert Writers have done this assignment before, you can reorder for a fresh, original and plagiarism-free copy and it will be redone much faster (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

May 23, 2022

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • ■ As a reference for in-depth understanding of the subject.
  • ■ As a source of ideas / reasoning for your own research (if properly referenced)
  • ■ For editing and paraphrasing.

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

Get Free Price Quote