4. In a company, employees involved in many projects, and each project may have many employees working on it. The number of hours each employee works in each project, and the start date on which the employee starts working on the project are capture in the following relational table. EmployeeProject (EmpeNum, ProjNum, HoursWork, DateStartWorkOnProj)

4. In a company, employees involved in many projects, and each project may have many employees working on it. The number of hours each employee works in each project, and the start date on which the employee starts working on the project are capture in the following relational table. EmployeeProject (EmpeNum, ProjNum, HoursWork, DateStartWorkOnProj)

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

Q2: Design Database for the following scenario and Write SQL queries. Create an ERD for the following scenario. Suppose there is a grocery store near your house. Following can be considered for ERD: A grocery store may have more than one employee. A grocery store has exactly one manager. The manager has one or more sales men working under him. Grocery store has more than one portion for the products. • Each product has a barcode, name, expired date. Many customers can busy many products, but each product is bought by only one customer. Each customer will get an invoice for his /her purchase. The bill invoice has an id.
Consider the following ERD; consider additional attributes if needed Write relational algebra expressions on following: 1) Find the test details that has performed on patient 'Arisha' 2) Find the total test amount of patient 'Nishant'. a) Find the doctors details with dss='d01' with list of his patients insurance date-admitted name date-checked-out ss# patients test-log Dr-Patient test_id performed by doctors test dss# specialization name test_name date time result
The aim of assignment 1 is to implement a database schema and execute different types of SQL queries in Oracle SQL developer. Given the following relational schema: Student (studid, FirstName, LastName, Email, phoneNumber, DateofBirth, GPA) Club (clubid, ClubName, #studid) MemberOf (#clubid, #studid, joiningDate ) Activities (actid, actdt, place, durationNbHour) Organize (#actid , #clubid , fee) 1. Write SQL queries to create the following tables according to the below descriptions. Table name: Student studid |Char(9) Primary key FirstName Varchar2(50) NOT NULL LastName Varchar2(50) NOT NULL Email Varchar2(50) NOT NULL, UNIQUE phoneNumber Number(8) NOT NULL, UNIQUE DateofBirth Date NOT NULL GPA Number(1,2) NOT NULL Table name: Club clubID Number(3) Primary key ClubName Varchar2(20)NOT NULL NULL, UNIQUE, NOT Foreign key studid Char(9) Table Name: MemberOf ClubID Number(3) Primary Key, Foreign Key Studid Char(9) Primary Key, Foreign Key joiningDate Date Table Name: Activities Actid…
Write a relational mode for each of the case below. You can create our own attributes and provide common attributes to determine the link between tables. Using the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic, using at least the following business rules: a. A patient can make many appointments with one or more doctors I the clinic, and a doctor can accept appointments with many patients. However, each appointment is made only with one doctor and one patient. b. If kept, an appointment yields a visit with the doctor specified in the appointment. c. With each visit, the patient’s records are updated to provide a medical history. d. Each patient visit creates a bill. Each patient visit is billed by one doctor and each doctor can bill many patients. e. Each bill must be paid. The payment maybe paid on different payment mode.
You will need to create the database tables and choose sensible data types for each column.Make sure to maintain entity and referential integrity, and implement all the above constraints.Since other developers work in parallel on other parts of the system, you will need to strictly follow the above specification to correctly implemented in your database. Otherwise, the other software will not be able to use your database. This means, one needs to be able to rely on all constraints being correct, the spelling of table and column names being as given, and that the data types that you chose will allow for sensible data to be added to the database in the future.For testing purposes, you are asked to insert the data specified below into the tables, but no other data except this.In short:1. You will need to create the tables as specified2. You will need to add the data specified Please use the 3.sql and implement your tables using the sketched CREATE TABLE commands. Add the necessary queries…
Consider the following Table for the entity ENROLL: CLASS_CODE CLASS_NAME STU_NUM STU_NAME ATTENDANCE ENROLL_GRADE 10014 INFO3233-01 321452 Jan Jones 30/35 Classes C 10014 INFO3233-01 324257 Tom Poole 25/35 Classes B 10018 INFO3234-01 321452 Jan Jones 35/35 Classes A 10018 INFO3234-01 324257 Tom Poole 30/35 Classes B 10021 INFO3236-01 321452 Jan Jones 35/35 Classes C 10021 INFO3236-01 324257 Tom Poole 20/35 Classes C Is [CLASS_CODE, CLASS_NAME, STU_NUM, STU_NAME] a Superkey? Why? Is [CLASS_CODE, CLASS_NAME, STU_NUM] a Superkey? Why? Is [CLASS_CODE, CLASS_NAME, STU_NUM] a Candidate Key? Why? Is [CLASS_CODE, STU_NUM] a Candidate Key? Why? Please label your answers (for #1, 2, 3, or 4) clearly.
Look up the average evaluation score earned by instructor Egan for the Emergency Care course: In cell E14, begin to enter a formula using the XLOOKUP Use the instructor name in cell E12 as the value to look up. Use a structured reference to the header row of the Evaluations table as the table to search. Return the value in the range E4:I4. I need help with the sttructured reference refered in #3
A course instructor will assign grades from (A, B+, B, C+, C, D+, D, EJ. What is the minimum number of grades that must be assigned in order to guarantee at least one of the grades has been assigned 10 times.
Specification Functional Dependency 1. Consider the relational schemas given below and the respective sets of functional dependencies valid in the schemas. For each one of the relational schemas identify its highest normal form. Remember that the identification of a normal form requires analysis of the valid functional dependencies and the minimal keys. Provide justification of each answer. A solution with no comprehensive justification scores no marks. i. R1(A, B, С, D, E, F, G, H) F%3D {CH — G,A — ВС, Е — А,F — EG} ii. R2 = (S,C,L, D) F = {(L,D) → S, (L, D) → C,L → D} R3(A,B,C,D,E) F = {ABC → D, D → A}
Q9: You are asked to normalize the following Table into 3rd Normal Form. position salary Hours Worked Staff name No $1500 Tom Daneils Supervisor S0003 Sally Adams Manager S0010 Mary Martin Analyst $1500 Tom Daneils $2250 Robert Chin S0415 Sally Stern S3250 Art Peter S0010 Mary Martin S0415 Sally Stern a. b. C. d. e. Which of the following relations will NOT be part of the solution in the 3nd Normal Form? position Toy staffNo Alien Alien Alien Car Car branch No branch No staffNo Products Table 3500 20 Supervisor 4500 24 Manager 5000 11 Engineer 3000 14 4500 30 Supervisor Analyst 3500 23 Engineer 3000 21 Engine Engine 4500 12 5000 10 Part salary ন HoursWorked branchAddress name branchTelNo Branch Branch No Address B001 B001 B001 B004 8Th road, London, UK 8th road, London, UK 8th road, London, UK 5th road, Leeds, UK Central London, UK Central London, UK Avenue, Manch, UK 5th road, Leeds, UK B002 B002 B003 B004 B003 Avenue, Manch, UK Q10: Based on the following TWO Tables (Products and…
Write relation algebra for following:Student( Enrno, name, courseId, emailId, cellno)Course(courseId, course_nm, duration)i) Add a column city in student table.ii) Find out list of students who have enrolled in “computer” course.iii) List name of all courses with their duration.iv) List name of all students start with “a”.v) List email Id and cell no of all mechanical engineering students.
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?