
Concept explainers
Please draw an EERD based on following description.
Suppose that you are asked to model the human resources in a university. They consider three types of people: employees, student and alumnus. Employee has SSN, name, address, gender, date of birth, salary, and date of hire. And there is no other type of personnel in this university. Some employees are also alumnus. And also, some students are also employees. Students have SSN, name, address, gender, date of birth, and major department. Alumni have SSN, name, address, gender, date of birth, degree, and degree received date. Employees can be partitioned into two sub types: faculty and staff. Faculty has the specific attribute rank, while staff has the specific attribute position. An employee cannot be both faculty and staff at the same time. Two subtypes are also defined for students: graduate student and undergraduate student. Undergraduate student has the attribute class_standing, while graduate student has the attribute test_score. A student cannot be both graduate and undergraduate student. Every graduate student is assigned to a faculty and a faculty can have many graduate students.

Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 images

- A company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments; each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information about a child once the parent leaves the company. Draw an ER diagram that captures this information.arrow_forwardConsider the following database instance. Table name: Students Primary key: sid Sid sname 7 Ricky 2 Ellen 6 MaryLou 4 Ellen Table name: Courses Primary key: cid cid cname 1 ICS 2 Finance Table name: Register Primary key: sid,cid Foreign key: sid references Students(sid) Foreign key: cid references Courses(cid) sid cid 7 2 2 2 7 1 4 1 5.1) For each of the following statements, show whether the statement is correctly executed or not (assume that the statements are executed in order, which means that if a statement is correctly executed, its effect is reflected in the following statement). If you say the statement is not executed, explain why. INSERT INTO Students VALUES (3, ‘Ellen’); INSERT INTO Students VALUES (6, ‘Ellen’); INSERT INTO Register VALUES (1, 2); INSERT INTO Courses VALUES (5, ‘Systems’); INSERT INTO Register VALUES (6, 5); INSERT INTO Register…arrow_forwardThere are two alternative methods of representing an employee’s optional (single) phone number. The first is to use a nullable attribute and the second is to use a weak entity. 1. Given a requirement that a large number of the employees (> 80%) are assigned a phone number, which is the preferred method and why? 2. Given a requirement that only a small number of employees (< 10%) are assigned phone numbers, which is the preferred method and why? 3. How would the requirement of ‘multiple phone numbers can be assigned to an Employee’ affect your decision? Your answers should consider the performance tradeoff between number of database operations per query and record’s size.arrow_forward
- Consider the following database instance. Table name: Students Primary key: sid Sid sname 7 Ricky 2 Ellen 6 MaryLou 4 Ellen Table name: Courses Primary key: cid cid cname 1 ICS 2 Finance Table name: Register Primary key: sid,cid Foreign key: sid references Students(sid) Foreign key: cid references Courses(cid) sid cid 7 2 2 2 7 1 4 1 5.1) For each of the following statements, show whether the statement is correctly executed or not (assume that the statements are executed in order, which means that if a statement is correctly executed, its effect is reflected in the following statement). If you say the statement is not executed, explain why. INSERT INTO Students VALUES (3, ‘Ellen’); INSERT INTO Students VALUES (6, ‘Ellen’); INSERT INTO Register VALUES (1, 2); INSERT INTO Courses VALUES (5, ‘Systems’); INSERT INTO Register VALUES (6, 5); INSERT INTO Register…arrow_forwardHow do changes in data models typically propagate to the UI in a two-way data binding scenario?arrow_forwardQUESTION 7 Consider the following database schema for University Library database. A student can borrow many books and a given book can be borrowed by any student if it is available in the library. For each borrowing, the borrowing and return dates are registered in the database. Student (SID: long, CPR:long (unique), Name:string, tel:number, major:String, gender:Character {"F' or M'}) Book (ISBN:long, Title:string (unique), Author:string) Borrowedltems(stSID:long, booklSBN:long, serialNo.int (unique), BorrowingDate:date, RetumDate:date) Write SQL statements to: 1. List ISBN, Title, Author of all books that include the word 'Database' in their titles in a descending order of ISBN. 2. List SID, Name, and Major of all female students doing major in 'CS' and their name starts with 'S'.arrow_forward
- ABC Markets sell products to customers. The relational diagram shown in Figure P10.6 represents the main entities for ABC's database. Note the following important characteristics: A customer may make many purchases, each one represented by an invoice. The CUS_BALANCE is updated with each credit purchase or payment and represents the amount the customer owes. The CUS_BALANCE is increased (+) with every credit purchase and decreased (–) with every customer payment. The date of last purchase is updated with each new purchase made by the customer. The date of last payment is updated with each new payment made by the customer. An invoice represents a product purchase by a customer. An INVOICE can have many invoice LINEs, one for each product purchased. The INV_TOTAL represents the total cost of the invoice, including taxes. The INV_TERMS can be "30," "60," or "90" (representing the number of days of credit) or "CASH," "CHECK," or "CC." The invoice status can be "OPEN," "PAID," or "CANCEL."…arrow_forwardPlease! can you help me doing Conceptual Analysis for this scenario. I have attached another screenshot to followup with dataarrow_forwardWe would like to develop a database that captures the following requirements. A University student can enrol in a course and at least in one major. In fact, a student can enrol in many majors within that course. During the semesters, a student can enrol in units. We want to capture in which year and in which semester a student enrolled in each unit. We have two semesters: Semester 1 and Semester 2. A unit has a code, a title and the number of credit points. We would like also to record the student’s GPA. A course has a code and a name. A major has a code and a name. Also, a major belongs to a course. A unit can be part of either a course or a major. A unit can also be shared across different courses and different majors. Important to note: Provide your design in a textual form, i.e. Entity(Attribute1, Attribute2, Attribute3, …). Make sure that the primary keys of each entity are underlined (Attribute1 in the example above) and foreign keys are indictated in bold (Attribute3 in…arrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education





