Develop a conceptual ER diagram for the above database description, using appropriate syntaxes, and showing cardinalities and key attributes.
Consider the partial description for a UNIVERSITY database below:
A university is organized into colleges, and each college has a unique name, a main office and phone, and a particular faculty member who is dean of the college. Each college administers a number of academic departments. Each department has a unique name, a unique code number, a main office and phone, a certain number of students (each with a student id, name, and address), and a particular faculty member who chairs the department. We keep track of the start date when that faculty member began chairing the department. Faculties are employed by the academic department. Each faculty has a unique identifier, name, office, phone, rank, and employment starts date. We also record the faculty’s years of service, which is derived from the employment start date.
ER diagram of a university database::
rectangles are used to identify entity
diamonds are used to identify relationship
eclipses are used to identify attributes
double eclipses are used to identify multi value attributes
cardinalities are also mentioned there
primary keys are mentioned using eclipses with underline
Develop a conceptual ER diagram for the above database description, using appropriate syntaxes, and showing cardinalities...
2. A college needs a database that supports its placement office to help college students finding out potential employers. The primary purpose of the database is to schedule interviews and facilitate searches by students and companies. The requirements are the followings: • Student data include a unique identifier, a name, phone number, an email address, a web address, a major, a minor, and a GPA. • The placement office maintains a standard list of positions based on the Labor Department's...
You have been approached by a University for the design and implementation of a relational database system that will provide information on the courses it offers, the academic departments that run the courses, the academic staff and the enrolled students. The system will be used mainly by the students and the academic staff. The requirement collection and analysis phase of the database design process provided the following data requirements for the University Database system. Using the following requirements answer this...
DATABASE SYSTEMS Project INDIVIDUAL WORK DELIVERABLE #: SUBMISSION DATE No Group Work Allowed April 8 Introduction to Coursework You have been approached by a University for the design and implementation of a relational database system that will provide information on the courses it offers, the academic departments that run the courses, the academic staff and the enrolled students. The system will be used mainly by the students and the academic staff. The requirement collection and analysis phase of the database...
Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. The university keeps track of each student's name, student number, social security number current address and phone, permanent address and phone, birth date, sex, class (freshman, sophomore,., graduate), major department, minor department (if any), and degree program (B.A., B.S.,..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...
Please build an Entity Relationship Diagram using the following information: Build a database for a regional university in Western New York called Ithica South University. The university database administrator needs to keep track of the students that attend the university, the courses offered by the university, and the university employees. Ithica tracks the first and last name of each student, as well as their target degree. The university keeps track separately of two subclasses of students, as students are either...
The following are the main entity types of the academic institution database. For each entity type, we provide some of the corresponding attributes. Use this information in order to: (a) Build an Enhanced E-R diagram; (b) Transform the Enhanced E-R diagram to a relational database. Identify the primary key(s) and the foreign key(s) for each relation. Draw the relational integrality constraints; (c) For each of the relations created, indicate its normal form. If the relation is not in the 3NF,...
Programming Assignment This is a database course using Open Office Database. Assume that you have been given the task of creating a system for a library to keep track of their books, the borrowers of the books, and the books that are currently lent out. Your first step will be to create the relations necessary for this system. Book will need information such as a unique identifier for each book, title, author, ISBN number, date of publication, cost. Borrower will...
Database Analysis and Design (ER diagram) After the requirement collection and analysis phase the software project of a database application about a company is described as follows: 1. The company is organized into departments. Each department has a name, an unique number, and a particular employee who manages the department. We keep track of the start date when the employee began managing the dept. A dept may have several locations. 2. A dept controls several projects, each of which has...
Problem 1 Consider the following set of requirements for a university database that is used to keep track of students' transcripts. (a) The university keeps track of each student's name, student number, social security number, current address and phone, permanent address and phone, birthdate, sex, class (freshman, sophomore, -, graduate), major department, minor department (if any), and degree program (B.A., B.S., ...., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...
Consider the following set of requirements for a university database that is used to keep track of students' transcripts The university keeps track of each student's name, student number, social security number, address and phone, birthdate, gender, `, and degree program (bachelor, Masters, PhD.). Both social security number and student number have unique values for each student. Each department is described by a name, department code, office number, office phone. Both name and code have unique values for each department....