Below given relations of a database are in First Normal Form (1st NF). Decompose (Split) therelations to Normalize in 2NF and 3NF.tbl ProjectProjectCodeProject NameProject Manager BudgetReservation SystemHR SystemAttendance SystemPC010Mr. Said25000PC011MS. Malak32000PC012Mr. Rajesh19000DBMStbl Emp DeptProject CodeEmp NoHourly PayEmp Name Dept No Dept NameAli Mohd.PC010S100D03Database7.500PC010S101HamoodD02Testing5.500PC010S102RiyazD01IT8.200PC011S103PavanD03Database6.500PC011S104BasmaD02Testing5.400PC011S115AsaadD01IT7.900PC012S137FathimaD03Database6.200PC012S218AvinashD02Testing6.100PC012S109РоojaD01IT9.300

For the relation Project, The primary key is {ProjectCode} The function dependency possible is…

relations to Normalize in 2NF and 3NF. tbl Project Project Code PC010 Project Name Project Manager Budget Reservation System HR System Attendance System Mr. Said 25000 PC011 MS. Malak 32000 PC012 Mr. Rajesh 19000 BMS tbl Emp Dept Project Code Emp Name Dept No | Dept Name Ali Mohd. Hourly Pay Emp No S100 PC010 D03 Database 7.500 PC010 si01 Hamood D02 Testing 5.500 Riyaz Pavan 8.200 6.500 PC010 S102 s103 D01 D03 IT PC011 Database Testing IT PC011 S104 Basma D02 5.400 PC011 si15 Asaad D01 7.900 PC012 S137 Fathima D03 Database 6.200

relations to Normalize in 2NF and 3NF. tbl Project Project Code PC010 Project Name Project Manager Budget Reservation System HR System Attendance System Mr. Said 25000 PC011 MS. Malak 32000 PC012 Mr. Rajesh 19000 BMS tbl Emp Dept Project Code Emp Name Dept No | Dept Name Ali Mohd. Hourly Pay Emp No S100 PC010 D03 Database 7.500 PC010 si01 Hamood D02 Testing 5.500 Riyaz Pavan 8.200 6.500 PC010 S102 s103 D01 D03 IT PC011 Database Testing IT PC011 S104 Basma D02 5.400 PC011 si15 Asaad D01 7.900 PC012 S137 Fathima D03 Database 6.200

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

What are the advantages of using the use of a system for managing change requests?
Explore the use of modeling techniques like UML (Unified Modeling Language) in requirement analysis. How can UML diagrams help visualize and specify requirements?
Define the term compatibility requirements?
Assume that you are working as a project manager in a reputed organization, and you have been assigned with a new project to develop a suitable system for the following scenario. A leading job recruitment and training institution in Oman would like to develop a system to manage all their functional requirements like upload the current job requirements as well the courses they have offered. The website can be used by the job seekers as well as for trainees to take up a training on any course they are offering. The system should have the features for the clients to Sign in, register, Upload CV, apply for an existing job. The website should also show all the information about a course such as course name, duration, fee, certification details. Job seekers can even register for a course and if the candidate outperforms in the course they have registered for, they will automatically be mapped onto any job with those requirements. The website should have the facility to make the payment on…
please help stuck on this problem
software architecture
Write down Requirements Tests of Sales Management System by using the Following template. Use at least 4 to 5 requirement of Sales Management System and fill the given table. Requirement Test Template Req ID Req Title Related Requirements Test Input Test Applied Expected Test output Problem in Requirement Recommendations to resolve Requirement Problem Example of Requirement Test Req ID FR10 Req Title Authenticate User Related FR11, FR13 Requirements Test Input Username, Password Test Applied For each class of User, enter username and password and identify the services expected for that class of user Expected Test output The result of the login should be web page with a menu of available services Problem in We do not know the different classes of system Requirement users and the services which are available to each user class. Apart from the administrator, are all other system users in the same class? Recommendations to Explicitly list all user classes and the services resolve which…
What Is Finalize System Details?
What is the definition of software product configuration? Is it feasible to talk about configuration management?
I am planning to create a faculty loading system and I need to find out what questions need to answer before creating it. Could you give me questions about faculty loading system.
How has computing been used to support requirements determination?
The XY team, led by Lukman, is currently working on a cloud-based human resource management system (HRMS) project. The project is supposed to release a new baseline by June 2021. Since the project is approaching its deadline, the project manager has assigned XY team to perform requirements validation in two weeks’ time. The new baseline is expected to release a new version of requirements specification, a major update from the previous version; SRS V2.4. Read the following scenario and suggest solutions for each of the following questions. QUESTION C Consider the following scenario happens during the validation process lead by Lukman. Evaluate the following action taken by the team during the validation. For each scenario, identify its appropriateness (of action taken) by writing ‘appropriate’ or ‘not appropriate’ then map the case with the related validation principles. i) Before the validation session begins, Lukman reminds all reviewers to immediately correct the…