Consider the following set of requirements for a university database that is used to keep track ofstudents' of student enrollments in classes and students' final grades:a. The university is organized into colleges (COLLEGE), and each college has a uniquename (CName), a main office (COffice) and phone (CPhone), andparticular facultymember who is dean of the college. Each college administers a number of academicdepartments (DEPT). Each department has a unique name (RName), a unique codenumber (RCode), a main office (ROffice) and phone (RPhone), and a particular facultymember who chairs the department. We keep track of the start date (CStartDate) whenthat faculty member began chairing the department.b. A department offers a number of courses (COURSE), each of which has a unique coursename (COName), a unique code number (CCode), a course level (Level: this can be codedas 1 for freshman level, 2 for sophomore, 3 for junior, 4 for senior, 5 for MS level, and 6for PhD level), a course credit hours (Credits), and a course description (CDesc). Thedatabase also keeps track of instructors (INSTRUCTOR); and each instructor has aunique identifier (Id), name (IName), office (IQffice), phone (IPhone), and rank (Rank);in addition, each instructor works for one primary academic departmentc. The database will keep student data (STUDENT) and stores each student's name(SName, composed of first name (FName), middle name (MName), last name (LName)),student id (Sid, unique for every student), address (Addr), phone (Phone), major code(Major), and date of birth (ReB). A student is assigned to one primary academicdepartment. It is required to keep track of the student's grades in each section the studenthas completed.d. Courses are offered as sections (SECTION). Each section is related to a single course anda single instructor and has a unique section identifier (Secld). A section also has a sectionnumber (ŞecNo; this is coded as 1, 2, 3, ... for multiple sections offered during the samesemester/year), semester (Sem), year (Year), classroom (CReom: this is coded as acombination of building code (Bldg) and room number (RoomNe) within the building), and days/times (DaysTime: for example, 'MWF 9am-9.50am' or TR 3.30pm-5.20pm'-restricted to only allowed days/time values). (Note: The database will keep track of allthe sections offered for the past several years, in addition to the current offerings. TheSecld is unique for all sections, not just the sections for a particular semester.) Thedatabase keeps track of the students in each section, and the grade is recorded whenavailable (this is a many-to-many relationship between students and sections). A sectionmust have at least five students.Draw an ER diagram for this application. Specify key attributes of each entity type and structuralconstraints on each relationship type. Note any unspecified requirements, and make appropriateassumptions to make the specification complete.

Definition of ER Diagram : Entity Relationship Diagram or ER Diagram describes interrelated things…

and days/times (QaysTime; for example, 'MWF 9am-9.50am' or TR 3.30pm-5.20pm'- restricted to only allowed days/time values). (Note: The database will keep track of all the sections offered for the past several years, in addition to the current offerings. The Secld is unique for all sections, not just the sections for a particular semester.) The database keeps track of the students in each section, and the grade is recorded when available (this is a many-to-many relationship between students and sections). A section must have at least five students. Draw an ER diagram for this application. Specify key attributes of each entity type and structural constraints on each relationship type. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.

and days/times (QaysTime; for example, 'MWF 9am-9.50am' or TR 3.30pm-5.20pm'- restricted to only allowed days/time values). (Note: The database will keep track of all the sections offered for the past several years, in addition to the current offerings. The Secld is unique for all sections, not just the sections for a particular semester.) The database keeps track of the students in each section, and the grade is recorded when available (this is a many-to-many relationship between students and sections). A section must have at least five students. Draw an ER diagram for this application. Specify key attributes of each entity type and structural constraints on each relationship type. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.

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

Useing SQLS Scenario You are working in “ABC” company as Database administrator. a new user “Udev” is joined to the company as developer. “Udev” need to create tables and procedures to be used on the database. Task 1: Required: Create “Udev” user. You need to be sure that “Udev” can connect by using Oracle Sql Developer tool. You need to be sure that “Udev” can create tables and procedures. You need to be sure that “Udev” can’t delete any created table
From the database scheme write the query(all tables are empty) 1) Insert your name and your phone as a new tenant 2) Delete your phone number from the table tenant. 3) Create a new contract lease for you. 4) Delete the contract that you created. 5) List the city name, city population and country name. 6) List the cities that have the letters “re” in any part of the name; 7) List the tenant name contract number, rent price, when the contract rent price is bigger equal 500 and lower equal 1000. 8) List all columns from apartments with the services offered (all columns from service). 9) List the building address, the city name and the country name for the building in Canada. 10) List the name of the user with the city name and country name, ordering by name of user.
based of the image, write a sql statement that shows the total number of patients handle by each nurse. sort the result based on the nurse's ID and display the nurse's name too
Add the provided information to a new record in the REP table. SELECT * FROM REP Expected Results REP_ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL CELL_PHONE COMMISSION RATE 35 Fred Kiser 427 Billings Dr. Cody WY 82414 307-555-6309 0.00 0.05
Create formulas that provide this information as follows: In cell H8, create a formula using the DCOUNT function to count the number of projects with funding amounts less than $5,000, using the Lookup table (range A1:E23) as the database, "Funding" as the field, and the range G6:G7 as the criteria. In cell H13, create a formula using the DAVERAGE function to average the funding amounts for Commercial projects, using the Lookup table (range A1:E23) as the database, "Funding" as the field, and the range G11:G12 as the criteria.
Salesforce Development Design a salesforce query to fetch the RSS. Try to include all the requried fields that we are required while creating the RSS. In general query calling I am not able to call the RSS, So please suggest a way to call it on salesforce inspecter SOQL Query | Development
Create a procedure to allow company employee to add new product to the database. This procedure needs only IN parameters.
Normalise the data below to third normal form (3NF).
Task 6: The Car Maintenance team considered that the available maintenance tasks should also have the price information in the database. Alter the MAINTENANCE_TYPES table to include a new column named MAINTENANCE_PRICE of type FLOAT. ANSWER IN MYSQL PLEASE
Salesforce Development Design a salesforce query to fetch the RSS. Try to include all the requried fields that we are required while creating the RSS. In general query calling I am not able to call the RSS, So please suggest a way to call it on salesforce inspecter SOQL Query | Development
In the Testa EV database described in the previous question, fill in the blanks in the following MySQL statement to list (in this order) all the part numbers of components of 'EV Dashboard' (with Part_No=1) and their quantities; sort the results in ascending order of quantity of components (i.e., components with small quantities are listed first). (Please ensure correctness in the spelling of all names and commands. Do not enter unnecessary symbols such as spaces or commas)
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.