Victor Adams - Chapter 2 - Review Questions

How does denormalization differ from normalization, and when is it appropriate to use denormalized data?

34 Given the portion of data from the table Patient in the database. Patient ID Patient_FirstName 211347 Eliza 211348 Michael 211349 Ivan 211350 Suhail Patient_LastName Tan Lyod Tan Tan Patient_DOB Patient Address 29-Aug-2017 123, Jalan Bukit Katil, Minden, Penang 24-Sept-2016 87, Tmn Sentapan, Jelutong, Penang 23-Dec-2016 9-2-1, Apartment Jati, Muar, Johor 17-Jul-2015 11, Lebuh Lid, Goergetown, Penang 34a) Write the SQL query to select all columns from the Patient table for rows where the Patient's Last Name is "Tan" for its value. 34b) Based only on the given Patient table and based on the same criteria as above (34a), Write the SQL query to return only the Patient's ID and First Name columns, and who are also from the state of Penang.

Normalize the following unnormalized table using the three normalization rules and describe each step. Unnormalized table:

2. For the below Un-normalized table, apply the normalization forms and list all the Normalized tables Patient Treatment Patient# Name Room# Treatment# Name 568694 Coyle Morphine 568694 Coyle 568645 David 568675 Katie 105 105 106 106 10223 10224 Tetracyclene 10223 Morphine 10225 Hydromorphone Dosage 10 mg/ml 05. mg/ml 10 mg/ml 2.5 ml Start Date Finish Date 3/24/20 4/24/20 3/24/20 1/15/20 2/20/20 4/17/20 2/5/20 3/10/20

One hundred students were asked whether they had taken courses in any of the three subjects, Mathematics, Computer Science and Information Technology. The results were given below. 45 had taken Mathematics; 18 had taken Mathematics and Computer Science; 38 had taken Computer Science; 21 had taken Information Technology; 9 had taken Mathematics and Information Technology.; 4 had taken Computer Science and Information Technology and 23 had taken no courses in any of the subjects. Draw a Venn diagram that will show the results of the survey.

DCIT184 STAT181 Closely examine the following tables and use it to answer the questions that follow: department student_type student_category id |name | location | contact id name id name Computer Science Mathematics Statistics Sociology 005 | History English Linguistic North Ave 1 | +233234545453 North Ave 2 | +233234564554 North Ave 3 001 002 1 | Regular 2| Distance 3 | Sandwich 1 | Foreign 2| Local 003 +233285475547 004 East Ave 4 +233264638374 East Ave 2 +233244454744 006 East Ave 3 +233245653443 007 East Ave 4 +233268888888 course code | title dept_id | credit CSIT205 Object Oriented Techniques For IT Problem Solving Applied IT Programming Database Fundamentals Office Productivity Tools Programming Fundamentals Introduction to History History of The Gold Coast Introduction To Basic Statistics CSIT206 3 CSIT207 DCIT103 DCIT104 HIST101 5 | 3 HIST103 3 STAT101 Student id first_name last_name dob contact stud_cat_id | stud_type_id e0000001 Stephen Amankwah 1999-01-12 +233456789021 1…

42. Which quality of the table demonstrates why it is not in first normal form? A: There are only non-key attributes visible B: There is no primary key C: there is data redundancy D: each attribute has multiple values

Given the following MySQL table: persons (The Primary key in the first column and it is an automatic number) Table name: wilayats (for Wilayat data) wsq Table name: persons column names are highlighted prid prName prSalary prDoB prGender prWilyatsq wName Person ID Gender Wilayat id Salary Birth date 630 2011-08-03 Muneer Khalid 980 2009-01-25 870 2019-03-14 Name Wilayat ID Wilayat Name Nasser Aziz Nizwa Izki Bahla 200 M 3 300 M 2 Rawan Sami 500 F 3 2. Given also the following HTML form page and its source code that is used to add data to MYSQL database Web Browser Output 1. 2. Name :br> 3. Salary:br> 4. Birth Date: 5. Wilayat: 6. -- Select -- 7. Bahla.. 8. Gender:Male Adding data for a new Person Name: Jamal Obaid Salary: 550 Birth Date: 12/20/2002 Wilayat Bahla Gender: O Male O Female 10. Female 11. Save Data Note the following: • Do NOT write the validation part. Assume that data was input correctly. • Assume that the database connection id is $conn Write PHP code to do the…

Gulf Real Estate Properties Gulf Real Estate Properties, Inc., is a real estate firm located in southwest Florida. The company, which advertises itself as “expert in the real estate market,” monitors condominium sales by collecting data on location, list price, sale price, and number of days it takes to sell each unit. Each condominium is classified as Gulf View if it is located directly on the Gulf of Mexico or No Gulf View if it is located on the bay or a golf course, near but not on the Gulf. Sample data from the Multiple Listing Service in Naples, Florida, provided recent sales data for 40 Gulf View condominiums and 18 No Gulf View condominiums. Prices are in thousands of dollars. The data are shown in the following table.                                                                                                 Gulf View Condominiums No Gulf View Condominiums List Price Sale price Days to Sell List Price Sale Price Days to Sell 495 475 130 217…

Database System Write the relational schema for UNF, 1NF, 2NF and 3NF for this table.