Question

For each of the following data elements, provide your recommendation for the appropriate type of data...

For each of the following data elements, provide your recommendation for the appropriate type of data entry field:

  • Patient Last Name
  • Social Security Number
  • Discharge Date
  • Account Number
  • Address
  • Zip Code
  • City
  • State
  • Allergies
  • Medications
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution -

Please find the Data elements specified in the question, with the corresponding Field Type best suited for it and the description of the same.

Sr. No Data Elements Field Type Description
1 Patient Last Name Alphabetic Alphabetic characters only
2 Social Security Number Numeric Numbers from 0-9
3 Discharge Date Date Format DD/MM/YY, MM/DD/YYYY etc
4 Account Number Numeric Numbers from 0-9
5 Address Alpha Numeric Alphabetic & numeric characters
6 Zip Code Numeric Numbers from 0-9
7 City Alphabetic Alphabetic characters only
8 State Alphabetic Alphabetic characters only
9 Allergies Alphabetic Alphabetic characters only
10 Medications Alpha Numeric Alphabetic & numeric characters
Add a comment
Know the answer?
Add Answer to:
For each of the following data elements, provide your recommendation for the appropriate type of data...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Sample data is provided for the database for the sales system. Using the sample data, you...

    Sample data is provided for the database for the sales system. Using the sample data, you will determine the entities, key components of the entities, and business rules for the entities. Using the entities and business rules you will then create an ERD. Tasks: 1. For each entity provide the name, description, fields, data type, primary key, and foreign key. 2. For each direct entity type pair, provide the business rules. 3. Provide the ERD. Customer Table Customer ID, Last...

  • Conceptual data diagram The ABC university keeps track of each student's name, student number, social security...

    Conceptual data diagram The ABC university keeps track of each student's name, student number, social security number (I C number), current address and phone, permanent address and phone, birthdate, sex, class (alpha, Beta, Gamma ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address, and to the student's last name. Both social security number and student number have...

  • Question 1: Please transform the following E-R diagram to relations (40 points) CID Name Street Customer...

    Question 1: Please transform the following E-R diagram to relations (40 points) CID Name Street Customer Refers State City City Address Address State Zip Code Street Holds Zip Code Merchant Card Type AccountID Card Account Has Exp Date Charge Date Charge Time Card Type = "C Debit Card Credit Card Has Charges Current Balance Bank No. Amount

  • Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is...

    Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. The university keeps track of each student's name, student number, social security number current address and phone, permanent address and phone, birth date, sex, class (freshman, sophomore,., graduate), major department, minor department (if any), and degree program (B.A., B.S.,..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...

  • question One: Design an ER diagram for the following Dental Clinic database. Your diagram should have...

    question One: Design an ER diagram for the following Dental Clinic database. Your diagram should have all the needed details. You may make any reasonable assumptions but you have to state them clearly. ------ The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary, birth-date and home-address (Box, City, Zip). Each client (patient) has a unique Code, name, home-phone, work-phone, address, and birth-date. Each client is assigned to one dentist. All future visits will...

  • The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary,...

    The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary, birth-date and home-address (Box, City, Zip). Each client (patient) has a unique Code, name, home-phone, work-phone, address, and birth-date. Each client is assigned to one dentist. All future visits will be to the same dentist. A client can be insured or self-paying. An insured client should have an insurance company-name, and company-Phone, while a self-paying client must have a bank-name and a bank account....

  • So I'm not sure what I'm trying to do here. I don't understand how *adr works,...

    So I'm not sure what I'm trying to do here. I don't understand how *adr works, I guess it's a pointer to the struct Address. How do I complete this function? And how would I have it just return the zip code or one element if I wanted to? I have two structs: struct Address {    int number; // street number    string street; // street Name    string city; // city    short zip; // zip code   ...

  • in java (Bank Account) Write a program that inputs in the full name, street address, city, state, zip code, and social...

    in java (Bank Account) Write a program that inputs in the full name, street address, city, state, zip code, and social security for new account. In addition, it inputs in the initial account balance and allows the owner of the new account to make one withdrawal followed by one deposit. Your program should calculate the ending balancing after the withdrawal and deposit made by the account holder. It should also find the count of each one of these bills $78,...

  • 16. Using the descriptions of the attributes given in the figure, convert the ERD shown in...

    16. Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure P6.1 into a dependency diagram that is in at least BCNE. Figure 6.1 for problem 16. -- Initial ERD for Problem 16. APPOINTMENT PK App Num FK1 Doc_EmplD DOCTOR App_Date App_Time PK Doc EmplD App_PatientID App Name DocFname App_Phone Doc Lname App_Street Doc Cell Phone App_City App_State App Zip Doc_EmpID: Employee ID for the doctor. App Status Doc Fname: Doctor's first name. Doc_Lname:...

  • 1) Create Conceptual Schema Diagram 2) Create a fully attributed Loagical Data Model Diagram 3) Create...

    1) Create Conceptual Schema Diagram 2) Create a fully attributed Loagical Data Model Diagram 3) Create the SQL script that will generate the data model Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with corporations to determine their...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT