Computers and Technology

Use the 3nf conceptual data model for the vet clinic data from our unit 6 lab and create a logical model by adding in the data types. feel free to print the pdf file and work out the data types using our unit 7 notes to guide you. your main task is selecting the appropriate data types for each of the attributes (now fields) in the given conceptual model. check out the various data types and choose the appropriate type that tells sql server how to interpret the data stored in each column of your entities (now tables)
notes on the fields:
pet type can be one of the following list of values: dog, cat, bird
assume zipcode is the 5 digit version
assume phone numbers are only the digits (e. g. 2187236000)
pet_dob includes the month, day, and year
visit_date includes the month, day, year, and time of the appointment
visit_notes are the notes the vet takes about the appointment and can be up to 1-2 pages long of text
create this using lucidchart or something similar.

answer
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 11:20, destinyleisantos
The kurt vonnegut commencement speech, the neiman-marcus chocolate chip cookie recipe, and the get-well emails to the dying boy are examples of select one: a. social engineering b. hoax emails c. email viruses d. worms
Answers: 1
image
Computers and Technology, 23.06.2019 00:00, brooklyn4932
What engine component is shown in the above figure?
Answers: 1
image
Computers and Technology, 24.06.2019 07:30, sunny644
John recently worked on a project about various programming languages. he learned that though procedural language programs are useful, they have disadvantages too. what is a disadvantage of programs written in procedural languages? a. programs do not represent data complexity. b. programs take more time to execute. c. programs are prone to security threats. d. programs do not interface with multiple platforms.
Answers: 3
image
Computers and Technology, 24.06.2019 12:30, stephanieanaya7
Why does the pc send out a broadcast arp prior
Answers: 1
Do you know the correct answer?
Use the 3nf conceptual data model for the vet clinic data from our unit 6 lab and create a logical m...

Questions in other subjects: