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

Related questions

Q: eed help Draw an ER diagram for the following scenario: A designer has a store of designer dresses…

A: ER diagram:

Q: For this assignment you are to find 3 real-world examples of identity theft, preferably medical id…

A: The objective of this question is to find three real-world examples of identity theft, understand…

Q: We need to know the criteria for determining if a model is prescriptive.

A: The correct answer for the above mentioned question is given in the following steps for your…

Q: In the next paragraph, we will talk about the characteristics and characteristics that descriptive…

A: Paragraph: A descriptive model explains how a system or other item interacts with its environment.…

Q: In the following paragraphs, I will go through the characteristics and qualities that descriptive…

A: Descriptive models are different in nature from predictive models because they may not perform as…

Q: How can you tell if a model meets the requirements for proportionality and additivity?

A: Introduction An presumption is that a simplifying condition is taken into account in the research…

Q: METHOD TO DO THE HOMEWORK PROBLEM: *Create the SDLC model of Shopee. *Choose 2 models below that…

A: There are many Software Development Life Cycle (SDLC) models and Based on the requirement the type…

Q: Every baby is the result of a unique birth, and every birth is of a unique baby. 2. In addition to…

A: Every entity and attribute share some kind of relationship between them. It can one on one…

Q: For the Iteration and Incrementation life-cycle model do the following:

A: The Iterative and Incremental life-cycle model is a developmental approach that combines iterative…

Q: In a hospital setting, a patient is assigned a patient id and we need to keep track of patient’s…

