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, 23.06.2019 18:40, cyn95xx
Johnson enterprises uses a computer to handle its sales invoices. lately, business has been so good that it takes an extra 3 hours per night, plus every third saturday, to keep up with the volume of sales invoices. management is considering updating its computer with a faster model that would eliminate all of the overtime processing.
Answers: 2
image
Computers and Technology, 24.06.2019 02:20, isabelsmhl
Peter is thinking of a number which isless than 50. the number has 9 factors. when he adds 4 to the number, itbecomes a multiple of 5. what is thenumber he is thinking of ?
Answers: 1
image
Computers and Technology, 24.06.2019 04:30, LouieHBK
Fall protection, confined space entry procedures, controlled noise levels, and protection from chemical hazards are some of the things that contribute to a safe and
Answers: 1
image
Computers and Technology, 24.06.2019 07:00, jordaaan101
Guys do you know sh27 cause he hacked me : ( pidgegunderson my old user
Answers: 2
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:

Konu
Mathematics, 11.09.2020 20:01
Konu
Mathematics, 11.09.2020 20:01
Konu
Spanish, 11.09.2020 20:01
Konu
Mathematics, 11.09.2020 20:01
Konu
Mathematics, 11.09.2020 20:01
Konu
Mathematics, 11.09.2020 20:01
Konu
Social Studies, 11.09.2020 20:01
Konu
Biology, 11.09.2020 20:01
Konu
Biology, 11.09.2020 20:01
Konu
Mathematics, 11.09.2020 20:01