Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i want an ER diagram for this Consider a UNIVERSITY database that keeps track of student and their majors, transcripts, and registration as well as

i want an ER diagram for this

image text in transcribed

Consider a UNIVERSITY database that keeps track of student and their majors, transcripts, and registration as well as of the university's course offering. A desecration of the requirements for this database is as follows: For each person. the database maintains information on the verson's Name [Name], Social Security number [Ssn]. address [Address]. sex [Sex], and birth date [Bdatel. Two subclasses of the PERSON entity type are identified: FACULTY and STUDENT. Specific attributes of FACU LTY are rank [Rank] (assistant, associate, adiunct. research. visiting. and so on). office IFofficel. office phone IFphone 1. and salary [Salaryl. All faculty members are related to the academic department (s) with which they are affiliated [BELONGS] (a faculty member can be associated with several departments). A specific attribute of STUDENT is [Class ((freshman =1, sophomore =2,, graduate student =5 ). Each STUDENT is also related to his or her maior department (if known) [MAJOR]. to the course sections he or she is currently attending [REGISTERED] and to the courses completed [TRANSCRIPT]. Each TRANSCRIPT instance includes the grade the student received [Grade] in a section of a course. GRAD STUDENT is a subclass of STUDENT, with the defining predicate Class =5. For each graduate student, we keep a list of previous degrees in a composite, multi- valued attribute [Deqrees]. We also relate the graduate student to a faculty advisor [ADVISOR] and to a thesis committee [COMMITTEE], if one exists. An academic debartment has the attributes name [Dnamel. telephone [Dphone], and office number [Officel and is related to the faculty member who is its chairperson [CHAI RS1 and to the college to which it belongs [CD1. Each college has attributes college name [Cname], office number [Coffice], and the name of its dean [Dean]. A course has attributes course number [C\#], course name [Cname], and course description [Cdesc]. Several sections of each course are offered, with each section having the attributes section number [Sec\#] and the year and semesterin which the section was offered ([Year] and [Otr]) section numbers uniquely identify each section. The sections being offered during the current semester are in a subclass CURRENT_SECTION of SECTION, with the defining predicate Smt =Current and Year =Current year. Each section is related to the instructor who taught or is teaching it ([TEACH]), if that instructor is in the database. The category INSTRUCTOR RESEARCHER is a subset of the union of FACULTY and GRAD STUDENT and includes all faculty, as well as graduate students who are supported by teaching or research

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DB2 11 The Database For Big Data And Analytics

Authors: Cristian Molaro, Surekha Parekh, Terry Purcell, Julian Stuhler

1st Edition

1583473858, 978-1583473856

More Books

Students also viewed these Databases questions

Question

1. Outline the listening process and styles of listening

Answered: 1 week ago

Question

4. Explain key barriers to competent intercultural communication

Answered: 1 week ago