Suppose we view it as impossible to have two employees with exactlythe same first names, last names, and birth dates. We have no naturalidentifier for employees.Consider two cases:• Suppose that (firstName, lastName, birthdate) is the composite pri-mary key.• Suppose that a surrogate key is chosen for employees.For each case, show what happens to the employee table if we implementthe 1:M "supervises" relationship between two employees using foreignkeys. Show an example (for each case) of an employee table containing aboss and her two subordinates.(2)Continuing with the surrogate key approach in the previous table, showhow to introduce another entity (or table) to maintain history of the "su-pervises" relationship. (Do something similar to Figure 5.10 or 5.11.) FIGURE 5.10 MAINTAINING MANAGER HISTORYCurrent DataEMPLOYEEDEPARTMENTPKEMP NUMPKDEPT IDEMP LNAMEHE-managesEMP FNAMEEMP INITIALEMP E_MAILJOB_CODEEMP SALARYDEPT NAMEFK1 EMP NUMDATE ASSIGNEMP MGR_HIST%3EMP SAL HISTORYHistoric DataMGR HISTDEPT MGR_HISTSALARY HISTPK,FK1PK,FK2 DEPT IDPKEMP NUMPK,FK1 EMP NUMPKDATE ASSIGNSALARY START DATESALARY_AMTFIGURE 5.11 MAINTAINING JOB HISTORYEMPLOYEECurrent DataPKEMP NUMDEPARTMENTEMP LNAMEEMP FNAMEEMP_INITIAL HE--EMP E MAILFK1 DEPT IDJOB CODEDATE_ASSIGNEMP SALARYPKDEPT IDmanagesDEPT NAMEemploysH-FK1 EMP_NUMDATE ASSIGNHistoric DataJOB HISTDEPT JOB_HISTEMP_JOB HISTPK,FK1 EMP NUMPK,FK2 DEPT IDPKDATE ASSIGN POJOB_CODEEMP SALARY

Answered: Image /qna-images/answer/ca3cdbbf-3ddc-40bd-9280-1c575a61ac55.jpg

Answered: ntifier for employees. nsider two…

