Apply normalization of the following data table showing all required details patient patient patient national patient date of patient patient doctor doctor doctor medicine medicine number number birth address phone number name department name dose name 1 7143 Sara 5698563 14-Jul-2003 Amman 8787878 12 Rami 512 formet 2x2 3421 Ahmad 2946292 22-Aug-1943 Irbid 4545454 32 Jana 402 surrat 3x2 7631 Linda 7355028 5-Feb-1976 Karak 1212121 12 Rami 512 rodofen 2x2 4 9629 Karam 1737649 22-Aug-1984 Amman 7676767 45 Sameer 601 rodofen Зx1 5 4215 Muna 8539475 2-Sep-2001 Zarqa 8989898 76 Hana 322 bedocy 2x3 6342 Fadi 9653674 7-Nov-1992 Irbid 1234567 76 Hana 322 rodofen Зx2 7 2359 Samar 3372984 6-May-1998 Irbid 9876543 18 Salam 175 kalrasy 2x1

Apply normalization of the following data table showing all required details patient patient patient national patient date of patient patient doctor doctor doctor medicine medicine number number birth address phone number name department name dose name 1 7143 Sara 5698563 14-Jul-2003 Amman 8787878 12 Rami 512 formet 2x2 3421 Ahmad 2946292 22-Aug-1943 Irbid 4545454 32 Jana 402 surrat 3x2 7631 Linda 7355028 5-Feb-1976 Karak 1212121 12 Rami 512 rodofen 2x2 4 9629 Karam 1737649 22-Aug-1984 Amman 7676767 45 Sameer 601 rodofen Зx1 5 4215 Muna 8539475 2-Sep-2001 Zarqa 8989898 76 Hana 322 bedocy 2x3 6342 Fadi 9653674 7-Nov-1992 Irbid 1234567 76 Hana 322 rodofen Зx2 7 2359 Samar 3372984 6-May-1998 Irbid 9876543 18 Salam 175 kalrasy 2x1

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: How many different districts exist in the address table? Display: number of unique distinct names…

A: Introduction: SQL (Structured Query Language) is a programming language used for managing and…

Q: What Level of normalization is the following table? Student_ID Student_Name Course_ID…

A: The given table is in the First Normal Form (1NF), which means it has atomic values in each cell.

Q: Normalize the following unnormalized table using the three normalization rules and describe each…

A: Dear Student, The three normalization rules are nothing but the normal form conversion of the table,…

Q: d) Create the Crow's Foot ERD to show the relationships among EMPLOYEE, EDUCATION, and EMP_EDUC.

A: The question asks you to create a Crow's Foot Entity-Relationship Diagram (ERD) to show the…

Q: Identify the relational keys in the following two tables. Branch branchNo street city postcode 22…

A: we need some SQL keys here:- Keys aid in the identification of any row of data in a table. A table…

Q: Determine how long it takes for data to arrive.

A: When an event occurs, the amount of time it takes for your information to appear in your information…

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition. student…

Q: SALES Customer ID (primary key) Date of purchase Item code(foreign key) 001 2/05/2021 A-1 002…

A: Logical view : represents the functionality of the particular database to users.

Q: Convert to 1NF.

A: A database is said to be in 1NF if it satisfies the following rules:In database table, every column…

Q: Identify the relational keys in the following two tables. Вranch branchNo street city postcode | 22…

A: Super Key – A super key is a group of single or multiple keys which identifies rows in a table.…

Q: -6 Refer to the given table. Salesperson Number 137 137 137 106 106 106 106 204 204 361 361 361…

A: First Normal Form (1NF) is a property of a relation in a relational database. A relation is in first…

Q: Add the provided information to a new record in the REP table. SELECT * FROM REP Expected…

A: Insert into Clause is used for adding new information in table.

Q: Write the standard MYSQL query to retrieve the average customer balance grouped by SalesRepNo Write…

A: I have provided answers in step 2.

Concept explainers

Normalization

Normalization is the process of eliminating redundancy in a database by organizing the data into several smaller tables. The large tables are normalized (converted) into smaller tables by using normalization rules, so that a database administrator can easily handle them. It also eliminates insertion, deletion, and update anomalies.

Question

