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

In this exercise, we are interested in the management of horse race events. A race could be local or international. It is held in a given location and organized by one or more organizers. An organizer could be of two types: event organizer or local organizer. For every race there will be exactly 3 trophies. Several horses participate in a given race. A horse has a type. It is trained by one and only one trainer. It is also ridden by one and only one racer. For every race, there will be a result assigned to every horse. A racer may have received several trophies. For every trophy received, the date of awarding is stored. Racers are organized into teams. A team may include several racers. One of these racers is appointed as leader. Every team of racers has a chief trainer. The chief trainer has the role of supervisor (i.e. supervises the other trainers of the racers). Question: Propose a UML class diagram for the management of horse race events. Add the cardinalities, the attributes,…
Consider the following scenario: A teacher interviews a student, and during the interview the teacher always grades the student. This scenario can be modeled with two use cases -- "Conduct Interview" and "Grade Student". What is the relationship between these two use cases? a) Conduct Interview extends Grade Student b) Grade Student extends Conduct Interview c) Conduct Interview includes Grade Student d) Grade Student includes Conduct Interview
Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the sam.e situa- tion using the tool you have been told to use in the course. #3 A hospital has a large number of registered physi- cians. Attributes of PHYSICIAN include Physician ID (the identifier) and Specialty. Patients are admitted to the hospital by physicians. Attributes of PATIENT include Patient ID (the identifier) and Patient Name. Any patient who is admitted must have exactly one admitting physician. A physician may optionally admit any number of patients. Once admitted, a given patient must be treated by at least one physician. A particular physician may treat any number of patients or may not treat any patients. Whenever a patient is treated by a physician, the hospital wishes to record the details of the treatment (Treatment Detail). Components of Treat- ment Detail include Date, Time, and Results. Did you draw more…
Consider the following scenario A student has a name, which consists of a given name and a family name, and a student IID. Each student is uniquely identified by his/her student ID.A course has a subject and a course ID. For each course, we want to record the number of students taking that course and the type of equipment being used for the course. A course is uniquely identified by its course ID.A student can be enrolled in an arbitrary number of courses, and an arbitrary number of students can be enrolled in a course. For each course in which they are enrolled students receive a lab mark and an exam mark.A course cannot exist if there is no student enrolled in it.A school is distinguished by the honour's degree that it awards. We also want to record to which faculty a school belongs. A student is registered with at most one school, while a school can have an arbitrary number of students. Questions a) Draw an Entity Relationship Diagram b) translate the ERD into a relational data…
. Draw the ERD for the following scenario. In a university, a Lecturer can teach many different courses and even the same course numerous times. Courses can also be taught by many lecturers. A student is enrolled in only one program but a program can contain many students. Students can be rolled in many courses at the same time and the courses have many students enrolled.
In a hospital there are two kinds of Wards named General and pediatric. All patients belong to any of them. The hospital also has a pharmacy in each ward. Identify the main objects in the above given description. Also identify the relationships that exists among them.
For this assignment you are to find 3 real-world examples of identity theft, preferably medical id theft, but any type will be accepted. One of the examples should be your own if you were an id theft victim (I personally have been a financial id theft victim twice) or someone you know. This will allow you to know the details of how the theft occurred and how it was handled. One of the examples must come from research news stories and other resources found on the Web. Provide a link to each website in your report.. The final example may be personal or a news story. For each case, identify the type of ID theft that occurred, and answer these questions: what did the thief do (if known) to acquire the information, how was it discovered, what were the damages incurred, how long did it take to resolve the problems caused by the id theft?.
Depending on the cause of death, racial/ethnic and gender disparities exist on years of potential life lost in the United States. Years of Potential Life Lost (YPLL) can be defined as the number of years lost when death occurs before one’s life expectancy. For this assignment, life expectancy will be set for everyone at 75. For YPLL, a death of a very young person is weighted more than a death of a very old person (McKenzie, Pinger, & Seabert, 2018). AS Instructions: Investigate one cause of death (infant mortality, homicide, suicide, unintentional injuries (such as car accidents, drowning, falling, etc.), pregnancy complications, COVID-19, etc.) in the United States and research the YPLL for racial/ethnic groups and genders. Summarize your findings in your paper and discuss how calculating YPLL can change the way we think about that particular cause of death differently.
Depending on the cause of death, racial/ethnic and gender disparities exist on years of potential life lost in the United States. Years of Potential Life Lost (YPLL) can be defined as the number of years lost when death occurs before one’s life expectancy. For this assignment, life expectancy will be set for everyone at 75. For YPLL, a death of a very young person is weighted more than a death of a very old person (Seabert, McKenzie, & Pinger, 2022). AS Instructions: Investigate one cause of death (infant mortality, homicide, suicide, unintentional injuries (such as car accidents, drowning, falling, etc.), pregnancy complications, COVID-19, etc.) in the United States and research the YPLL for racial/ethnic groups and genders. Summarize your findings in your paper and discuss how calculating YPLL can change the way we think about that particular cause of death differently. Provide factual documentation that reinforces your findings from at least three peer reviewed sources…
Draw an ER model based on following scenario.A travel agency has different bus stations at different location. Each station has a unique name, locationand buses. Each bus has a unique bus number, color and type. The bus takes routes between stations.Each route has a name, arrival time and departure time. A single bus can take routes to different stations.Some buses may not take any route in some days however a station must have a route each day. Eachbus contains seats. Each seat has unique number, row and seat type. There are three different types ofseats as first class, standard and economy. Passengers can make reservations. Passenger has id number,full name, age, gender and address. Each reservation will have a unique reservation number, fare, dateand time. Each reservation can have any numbers of seats. The reservation is dependent on passenger.
Draw an ERD for the following situation (Batra et al., 1988). Also, develop the list of words for qualifiers and classes that you use to form attribute names. Explain why
Answer the given question with a proper explanation and step-by-step solution. Now that you have written functions for different steps of the model building process you will put it all together. You will write code that trains a model with hyperparameters you determine (you should do any tuning locally or in a notebook ie don't tune your model in gradescope since the autograder will likely timeout). It will take in the CLAMP training data, train a model then predict on a test set and output values from 0 to 1 for each row and our autograder will compare your predictions with the correct answers and to get credit you will need a roc auc score of .9 or higher on the test set (should not require much hyperparameter tuning for this dataset). This is basically a simulation of how your model would perform in the “production” system using batch inference. Deliverables: Make use of any of the techniques we covered in this project to train a model and return predicted probabilities for each row…