A: Required Schema Pateient (ID, name, gender, DOB, address) StaffMember(ID, title, gender, name,…

Q: e VIN, make, model, year, color, asking price, number of miles, number of collisions, tire age, and…

A: ERD for given database: No of entities : 1)SalesPerson entity : Attributes are { salespersonID ,name…

Q: Consider the process of doing a group assignment for a class a. List some inputs of the process.…

A: Here we have given a brief note on process of doing a group assignment for class . You can find…

Q: Consider the following data Classification Model where YACT is your actual observation and YPRED is…

Q: DATABASE : Please draw an EERD based on following description. Suppose that you are asked to…

A: Here is the answer:-

Q: In the next paragraph, we will talk about the characteristics and characteristics that descriptive…

Q: Use a simple example to explain the iterati

A: Dear Student, The answer to your question is given below -

Q: Here, we'll talk about the most crucial aspects of descriptive models.

A: Descriptive research is a kind of study that describes all characteristics of the studied population…

Q: In the given array having positive integers, print the odd and even numbers in two different lines…

A: Given array: int array[] = {1,14,72,23,88,61,4,7,12} Requirement: Print the odd and even numbers…

Q: In the following discussion, we will examine the fundamental characteristics of descriptive models?

A: Defining Descriptive ModelsIn the broad landscape of machine learning and data science, different…

Q: How can you recognize whether a model satisfies proportionality andadditivity?

A: An presumption is that a simplifying condition is taken into account in the research method such…

Q: We will go through many key characteristics and behaviors for descriptive models in more detail…

A: MODEL OF DESCRIPTION - A sort of research methodology known as descriptive research explains every…

Q: A person can be an employee, alumnus, or a student. For a person, P_id (identifier), date of birth,…

A: ERD for the given requirement: No of Entities: Person entity Employee Alumnus Student Staff Faculty…

Q: What is best way to represent specialization/generalization hierachy if the participation and…

A: The question is on finding the best way to represent specialization/generalization hierachy if the…

Q: What is best way to represent specialization/generalization hierachy if the participation and…

A: What is best way to represent specialization/generalization hierarchy if the participation and…

Q: Consider the following scenario Students have to use a range of lab equipment to complete their…

A: Consider the following scenario Students have to use a range of lab equipment to complete their…

Q: Hi There! I need help with this simulation model problem. I get how to do a basic coin toss using…

A: In this question, we have to create a simulation model problem related to a game show scenario with…

Q: Read the following scenario carefully, then create a UML State Machine Diagram for the body…

A: UML, or the Unified Modeling Language, is a standardized visual modeling language used for software…

Q: Consider the following scenario: you've been tasked with developing a logical model of a school or…

A: Introduction: Justification: A top-down or bottom-up approach is preferable to build a logical model…

Concept explainers

Intelligent Machines

Machines that use artificial intelligence to learn from the environment and past experiences to perform better in the presence of variability and uncertainty are called intelligent machines. Intelligence develops according to environment and experience. It is human-like behavior. When the computer system or any programmed machine learns from the inputs and corresponding outputs, it can be called an intelligent machine.

Question

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.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Step 1

Step 2: Step 2

Step 3: Step 3

Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

A partially completed version of the worksheet is shown below. To complete the spreadsheet, you need to understand the discount policy, which states that a discount is given if the total sale is equa to or greater than the discount threshold. Complete the worksheet in the figure, then create two additional scenarios for different selling strategies. In one scenario lower the discount threshold and discount percentage to $3000 and 12%, respectively. Increase these values in a second scenario to $10,000 and 20%. Save all three scenarios and submit the completed assignment. MIAMI, FLORIOA AMOUNTOF OisCoUNT DISCOUNTED TOTAL SALES TAX AMOUNT DUE PROGRAM CURRENT PRICE UNITS SOLD 1OTAL SALE CUSTOMER NAME AAA SOFTWARE SALES Norton Utities COMPUSOFT. INC 35 45 15 30 17 116.99 Microsoft Office 2010 $ 317.95 కం 55 59.99 KINGS BAY SOFTWARE Adobe Photoshop MICROSALES INC PC& Me software Personal Software Sales Quicken Deluxe Service Software Software and More Software to go Unique Software Sales…
Here, we'll talk about the most crucial aspects of descriptive models.
This is the ER model for the case where there exists the entity of Product, which has the attributes of costPrice, salePrice, Identifier, factoryCode, description. These Products are manufactured by a Factory that has the attributes of description, factoryCode, factoryAddress, and this Factory sells its products to the Distributor entity, which has the attributes of distributorCode, factoryCode, email, description, distributorName. Please do the next thing: The requirement has been expanded with the following information: 'Currently, an Excel sheet is used where we store the information of the products that customers have ordered through orders; information is stored about when an order has been delivered and who or which company has made the delivery of the order.' Expand the ER diagram seen in class to comply with the new requirements requested, and also indicate what type of cardinality each of the relationships between the entities has." Please do the IMAGE E-R Diagram Expanded
Construct a LCS table for Input1=’Student name’ and Input2=’Hometown’. Also find the Length of LCS and Actual LCS. Construct LCS for both scenarios given below. a)Take Input1—Vertical and Input2—Horizontal b) Take Input2—Vertical and Input1—Horizontal
We'll go through the key features and characteristics of descriptive models here.
We will cover the key aspects and properties of descriptive models.
In order to implement the expected system, the following information have been received from the managers of INSIGHTS: A company can request one or more quotations. A quotation is issued by a salesman. It concerns one or more stands. It may also be concerned by an invoice. A stand has a type. An invoice is issued by a salesman. Based on the salesman, a discount will be applied to this invoice. The company will pay one or more invoices. The company can make one or more reservations. Every reservation concerns one or more stands. The company can cancel a reservation. In this case, a penalty pay be applied. The salesman is controlled by one supervisor. The supervisor generates one or more reports. A report concerns the stands. It also concerns the companies. Question: Propose a UML class diagram for the process described above.
Create an Entity-Relationship Model to represent the data requirements of the problem given below. Specify the cardinalities of relationships and all-important constraints. Also mention the assumptions if you have made any. A person can be an employee,alumnus or a student.For person P_id(identifier), date of birth,gender and contacts are stored. Person can have more than one contact numbers and there are no other types of person that exists.An instance of person can belong to more than one type.Date hired and salary is the unique attributes of employee.For alumnus degree is required to be stored that comprises of year and designation. Major department is the attribute of student. A student can be a graduate student or an undergraduate student but not both at the same time.No other type of student exists.For graduate student test score is stored and for undergraduate student class standing is stored.Employee can be faculty, staff or others but not both at the same time. For faculty…
Here, we'll talk about the most crucial aspects of descriptive models.
We will go through many key characteristics and behaviors for descriptive models in more detail below.
In the following paragraphs, I will go through the characteristics and qualities that descriptive models often have.
Develop an entity-relationship model for the following scenario. A piano manufacturer wants to keep track of all the pianos it makes individually. Each piano has an identifying serial number and a manufacturing completion date. The manufacturer has piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by one or more technicians (identified by their employee number). For each separate inspection, the company needs to record its date and a quality evaluation grade.