ntifier for employees. nsider two cases: • Suppose that (firstName, last Nam mary key. • Suppose that a surrogate kev is ch

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

PART 3 Relational Model EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary AAAA DEPARTMENT Dnamc Dnumber Mgr_san Mgr_start_datc AAA DEPT_LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Essn Pno Hours DEPENDENT Essn Dependent_name Sex Bdate Relationship Drawn the ER diagram Super_ssn Dno
The Problem to Solve: The user needs a program to interact with employee records. The kinds of interactions are "Add an Employee" (Create record), "Show All Employees" (Read records), "View an Employee" (Read one record), "Update an Employee" (Update or change a record), and "Delete an Employee" (Delete a record). These interactions form the standard data processes in much of business software Create, Read, Update, and Delete, which are known by the acronym CRUD. The user needs to continue working with records until they are ready to tell the program. To do this, the program will present a menu of CRUD options and an option to Quit. The user will choose an option and the program will react accordingly. For this lab, the program will only print out which option the user chose. In later labs, we will add more functionality. Questions: What are the inputs needed to solve this programming problem (names and data types)? What are the desired outputs (data types and descriptions)?…
When will the reference count of a managed object be increased by 1? The reference count is set when the manager object is created and does not change for the life of the object Each time the shared pointer's copy constructor is called Each time one of the shared pointers goes out of scope Each time the shared pointer is used
Film Actor Language Film SMALLINT VARCHARZ (255) VARCHAR2 (2 SMALLINT SMALLINT PF actor d SMALLINT PF fim id .im_id languaged SMALLINT CHAR (20) SMALLINT name description release year anguage_id original_language SMALLINT renta duration *rentaate engh *replacement_cost rating pecial features ustpdate SMALLINT NUMBER (42) SMALLINT Fam Category SMALLINT SMALLINT NUMBER (52) VARCHARZ 6) VARCHAR2 (255) TIMESTAMP PF Sm id KA category Actor actor id first name SMALLINT VARCHARZ (45) last rame VARCHAR (4) nationality CHAR (2) Category category SMALLINT VARCHAR2 (2) Country country d SMALLINT U short_code CHAR (2) VARCHARU (2) name P parent c SMALLINT name Using the film database you have, answer the following queries in your schema then write them down in this paper. Question One: Select the total rental_rate for films grouped by their categories. Order the result (a from largest to smallest. Select all actors who acted together with JOE in any film. Use inner query. (b Create a view, which…
database fundementals: GIVEN: Participant (PNumber, LastName, FirstName, Address, City, State, PostalCode, PhoneNumber, DOB) SK-->FirstName AK-->PhoneNumber Class(ClassNum, Description, NumOfPerson, Fee) SK-->Description ClassParticipant(PNumber, ClassNum, DataOfClass) FK-->PNumber-->Participant FK-->ClassNum-->Class Expand the database design so it will support the following report: Colonial Adventure Tours needs to send an invoice to each participant, listing the classes in which the participant is enrolled as well as the total fees for the classes. The invoice should include the participant’s full name and address. Answer in both DBDL and E-R diagram
5. For the following simple seven-activity project, develop a precedence network, calculate all relevant characteristics of each activity (ES, EF, LS, LF, TF), and calculate the project duration. Then draw a time-scaled network and under it a labor resource histogram for the ES. Do the same for the LS. In both cases, use the maximum allowable number of workers. Make adjustments to the noncritical activities, within the constraints of the ES and LF and the maximum and minimum workers allowed to provide what you feel is the best labor distribution. Please use Table B (Table B.pdf) Lastly, Explain in detail what do you feel is the biggest problem with the ES and LS configurations, and how has this been alleviated with your solution?
create one domain class diagram Use Case 1 Use Case Name: Self-service check in for road test Main Flow: Driver System 1 Requests to check in for road test. Prompts for scanning driver’s license. 2 Scans driver’s license. Searches driver’s information using the scanned driver’s license number, displaying driver’s full name, license number, expiry date, type of license, and booked road test information (date, time and location of the road test). Prompts for confirmation. 3 Confirm to check in. (*1) Records the check in by changing the road test status to checked-in; adds the driver into the waiting list for road tests. Alternate Flows Alternate Flow Description A1 Some information displayed is not correct. Driver will not confirm the check in and system will prompts the driver to go to a clerk for help.
Consider a database that includes four relations Student, Staff, Program, Advisor Student BannerID FName LName PCode 8003778543 James Oloye PO01 8765990453 Paul Carter P002 8002786543 Anita Boris PO01 8307563321 Jane Eyre P001 Staff BannerID FName LName PCode 8014768954 Chimamanda Adichie PO02 8001876565 Paulette Davis P001 Program PCode PName PO01 Library Science PO02 Management and Information Science
The entity relationship diagram below models the components of a database belonging to TrueHealth, a network of medical centers. The database allows TrueHealth to keep track of doctors at each practice and their patients. Patient PK Pat ID Consultation Doctor PK,FK1 Doc_ID PK Doc ID 1..1 0.. 1..1 Pat_Name PK, FK2 Pat ID Doc_Name Pat Age Con_Date Doc_EmployDate Pat_Gender FK Prc_ID 0..* 1..1 Practice PK Prc ID Prc_Name Prc_YearEstablished Prc_Province Write SQL statements for the following: Create all the necessary tables. Name the tables; and all their attributes appropriately. Insert TWO records into each of the tables created to demonstrate that you have created them correctly. List all the TrueHealth practices based in Gauteng. List, in alphabetical order, the names of all patients who had consultations after 01 January 2018. Which practice (by name) has the most recent hire (i.e. doctor with latest employment date)? Which doctor has had the least number of consultations? Give the…
Prepare and fill in a table with TableName, PrimaryKey and ForeignKeys column headings according to the class diagram given. Payment datePaid amountPaid type CustomerAccount balance dateBilled amountBilled 1... PickupRequest OTRequested DTPickedup locationAddress 1 IndividualCustomer 1 1... name address phone 1 Customer 1 BusinessCustomer contact Person contactPhone 0... Package deliver ToName deliver ToAddress weight cost DTDelevered 1 Route Trip date startTime end Time mileage 0.. 0... 1 1... Employee hame address phone MovementEvent typeOfEvent OTOfEvent
Given the following relation that stores details of employees and their projects: ProjectID EmployeeName EmployeeSalary 100-A Salim Housni 2000 100-A Taleb Maashani 1800 100-B Taleb Maashani 1800 200-A Salmi Alrisi 2000 200-B Salmi Alrisi 2000 200-C Salmi Alrisi 1350 200-C Taleb Maashani 1800 200-D Salim Housni 1350 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. ProjectID > EmployeeName | ProjectID > EmployeeSalary| ProjectID, EmployeeName > EmployeeSalary | EmployeeName > EmployeeSalary | EmployeeSalary > ProjectID EmployeeSalary → EmployeeName , ProjectID
courses dasses ↑coursel INT courseDateTime DATETIME O room INT coursel INT courseName VARCHAR(45) course Description VARCHAR(45) room are used by a class. For each entity: Entitios rooms Froom DVT L-building VARCHAR(X) capacity VARCHAR(45) Inders The ERD depicts the data needed to track which course and Indicate if the entity is strong, weak ID-dependent, or weak non-ID-dependent For each relationship: • List the cardinality and participation of each entity in the relationship List the business rules for each relationship Indicate if the relationship is identifying or not