Using the descriptions of the attributes given in the following figure, convert the ERD into a dependency diagram that is in at least 3NF.
Homework Answers
Functional Dependencies:
Doc_EmpID -> Doc_Fname, Doc_Lname, Doc_CellPhone
App_PateintID-> App_Name, App_Phone, App_Street, App_City, App_State, App_Zip, App_Status
App_Zip -> App_City, App_State
Since there are no partial dependencies, tables are already in 2NF.
Functional dependencies 2 and 3 are transitive dependencies, thus table appointment is not in 3NF. Table can be divided as:
Appointment(App_Num, Doc_EmpID,App_Date, App_Time, App_PatientID)
Patient(Patient_ID, Name, Phone, Street, Zip, Status)
Zip(Zip, City, State)
Add Answer to:
Using the descriptions of the attributes given in the following
figure, convert the ERD into a...
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:...
Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure...
Using the descriptions of the attributes given in the figure,
convert the ERD shown in Figure P6.2 into a dependency diagram that
is in at least 3NF
Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure P6.2 into a dependency diagram that is in at least 3NF
The relationship strengths shown here are not correct. List the relationship strength as either weak or...
The relationship strengths shown here are not correct. List the
relationship strength as either weak or strong
based on your knowledge of primary keys.
A:
weak
B:
C:
D:
E:
F:
G:
H:
APPONTMENT PK APPT NUM APPT DATE APPT TIME PATIENT DOCTOR PK PAT NUM FK1 INS PLAN CD PK DOC ID PAT_LNAME PAT FNAME PAT AREACODE PAT PHONE PAT EMAIL DOC LNAME DOC FNAME DOC OFFICE DOC EXTENSION FK1 PAT NUM FK2 DOC...
please complete this ERD diagram with proper signs and lines and write all tables in a...
please complete this ERD diagram with proper signs and
lines and write all tables in a text format highlighting all PK's
and FK's
table User PK User ID Login ID Password Level First Name Middle Name Last Name table Tenant table Employee PK Tenant ID PK Employee ID FK1 User ID Tenant Unit No Building ID Tenant Address Tenant City Tenant State Tenant Zip Tenant Phone FK1 User ID Employee Title Employee Address Employee Age Employee Salary table Work Order...
Create the database and tables for the database. Show all SQL statements. Include primary and foreign...
Create the database and tables
for the database. Show all SQL statements. Include primary and
foreign keys. Insert data into each table. Show select statements
and display the output of each table. Note:Student’s name must be
inserted into table as part of the data! Perform the SQL below:
Query one table and use WHERE to filter the results. The SELECT
clause should have a column list, not an asterisk (*). State the
purpose of the query; show the query and...
Make an ERD using the following description
WardsThe Hope Hospital has 17 wards with a total of 240 beds available for short- and long-term patients, and an outpatient clinic. Each ward is uniquely identified by a number (for example, ward 11) and also a ward name (for example, Orthopedic), location (for example, E Block), total number of beds, and telephone extension number (for example, Extn. 7711).Staff The Hospital has a Medical Director, who has overall responsibility for the management of the hospital. The Medical Director maintains control...
Draw an ERD diagram in chen's notation for the following: Whenever new patients are seen for...
Draw an ERD diagram in chen's notation for the following: Whenever new patients are seen for the first time, they complete a patient information form that asks their name, address, phone number, and insurance carrier, which are stored in patient information file. Patients can sign up with only one carrier, but they must be signed up to be seen by the doctor. Each time a patient visits the doctor, an insurance claim is sent to the carrier for payment. The...
Make an ERD including all entities, attributes, relations, and constraints. Please upload as a doc based...
Make an ERD including all entities, attributes, relations, and constraints. Please upload as a doc based on everything listed below University Bookstore •University Bookstore has several branches throughout Bloomington, and employees may be assigned to work at any of the branches. •Employees are identified by an ID and have a full name, date of birth, SSN, address, multiple phone numbers, a gender, and a hire date. •A Manager runs a branch and is responsible for all operations at that branch....
Answer all questions on paper: Consider the database model below The database model FIGURE 7.1 CUSTOMER...
Answer all questions on paper: Consider the database model below The database model FIGURE 7.1 CUSTOMER INVOICE LINE PK CUS CODE INV NUMBER FK1 CUS_COOE NV DATE CUS LNAME CUS FNAME CUS INITIAL CUS AREACODE CUS PHONE CUS BALANCE LINE UNITS LINEPRICE - isfound in VENDOR PRODUCT V NAME supplies P INDATE P DESCRIPT CONTACT de- V AREACODE V PHONE V STATE V ORDER ?,.QOH P MIN P PRICE Write the SQL code for creating the database and all the...
Specify relational calculus expression for the following descriptions on the Library database schema shown in Figure...
Specify relational calculus expression for the following
descriptions on the Library database schema shown in Figure
4.6.
a) Retrieve Publishers’ name and phone number whose books where
borrowed from Baltimore Branch.
b) List the book title, book id and branch name with less than
10 copies
c) List customer card number, customer name, branch name and
book title for books which are currently on loan.
BOOK Book id Title Publisher_name BOOK_AUTHORS Book idAuthor name PUBLISHER Name Address Phone BOOK COPIES...
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:...
Using the descriptions of the attributes given in the figure,
convert the ERD shown in Figure P6.2 into a dependency diagram that
is in at least 3NF
Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure P6.2 into a dependency diagram that is in at least 3NF
The relationship strengths shown here are not correct. List the
relationship strength as either weak or strong
based on your knowledge of primary keys.
A:
weak
B:
C:
D:
E:
F:
G:
H:
APPONTMENT PK APPT NUM APPT DATE APPT TIME PATIENT DOCTOR PK PAT NUM FK1 INS PLAN CD PK DOC ID PAT_LNAME PAT FNAME PAT AREACODE PAT PHONE PAT EMAIL DOC LNAME DOC FNAME DOC OFFICE DOC EXTENSION FK1 PAT NUM FK2 DOC...
please complete this ERD diagram with proper signs and
lines and write all tables in a text format highlighting all PK's
and FK's
table User PK User ID Login ID Password Level First Name Middle Name Last Name table Tenant table Employee PK Tenant ID PK Employee ID FK1 User ID Tenant Unit No Building ID Tenant Address Tenant City Tenant State Tenant Zip Tenant Phone FK1 User ID Employee Title Employee Address Employee Age Employee Salary table Work Order...
Create the database and tables
for the database. Show all SQL statements. Include primary and
foreign keys. Insert data into each table. Show select statements
and display the output of each table. Note:Student’s name must be
inserted into table as part of the data! Perform the SQL below:
Query one table and use WHERE to filter the results. The SELECT
clause should have a column list, not an asterisk (*). State the
purpose of the query; show the query and...
Answer all questions on paper: Consider the database model below The database model FIGURE 7.1 CUSTOMER INVOICE LINE PK CUS CODE INV NUMBER FK1 CUS_COOE NV DATE CUS LNAME CUS FNAME CUS INITIAL CUS AREACODE CUS PHONE CUS BALANCE LINE UNITS LINEPRICE - isfound in VENDOR PRODUCT V NAME supplies P INDATE P DESCRIPT CONTACT de- V AREACODE V PHONE V STATE V ORDER ?,.QOH P MIN P PRICE Write the SQL code for creating the database and all the...
Specify relational calculus expression for the following
descriptions on the Library database schema shown in Figure
4.6.
a) Retrieve Publishers’ name and phone number whose books where
borrowed from Baltimore Branch.
b) List the book title, book id and branch name with less than
10 copies
c) List customer card number, customer name, branch name and
book title for books which are currently on loan.
BOOK Book id Title Publisher_name BOOK_AUTHORS Book idAuthor name PUBLISHER Name Address Phone BOOK COPIES...
Most questions answered within 3 hours.
-
You purchase your daily coffee at the Chemist’s Coffeehouse and
have a choice of two cups:...
asked 1 hour ago -
Which of the following pairs of chemicals could be used to make
a buffer solution?
A.)...
asked 49 minutes ago -
Problem 16-51 Sales
Activity Variance (LO 16-3)Odessa, Inc., reports the following
information concerning operations for the...
asked 1 hour ago -
Pictured on the right are thee point charges Q1 = 18.4 μC, Q2 =
-30.6 μC,...
asked 1 hour ago -
A graduate student is conducting research in psychology and
needs to obtain the IQ scores of...
asked 2 hours ago -
R2.84: There are 2 defective products in a production lot of 10.
An inspector randomly selected...
asked 3 hours ago -
Consider the following equilibrium system: COCl2(g) CO(g) +
Cl2(g) A 10.00 L evacuated flask is filled...
asked 3 hours ago -
1) What are the two distinct steps that one needs to perform
when developing a data...
asked 4 hours ago -
2) Write a C++ program that uses a class called “Degree” to
obtain the trigonometric
values...
asked 5 hours ago -
1. In eukaryotic cells the genomes of
&
asked 5 hours ago -
The standard enthalpy of propanol (C3H7OH) is -303.0 kJ/mol.
Compute both of the
gross and net...
asked 5 hours ago -
Why PWM using H-bridge for control motor speed is more power
effiecient than the linear amplifier...
asked 5 hours ago