For each of the following data elements, provide your recommendation for the appropriate type of data entry field:
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 |
For each of the following data elements, provide your recommendation for the appropriate type of data...
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 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 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 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 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, 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, 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 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 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 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...