Read carefully question numbmer (1.b) exhibit "1NF" not referential integrity or entity integrity, (Just 1NF)(Q1) Use the database shown in Figure 1.1 to answer questions a through h.(1.a) For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write NA (Not applicable).(1.b) Do the tables exhibit 1NF? Answer Yes or No, and explain your answer for each table Table name: STORESTORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE$1,003,455.76$1,421,987.39$986,783.221 Access Junction82 Database Corner2123 Tuple Charge174 Attribute Alley$944,568.5635 Primary Key Point$2,930,098.45115Table name: REGIONREGION_CODE REGION_DESCRIPTEast2 West Table name: EMPLOYEEEMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODEMr.VilliamsonJohn21-May-642 Ms.RatulaNancy09-Feb-693 Ms.GreenboroLottie02-Oct-6144 Mrs.Rumpersfro Jennie01-Jun-715 Mr.6 Mr.7 Mr.8 Ms.9 Mr.SmithRobert23-Nov-593RenselaerCary25-Dec-651OgalloJohnssonRoberto31-Jul-623Elizabeth10-Sep-681EindsmarJack19-Apr-5510 Mrs.JonesRose06-Mar-66411 Mr.BroderickTom21-Oct-723+12 Mr.08-Sep-7425-Aug-6425-May-6624-May-64WashingtonAlanY13 Mr.SmithPeter314 Ms.SmithSherry4+15 Mr.OlenkoHoward16 Mr.ArchialoBarry03-Sep-60517 Ms.GrimaldoJeanineK12-Nov-70418 Mr.RosenbergAndrewD24-Jan-71419 Mr.RostenPeterF03-Oct-68420 Mr.MckeeRobert06-Mar-70121 Ms.BaumannJenniferA11-Dec-743.Table name: STORESTORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE$1,003,455.761 Access Junction2 Database Corner3 Tuple Charge4 Attribute Alley5 Primary Key Point$1,421,987.392$986,783.221$944,568.563$2,930,098.451150273ZID>+ ++ ++ + + ++ ++ ++

Introduction: Primary key: It is unique that is used to identify/find a row/tuple of a table.…

(Q1) Use the database shown in Figure 1.1 to answer questions a through h. (1.a) For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write NA (Not applicable). (1.b) Do the tables exhibit 1NF? Answer Yes or No, and explain your answer for each table

(Q1) Use the database shown in Figure 1.1 to answer questions a through h. (1.a) For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write NA (Not applicable). (1.b) Do the tables exhibit 1NF? Answer Yes or No, and explain your answer for each table

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter8: Advanced Data Handling Concepts

Section: Chapter Questions

Problem 17RQ

See similar textbooks

Related questions

Q: Consider the relational database of Figure 3.19, where the primary keys areunderlined. Give an…

A: select e.ID, e.person_name, e.city from employee e, works w where e.ID = w.ID and company_name =…

Q: Consider the following database schema and specify the following queries or views in SQL.…

A: a)select SSN,name from EMPLOYEE where SSN in(select SSN from WORKON group by SSN having…

Q: Normalise the following relation to remove modification anomalies showing all steps for 1NF, 2NF and…

Q: QUESTION 5 Consider the following relations in a University database: Student (SID, SName, Age, GPA)…

A: The SQL statement plays a major role to retrieve the data according to user requirements. The…

Q: Consider the Student database schema given below. 1. Write SQL to Retrieve student id's and student…

A: The tables student and enrolled created and inserted data The table student is: Table enrolled is:…

Q: Suppose you are a manufacturer of product ABC, which is composed of parts A, B, and C When a new…

A: a) Inventory update requires 4 or 2 database requests. PRODUCT table requires 1 database request,…

Q: 6. Conduct the 1NF then the 2NF for the Book Store Database - DraftTable, then write the resulted…

A: Normalization: It is a process of decomposition of large table into a small number of tables.A…

Concept explainers

Transaction Processing

