Question 3:( DATABASE APPLICATION DEVELOPMENT )The following table represents the hours worked per week for temporarystaff at eachbranch of a company.TempStaffHoursstaffNo BranchNoBranchOfficeNamePositionHoursAddressPhonePerWeekCenter 111125Seattle,S4555CityPlaza,ВО02EllenAssistant16LaymanWA 98122S4555ВО041614th 422263EllenAssistant9.Avenue, Seattle,LaymanWA 98128S4612Center 111125CityPlaza,Seattle,ВО02DaveAssistant14SinclairWA 98122S4612B0041614th 422263DaveAssistant10Avenue, Seattle,WA 98128SinclairS4718DownTown 523632MaryKayВО01Cleaner8Alley, Jersey,JS 76542a) Determine one anomaly that exist in the TempStaffHours table andcriticize thedesign by giving an example of the anomaly.b) Given the following functional dependencies, perform normalizationuntil the third normal form. Give justification related to anomalies onthe design of the derived relations.staffNo, BranchNo → BranchAddress, OfficePhone, Name, Position,HoursPerWeekstaffNo → Name, PositionBranchNo > BranchAddress, OfficePhoneOfficePhone → BranchAddress

Given the following table we have to answers the following questions.

The following table represents the hours worked per week for temporary staff at eachbranch of a company. TempStaffHours staffNo Branch No Branch Office Name Position Hours Per Week Address Phone Center 111125 Seattle, S4555 B002 City Plaza, WA 98122 Ellen Assistant 16 Layman S4555 B004 16 14th 422263 Ellen Assistant 9 Avenue, Seattle, WA 98128 City Plaza,Seattle, WA 98122 Layman S4612 B002 Center 111125 Dave Assistant 14 Sinclair S4612 B004 16 14th 422263 Dave Assistant 10 Avenue, Seattle, WA 98128 Sinclair S4718 Town 523632 Mary Кay B001 Down Cleaner Alley, Jersey, JS 76542 a) Determine one anomaly that exist in the TempStaffHours table and criticize thedesign by giving an example of the anomaly. b) Given the following functional dependencies, perform normalization until the third normal form. Give justification related to anomalies on the design of the derived relations. staffNo, BranchNo → BranchAddress, OfficePhone, Name, Position, HoursPerWeekstaffNo → Name, Position BranchNo → BranchAddress, OfficePhone OfficePhone → BranchAddress 00

The following table represents the hours worked per week for temporary staff at eachbranch of a company. TempStaffHours staffNo Branch No Branch Office Name Position Hours Per Week Address Phone Center 111125 Seattle, S4555 B002 City Plaza, WA 98122 Ellen Assistant 16 Layman S4555 B004 16 14th 422263 Ellen Assistant 9 Avenue, Seattle, WA 98128 City Plaza,Seattle, WA 98122 Layman S4612 B002 Center 111125 Dave Assistant 14 Sinclair S4612 B004 16 14th 422263 Dave Assistant 10 Avenue, Seattle, WA 98128 Sinclair S4718 Town 523632 Mary Кay B001 Down Cleaner Alley, Jersey, JS 76542 a) Determine one anomaly that exist in the TempStaffHours table and criticize thedesign by giving an example of the anomaly. b) Given the following functional dependencies, perform normalization until the third normal form. Give justification related to anomalies on the design of the derived relations. staffNo, BranchNo → BranchAddress, OfficePhone, Name, Position, HoursPerWeekstaffNo → Name, Position BranchNo → BranchAddress, OfficePhone OfficePhone → BranchAddress 00

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

Similar questions

Q # 3. Implement a Tour Planner and Budget Calculator for Holidays. Program will ask the user to enter number of persons and the number of days for the tour. Program will show the menu for tour destination and accommodation options on the screen and ask the user to select the desired options. In budget calculation, destination expense will be multiplied with number of persons and the accommodation expense will be multiplied with number of days. Program will add Rs. 10,000 for Food Expense and Rs. 2500 as miscellaneous expense. Total tour budget will be calculated using the formula shown below: Total Budget = Travel Expense * No. of Persons + Hotel Expense * No. of Days t 10.000 + 2500 (Program should use switch-case statements to get user choice for Destination and Accommodation). Table 1. Destination Expense per person S# Destination Budget Rs. 10,000 Naran-Kaghan Neelum Valley Rs, 12,000 Malam Jabba Rs. 9,500 Rs. 28,000 4 Shangrilla Resort Rs. 5,000 Banjosa Lake
i want you to replace faculty with SEU
When should investigations of queuing procedures be conducted?
Supplier name ISBN Supplier code Date of supply Title Publisher 04 SUPPLIER Supply BOOK Authors Contact number Address Number of conie Date of Release: City Suburbs
A Small supermarket employs workers who are paid every week in hourly bases according to one of the following three rates (depending on their positions). Position Type Position Name Hours rate (AED) Admin Al 60 Worker P1 40 3 Worker P2 30
Use Case Diagram
Describe many ways for acquiring meeting control. What justification is there for this?
How is redundancy identified and eliminated during the normalization process?
DATABASE SYSTEMS AllTaste Restaurant is a restaurant that is famous for its taste, so it has a lot of customers. All the flavors are here, serving typical archipelago food that has spread in several cities with various mainstay menus. However, even though it already has many branches and a large number of order transactions every day, AllTaste Restaurant does not yet have an application and database to manage transactions and data. Order recording and sales reports are still done manually. AllTaste Restaurant owners know that information technology can support their business, so they plan to build applications to serve food orders both offline and online. In the database design stage, it is known as bottom-up, top-down, and inside-out approaches. Explain the three approaches! In your opinion, what approach is used for database system development at AllTaste Restaurant? Explain why you chose this approach! What techniques do you use to collect information (fact-finding technique)?…
Name of supplier ISBN Supplier number Title Publisher Date of supply 04 SUPPLIER Provider Supplier Address and Conie Number of the Authors Released on: City Suburbs