(d)A sample of 800 workers indicated whether they are single or married andwhether they work morning shift, afternoon shift, or night shift. The informationobtained appears in the following two-way classification table.Marital statusSingleMarriedMorning160360Afternoon60100Work shiftNight8040(i)Explain the following terms based on 2(c) above.ORC:ERC :

Answered: Single 160 60 Marital status

Engineering

Computer Science

Single 160 60 Marital status

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 17RQ: List the changes you would need to make to your answer for Question 11 if the requirements change so...

See similar textbooks

Similar questions

List the changes you would need to make to your answer for Question 11 if the requirements change so that you must store the year and the semester in which a student took a course and received a grade.
Let's say we have the attached table : 3. Find the years that company hired more than 5 employees
Use the following diagram relation to perform the normalization. You need to provide the 2NF and 3NF.
Use the preamble below to answer QUESTIONS I and QUESTIONS 2 A university SOG is made up of employees who belongs to the various departments and are characterized by their staff ID, first name, last name and date of birth. Also students are part of the university and can also be characterized by student ID, first ame, last name, date of admission. Every employee and student belongs to a particular department which can be characterized by the department ID and the department name. Again all students offer a particular program which can be identified by the program ID and program name and also a course that is offered by the students that can be identified by the course ID and the course name. a. Create SOG University database using SQL Data Definition Language. b. Create two (2) tables in the SOG University database from the schemas in QUESTION Ie using SQL. Data Definition Language. c. List the student ID of all students who do not belong to a department with departmentID7 in the SOG…
Create a Crow's Foot ERD for the following description: The KwikTite Corporation operates many factories. Each factory is located in a region, and each region can be "home" to many of KwikTite's factories. Each factory has many employees, but each employee is employed by only one factory.
Consider the System Description of question no 2. All the student are advising to reply the following queries, keeping in view the above mention system description title as "Dream Home branch offices case study". (a) List the details of branches in a given city. (b) Identify the total number of branches in each city. (c) List the name, position, and salary of staff at a given branch, ordered by staff name. (d) Identify the total number of staff and the sum of their salaries. (e) Identify the total number of staff in each position at branches in Glasgow. (f) List the names of staff supervised by a named Supervisor. (g) List the property number, address, type, and rent of all properties in Glasgow, ordered by rental amount. (h) Create a branch and staff relationship in view of joint perspective. (1) List the details of properties for rent managed by a named member of staff. G) Identify the total number of properties assigned to each member of staff at a given branch. (k) List the details…
University AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. Staffs’ InformationName NoIC Age Category Scheme……. …… …….. …… …..……. …… …….. …… …..……. …… …….. …… …..Report of selected SchemeCategory AcademicPENSION 56 : ....PENSION 60 : ....Report of selected SchemeCategory Non-AcademicPENSION 56 : ....PENSION 60 : .... (a) identify input, process and output for above program.(b) write a pseudocode or draw a flowchart for above program
Write the business rules that are reflected in the ERD shown in Figure P2.15. (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always read from the “1” to the “M” side, regardless of the orientation of the ERD components.) FIGURE P2.15 THE CROW’S FOOT ERD FOR PROBLEM 15
A college course may have one or more scheduled sections or may not have a scheduled section. Attributes of COURSE include Course ID, Course Name, and Units. Attributes of SECTION include Section Number and Semester ID. Semester ID is composed of two parts: Semester and Year. Section Number is an integer (such as 1 or 2) that distinguishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION?
Question 31 A survey on pollution has been conducted on four cities. The degree of pollution is classified as not polluted, moderately polluted, and heavily polluted. The results of the survey are illustrated in the table below: City city1 city2 city3 city4 Xi1: not polluted 0.3 0.2 0.1 0.7 X12: moderately polluted 0.4 0.2 0.2 0.4 Xi3: heavily polluted 0.3 0.6 0.5 0.1 Use the cosine amplitude method to develop the fuzzy relation R that relates the pollution degree to the city.
Draw the associations that are described by the following business rules. Include the multiplicities for each relationship. (4 marks) A patient must be assigned to only one doctor, and a doctor can have one or many patient: An employee has one phone extension, and a unique phone extension is assigned to an employee. A bookstore sells at least one book, and a book can be sold at up to 10 other bookstores around town.
Problem List with Expected Results Problem 1 For all departments, display department number and the sum of all salaries for each department. Name the derived column SUM_SALARY. Result WORKDEPT SUM_SALARY A00 B01 C01 D11 D21 E01 E11 E21 128500.00 41250.00 90470.00 222100.00 150920.00 40175.00 104990.00 95310.00