Transaction processing is a computational style generally performed by server computers, which supports interactive applications (apps). Transaction processing is also known as information processing, which divides the work into indivisible and individual operations called transactions. The transaction is a set of tasks; a single task is considered as the minimum processing unit that cannot be divided again.

Question

100%

Read carefully question numbmer (1.b) exhibit "1NF" not referential integrity or entity integrity, (Just 1NF)

(Q1) Use the database shown in Figure 1.1 to answer questions a through h.
(1.a) For each table, identify the primary key and the foreign key(s). If a table does not have a
foreign key, write NA (Not applicable).
(1.b) Do the tables exhibit 1NF? Answer Yes or No, and explain your answer for each table

Table name: STORE
STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE
$1,003,455.76
$1,421,987.39
$986,783.22
1 Access Junction
8
2 Database Corner
2
12
3 Tuple Charge
1
7
4 Attribute Alley
$944,568.56
3
5 Primary Key Point
$2,930,098.45
1
15
Table name: REGION
REGION_CODE REGION_DESCRIPT
East
2 West

Table name: EMPLOYEE
EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE
Mr.
Villiamson
John
21-May-64
2 Ms.
Ratula
Nancy
09-Feb-69
3 Ms.
Greenboro
Lottie
02-Oct-61
4
4 Mrs.
Rumpersfro Jennie
01-Jun-71
5 Mr.
6 Mr.
7 Mr.
8 Ms.
9 Mr.
Smith
Robert
23-Nov-59
3
Renselaer
Cary
25-Dec-65
1
Ogallo
Johnsson
Roberto
31-Jul-62
3
Elizabeth
10-Sep-68
1
Eindsmar
Jack
19-Apr-55
10 Mrs.
Jones
Rose
06-Mar-66
4
11 Mr.
Broderick
Tom
21-Oct-72
3
+
12 Mr.
08-Sep-74
25-Aug-64
25-May-66
24-May-64
Washington
Alan
Y
13 Mr.
Smith
Peter
3
14 Ms.
Smith
Sherry
4
+
15 Mr.
Olenko
Howard
16 Mr.
Archialo
Barry
03-Sep-60
5
17 Ms.
Grimaldo
Jeanine
K
12-Nov-70
4
18 Mr.
Rosenberg
Andrew
D
24-Jan-71
4
19 Mr.
Rosten
Peter
F
03-Oct-68
4
20 Mr.
Mckee
Robert
06-Mar-70
1
21 Ms.
Baumann
Jennifer
A
11-Dec-74
3.
Table name: STORE
STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE
$1,003,455.76
1 Access Junction
2 Database Corner
3 Tuple Charge
4 Attribute Alley
5 Primary Key Point
$1,421,987.39
2
$986,783.22
1
$944,568.56
3
$2,930,098.45
1
15
0273
ZID>
+ ++ +
+ + + ++ ++ ++

Organized collection of structured information, or data, typically stored in a computer system.

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 3

VIEW

Step by step

Solved in 3 steps

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