Apply normalization of the following data table showing all required details
patient
patient
patient national patient date of
patient
patient
doctor
doctor
doctor
medicine medicine
number
number
birth
address
phone
number
department
dose
name
name
name
1
7143
Sara
5698563
14-Jul-2003
Amman
8787878
12
Rami
512
formet
2x2
2
3421
Ahmad
2946292
22-Aug-1943
Irbid
4545454
32
Jana
402
surrat
Зx2
3
7631
Linda
7355028
5-Feb-1976
Karak
1212121
12
Rami
512
rodofen
2x2
4
9629
Karam
1737649
22-Aug-1984
Amman
7676767
45
Sameer
601
rodofen
Зx1
4215
Muna
8539475
2-Sep-2001
Zarqa
8989898
76
Hana
322
bedocy
2x3
6342
Fadi
9653674
7-Nov-1992
Irbid
1234567
76
Hana
322
rodofen
Зx2
2359
Samar
3372984
6-May-1998
Irbid
9876543
18
Salam
175
kalrasy
2x1

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Table name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 215 84 2002 215 HS 1991 215 JC 1994 216 B4 1989 216 CDP 2004 216 CNP 2002 216 HS 1985 217 HS 1992 217 JC 2000 218 B4 1990 218 CDP 2000 218 CNP 2005 218 HS 1984 218 M2 1995 TABLE EMPLOYEE EDUCATION Table name: EDUCATION EDU_CODE EDU_DESCRIPTION a) For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided. EMP_EDUC 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma PRIMARY KEY(s) Junior College degree Master's degree FOREIGN KEY(s)
Table name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995 215 84 215 HS 215 JC 216 B4 216 CDP 216 CNP 216 HS 217 HS 217 JC 218 B4 218 CDP 218 CNP 218 HS 218 M2 Table name: EDUCATION EDU_CODE EDU_DESCRIPTION 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma Junior College degree Master's degree
Normalize the relations into 3NF ORDERS ITЕM | ITEM_ NUM DESCRIP 6531 | Таре 7890 Table 7956 Pens 3456 Stove 4234 Paper 7956 Pens ORDER ID DATE CUST_ CUST_ NAME STATE QUANTITY ID PRICE 1001 7/7 A004 George VA 100.00 1 400.00 1 2.00 1002 7/8 A999 Ben PÅ 1 300.00 1003 7/9 A201 Tom PA 15 234.00 10 20.00
Normalization Diagram. See the attached picture.
IF POSSIBLE PLEASE TYPE OR WRITE ELIGIBLY illustrate the process of normalizing the data shown in this table to third normal form (3NF). officeNo officeAddress telNo mgrStaffNo name B001 8 Jefferson Way, Portland, ME 97201 503-555-3618 S1500 Tom Daniels B002 City Center Plaza, Seattle, WA 98122 206-555-6756 S0010 Mary Martinez B003 14 – 8th Avenue, New York, NY 10012 212-371-3000 S0145 Art Peters B004 16 – 14th Avenue, Seattle, WA 98128 206-555-3131 S2250 Sally Stern Primary key: officeNo Why the above table is not in 3NF? Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF). c) Identify the primary and foreign keys in your 3NF relations.
Identify the relational keys in the following two tables. Branch branchNo street city postcode SWI 4EH 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow GI1 9QX BS99 INZ NW10 6EU BO05 22 Deer Rd London BO07 B003 BO04 32 Manse Rd Bristol BO02 56 Clover Dr London Staff staffNo fName IName position sex DOB salary branchNo SL21 John White Manager M 1-Oct-45 30000 BO05 SG37 Ann Beech Assistant F 10-Nov-60 12000 BO03 SG14 David Ford Supervisor M 24-Mar-58 18000 BO03 SA9 Mary Howe Assistant F 19-Feb-70 9000 BO07 SG5 Susan Brand Manager F 3-Jun-40 24000 BO03 SL41 Julie Lee Assistant F 13-Jun-65 9000 BO05 Tabel Superkey Candidate Primary Key Alternate Foreign Key Key Keys Branch Staff
Using SQL find the number of employees from the table:
Answer the following questions by referring to the tables below. COURSE Course_name Course_number Credit_hours Department Intro to Computer Science CS1310 4 CS Data Structures CS3320 4 CS Discrete Mathematics MATH2410 3 MATH Database CS3380 3 CS SECTION Section_ID Course_number Semester Year Instructor 85 MATH2410 Fall 07 King 92 CS1310 Fall 07 Anderson 102 CS3320 Spring 08 Knuth 112 MATH2410 Fall 08 Chang 119 CS1310 Fall 08 Anderson 135 CS3380 Fall 08 Stone Retrieve a list of all the courses under the "CS" department, listed alphabetically by course name. Retrieve the section ID, course name, course number, semester, year, and Instructor of the courses taught by Instructor "Anderson". Insert a tuple for a new COURSE with the following information: 4.The course name is Computer networks, and the course number is CS3480. It belongs to the CS…