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.

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.

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

Consider the case of a shop that sells CDs in cash. The CDs are of three types: Movie CDs, Software CDs and Music CDs. For each of the following CD types, the required attributes are:Movie CD: Movie Title, Year of Release, Lead Actor Name, CD price and CD quantitySoftware CD: Software Name, Edition, Year of Release, CD price and CD quantityMusic CD: Album Title, Year of Release, Number of Songs, Format, CD price and CD quantity. The variable of CDType can hold a fixed set of values that are Movie, Software and Music, what data type you recommend is suitable to store this information to ensure typesafety firmly. Declare and initialize the CDType variable.
It is requested to draw an entity relationship diagram (ERD) for a hospital management system. Information about the subject are given below. • The patients contain ID, name, and surname. Doctors have name, surname, and department. Rooms have number and capacity. • Each doctor may supervise zero or more patients. • Each patient should be supervised by one doctor. • Each room may host zero or more patients. Each patient should be hosted in one room.
1. DRAW ER diagram for the Scenario given below: In a country each CITIZEN is identified by CitizenCode. Other attributes of Citizen are: CitizenName and Contacts (person may have more than one contact). Officially, government allocate identification cards to avail services. IDENTYCARD has attributes: CardID (key) and Issue Date. Attributes of SERVICE are: ServiceCode (unique), ServiceTitle and ServiceDetail that consists of Type and Price. A Citizen may possess maximum one identity card or may not possess at all. The identity card belongs to only one citizen. A citizen may register for many services or may not register for any service. Each service may be registered by many citizens or may not be registered at all. During registration for the service RegistrationDate and Duration must be also be stored. 2. Draw EER Diagram for the scenario described below: A grocery shop stores data about its customers. Each CUSTOMER has attributes: Customerld (identifier), CustName and ContactNo. All…
Consider the pros and cons of doing static analysis in-house.
Computer science.
In a restaurant, customers usually may buy any number of meals at any time Several customers can also buy any specific meal. If we want to draw an ERD between 'Customer" and Meal," what will be the relationship, and why?
Consider an E/R diagram which has information about students, courses, and enrollments, where Students = (Sid, Sname, address, SIN, Program) and Courses = (Cid, Cname, Credits) are the entity sets and Enrollments is a many-to-many re- lationship between them with grade as its own attribute. Give an equivalent E/R diagram (i.e., preserves the information content) in which enrollment is modeled as a weak entity set.
Consider the following three simple rules to represent fuzzy relationship between food quality and service in a restaurant as input variables and tip amount as output variables. 1) If the food is bad OR the service is poor, then the tip will be low 2) If the service is acceptable, then the tip will be medium 3) If the food is great OR the service is amazing, then the tip will be high. Given the membership functions illustrated in Figure 1 and 2 as follows. Using the clipped center of gravity method, compute the tip amount based on the following circumstances: 1) Food quality was 6.0, and 2) Service was 8.0
Q1 Draw the F-R diagram , a collaboration class diagram and petri-net for the following requirements in a college library: there are two types of books: regular and reserved, and two types of users: students and faculty members. A student can check out a regular book for 1 month, while a faculty member can borrow one for 2 months. A late return for all users will incur a fine measured by the number of days, same for students and faculty. A reserved book can be checked out by any user for 4 hours. The fine for the later return is charged by number of hours. Any user who returned any books later than the deadline for more than twice will be levied an extra amount of money. A regular book checked out for more than 100 times will be put on sale. A reserved book checked out for more than 20 times will be put back as a regular book.