Attempt to view the structure of the HOMEWORK13 view.
Check the entities to be in the 3NF normal form
Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME D102 ELC D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE Hisham 6/1/1999 Male 90 D102 S103 A102 Level 1 22 12/30/1994 Female 45 D103 S102 Sara A104 Diploma 27 S101 Salim 6/1/1999 Male 45 | D103 A104 Diploma 22 5107 Khalil 5/6/1995 Male 45 D101 A101 Blech 26 45 | D104 Advanced Diploma S109 Said 10/15/1992 Male A101 29 5/1/1995 Male 45 D101 90 D104 5100 Ahmad BTech Advanced Diploma A103 26 4/5/1998 Male 2/23/1992 Female 9/12/1999 Female S104 Faisal A101 23 0 D102 45 D102 S105 Fatima 90 A102 Level 2 29 S106 Arwa A102 Level 3 22 S108 Ibtisam 8/13/1991 Female 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of…
Convert to normilation (1-NF or 2-NF or 3-NF
candidate key only branchNo and postcode
Name the candidate keys in the following table: Student L number Student Name Student_SS_Number Student_Address Student City Student State LO005485 Leigh 811-47-4449 5744 KENSINGTON Ave. Boston MD LO004812 Tammy 441-79-7448 30936 OAK Alley Colorado Springs TX LO004415 Alfredo 375-78-2633 5115 BOWEN St. Kansas City VT LO003478 Ramona 360-82-2835 5097 HUBBARD LOWER Blvd. Miami PA LO003058 Crystal 528-16-2635 73192 RANDOLPH SUB Dr. Riverside MD LO004588 Angie 765-16-4433 5115 GROVELAND PARK Dr. Cincinnati FL L0005484 Tonya 410-76-3632 5115 BISHOP FORD Blvd. Irving MS LO003161 Preston 451-47-2634 95289 MONROE Ave. Boston NC HTM B I A - A - I E E E E E X X, E E D T T 12pt Paragraph
View 3 Seneca Courses Inc. Employee Forms All employee information for SCI is maintained on file forms. The following are sample employee information forms: EMP_ID 7839 EMP_ID 7654 EMP_NAME JOHN CHIU EMP_NAME ANDRE MARTIN SOC_INS 123-234-345 SOC_INS 678-345-123 POSITION MANAGER POSITION SALES SUPERVISOR SUPERVISOR JOHN CHIU HIREDATE November 13, 1999 HIREDATE September 24, 1999 EMP_ID 7434 EMP_ID 7435 EMP_NAME PARVEZ RAI EMP_NAME DANIEL CHOY SOC_INS 234-123-432 SOC_INS 345-312-234 POSITION SALES POSITION CLERK SUPERVISOR JOHN CHIU SUPERVISOR HIREDATE June 24, 1980 HIREDATE August 4, 1998 Business Rules: 1. SOC_INS must always be different for each employee. 2. EMP_NAME must always have a value. Normalize the above user view. Document all steps including UNF, 1NF, Dependencies, 2NF, and 3NF…
Access Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…
Create a list manager names and also his supervise names if the manager has any one
5. EMP table has records as follows: EMP_NUM EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL Kolmvcz George Lewis Rhonda Rhett Vandam 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 Mr. Ms. Mr. Ms. Mr. Mr. Mrs. Mr. Mr. Mr. Mrs. Mr. Mr. Ms. Ms. Mrs. Mr. Jones Lande Williams Smith Diante Employee Rhonda Lewis Rhett Vandam Jeanine Jorae Wiesenbach Paul Smith Genkazi Washington Johnson Smythe Brandon Saranda Smith Anne John Robert Anne Jones John Lange Jeanine Smith Jorge Diante George Smith Leiahla Genkazi Rupert Washington Edward Johnson Melanie Smythe Marie Brandon Hermine Saranda George Smith George Leighla Rupert Edward Melanie Marie Hermine George D G Manager George Kolmvcz George Kolmvcz George Kolmvcz Robert Williams Robert Williams Robert Williams Paul Wiesenbach Paul Wiesenbach Robert Williams George Kolmvcz Robert Williams Paul Wiesenbach Robert Williams Paul Wiesenbach ZAOXO xx wwa. M P D K D R K W E E P G R EMP_DOB 1942-06-15 00:00:00 1965-03-19 00:00:00…
Database course
Q2: A-Given the following tables: Student Subject Std_ID 001 002 003 004 Fname Smith Smith Beal Thomson Lname Jolin Susan Fred Marie Std_ID 001 001 002 002 003 Semester 004 Falls03 Spro4 Falls03 C_ID Eng01 Ger01 Eng01 Ger01 Ger01 CSection Spro4 Spro4 Spro4 1. For each table in the database, identify the primary key and the foreign key(s). 2. Do the tables exhibit entity integrity? Explain your answer? 3. Do the tables exhibit referential integrity? Explain your answer? Ita01 ZZZZZZ IN 2N IN 2N IN CName English IN German English German German Italian Grade A B A B A B