Homework Answers
This table satisfy all four normal forms.
It is in bcnf because.
Left side there is a super key.
No partial dependency.
No transitive dependency
If you need any explanation ask me..
Add Answer to:
For the following table, the primary key is Patient_ID + Test. Explain whether the table satisfy...
Dependency Very Good dependency (key dependency) : XA where Table Very good If all dependencies i...
Dependency Very Good dependency (key dependency) : XA where Table Very good If all dependencies in a table are '"very good", the table is in BCNF X is a candidate key Good Good dependency: X-> A where If all dependencies in a table are "very good" or "good", the table is in 3NF X is not a candidate key X is a part of a candidate key A is prime attribute Bad Bad dependency (Transitive Dependency): X A where If...
Consider the relational schemas given below and the respective sets of functional dependencies va...
Write the complete proof.
Consider the relational schemas given below and the respective sets of functional dependencies valid in the schemas For each one of the relational schemas, determine the highest normal form, which is valid for a schema. Justify your answer If a schema is not in BCNF, then decompose it into a minimum number of schemas so that each one of them is in BCNF. Justify your answers. Justification must include the derivations of minimal keys from the...
The employee is table, the best candidate for primary key is Select one: a. Department ID...
The employee is table, the best candidate for primary key is Select one: a. Department ID b. Employee hiredate c. Employee ID d. Employee salary Question 2 A primary key can be composed of more than one attribute. Select one: True False Question 3 A foreign key allows you to join two tables. Select one: True False Question 4 Given two tables, department (dept_id, dept_location, dept_name) and EMPLOYEE(emp_id, emp_name, emp_dept_id, emp_name, emp_salary), which attribute (column) is the foreign key? Select...
for question (c) do like this 3. A table to record the information of Dentists, Patients,...
for question (c) do like this
3. A table to record the information of Dentists, Patients, and Appointments in a clinic is given below. DentistNo DentistName PatientNo PatientName PatientPhone AppointmentDate Appointment Time AppointmentFee On a single day each patient can have more than one appointment. It is known that DentistNo is unique for each dentist. PatientNo is unique for each patient. PatientNo must not be used as a composite key. A patient is allowed to see any dentist. (a) Use...
2) Consider the following table of information Primary Key (CourselD, SemesterlD) CoursetD I Senester TD 1...
2) Consider the following table of information Primary Key (CourselD, SemesterlD) CoursetD I Senester TD 1 Places 1 Course Name IT101 1 2009-1 110I Programing IT1e1 I 2009-2 11e0 I Programming IT102 I 2009-11200 1 Databases IT102 I 2010-1 115I Databases IT103 2009-2 1120 I Web Design A. B. Normal Form Violation: Put into Sentence Structure: C. Normalized: 3) Consider the following: Primary Key ISBN ISBN Title Publisher Address A. B. Normal Form Violation: Put into Sentence Structure: C. Normalized:...
2) What normal form is this data in? Why? 3) What is the primary key of...
2) What normal form is this data in? Why? 3) What is the primary key of this table? 4) Draw a functional dependency diagram for this table 5) From your functional dependency diagram, determine the maximum set of 3NF tables that could be generated to minimize the data in the original table the most. Include tabulations (i.e., show the data) for your tables. Underline the primary key of each table. Circle or highlight the total number of tables you developed....
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...
2. The following is the relation notation of a table for a veterinary office. [70 pts....
2. The following is the relation notation of a table for a veterinary office. [70 pts. total] VETERINARY_OFFICE (PetID, PetName, PetType, PetBreed, OwnerID, OwnerLastName, OwnerFirstName, ServiceDescription, ServiceDate, ServiceCharge) The functional dependencies are given below: PetID -> PetName, PetType, PetBreed, OwnerID, OwnerLastName, OwnerFirstName OwnerID -> OwnerLastName, OwnerFirstName ServiceDescription -> ServiceCharge PetID, ServiceDate > ServiceDescription, ServiceCharge Assumptions: 1)A pet belongs to only one owner, 2) an owner may have more than one pet, 3A pet receives at most one treatment on any...
Please help me answer the following questions regarding data relationship tables. Employee ID First Name Last...
Please help me answer the following questions regarding data relationship tables. Employee ID First Name Last Name email Title Address Extension Department Department ID Hiring Date Department Phone # 0001 John Smith jsmith Accountant 1300 West st 5775 Accounting 2100 8/1998 407-366-5700 0002 Brian Miller badams Admin Assistant 1552 Palm dr 5367 Human resource 2300 4/1995 407-366-5300 0003 James Miller miller Inventory Manager 2713 Buck rd 5432 Production 2520 8/1998 407-366-5400 0004 John Jackson jackson_sam Sales Person 433 tree dr...
Patient Case Question 8. Identify five abnormal laboratory blood test values and explain whether these are...
Patient Case Question 8. Identify five abnormal laboratory blood test values and explain whether these are consistent or inconsistent with Turner syndrome. Patient Case Question 9. What is the significance of the two laboratory test findings in the last two rows of the third column in Table 62.2? Patient Case Question 10. How do you know that this patient's renal function is normal? Patient Case Question 11. How do you know that this patient's hepatic function is normal? Patient Case...
Dependency Very Good dependency (key dependency) : XA where Table Very good If all dependencies in a table are '"very good", the table is in BCNF X is a candidate key Good Good dependency: X-> A where If all dependencies in a table are "very good" or "good", the table is in 3NF X is not a candidate key X is a part of a candidate key A is prime attribute Bad Bad dependency (Transitive Dependency): X A where If...
Write the complete proof.
Consider the relational schemas given below and the respective sets of functional dependencies valid in the schemas For each one of the relational schemas, determine the highest normal form, which is valid for a schema. Justify your answer If a schema is not in BCNF, then decompose it into a minimum number of schemas so that each one of them is in BCNF. Justify your answers. Justification must include the derivations of minimal keys from the...
for question (c) do like this
3. A table to record the information of Dentists, Patients, and Appointments in a clinic is given below. DentistNo DentistName PatientNo PatientName PatientPhone AppointmentDate Appointment Time AppointmentFee On a single day each patient can have more than one appointment. It is known that DentistNo is unique for each dentist. PatientNo is unique for each patient. PatientNo must not be used as a composite key. A patient is allowed to see any dentist. (a) Use...
2) Consider the following table of information Primary Key (CourselD, SemesterlD) CoursetD I Senester TD 1 Places 1 Course Name IT101 1 2009-1 110I Programing IT1e1 I 2009-2 11e0 I Programming IT102 I 2009-11200 1 Databases IT102 I 2010-1 115I Databases IT103 2009-2 1120 I Web Design A. B. Normal Form Violation: Put into Sentence Structure: C. Normalized: 3) Consider the following: Primary Key ISBN ISBN Title Publisher Address A. B. Normal Form Violation: Put into Sentence Structure: C. Normalized:...
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...
Patient Case Question 8. Identify five abnormal laboratory blood test values and explain whether these are consistent or inconsistent with Turner syndrome. Patient Case Question 9. What is the significance of the two laboratory test findings in the last two rows of the third column in Table 62.2? Patient Case Question 10. How do you know that this patient's renal function is normal? Patient Case Question 11. How do you know that this patient's hepatic function is normal? Patient Case...
Most questions answered within 3 hours.
-
A marketing executive who knowingly authorizes a shoddy
defective product to be brought to market is...
asked 51 seconds ago -
Write a psudocode:
1. Define a function called authorize that takes in 2 strings,
uName, and...
asked 5 minutes ago -
What Hall voltage (in mV) is produced by a 0.180 T field applied
across a 2.60...
asked 4 minutes ago -
What mass of ethylene glycol (C2H6O2) must be added to 211.0 g
of water to obtain...
asked 7 minutes ago -
Mary's employer has a defined benefits retirement plan, which
pay 3.2% of her last year's salary...
asked 10 minutes ago -
What are the characteristics and behavior of an ethical
manager?
Explain, in your words, what ethics...
asked 27 minutes ago -
1. Which of the following is NOT an argument that McMahan uses
to show that jus...
asked 48 minutes ago -
A crate slides up a frictionless slope. At the end of 3 seconds
its velocity is...
asked 1 hour ago -
Use the following information to answer the next seven
questions.
Suppose there are three potential states...
asked 1 hour ago -
If we only have interstitial and substitutional diffusion, then
what do we consider the process of...
asked 1 hour ago -
You look at yourself in a shiny 9.6-cm-diameter Christmas tree
ball.
If your face is 21.0...
asked 1 hour ago -
If we were to measure the relaxation time of a muscle after
undergoing tetanus compared to...
asked 1 hour ago