Find the entities and their attributes
The
A person can belong to one, two, or all three of these types. Each person has a name,
SSN, sex, address, and birth date.
Every employee has a salary, and there are three types of employees: faculty, staff,
and student assistants. Each employee belongs to exactly one of these types. For each
alumnus, a record of the degree or degrees that he or she earned at the university is
kept, including the name of the degree, the year granted, and the major department.
Each student has a major department.
Each faculty has a rank, whereas each staff member has a staff position. Student
assistants are classified further as either research assistants or teaching assistants, and
the percent of time that they work is recorded in the database. Research assistants
have their research project stored, whereas teaching assistants have the current course
they work on.
Students are further classified as either graduate or undergraduate, with the specific
attributes' degree program (M.S., Ph.D., M.B.A., and so on) for graduate students and
class (freshman, sophomore, and so on) for under graduates.
For previous scenario do the following:
Find the entities and their attributes
Find relationships b/w entitiesDraw ERDThe database keeps track of three types of persons: employees, alumni, and students.
A person can belong to one, two, or all three of these types. Each person has a name,
SSN, sex, address, and birth date.
Every employee has a salary, and there are three types of employees: faculty, staff,
and student assistants. Each employee belongs to exactly one of these types. For each
alumnus, a record of the degree or degrees that he or she earned at the university is
kept, including the name of the degree, the year granted, and the major department.
Each student has a major department.
Each faculty has a rank, whereas each staff member has a staff position. Student
assistants are classified further as either research assistants or teaching assistants, and
the percent of time that they work is recorded in the database. Research assistants
have their research project stored, whereas teaching assistants have the current course
they work on.
Students are further classified as either graduate or undergraduate, with the specific
attributes' degree program (M.S., Ph.D., M.B.A., and so on) for graduate students and
class (freshman, sophomore, and so on) for under graduates.
For previous scenario do the following:
Find the entities and their attributes
Find relationships b/w entities
Draw ERD
Trending now
This is a popular solution!
Step by step
Solved in 2 steps