Question 2: ( DATABASE APPLICATION DEVELOPMENT) Figure 2 shows an ERD produced by Encik Sulaiman to store course registration by students, course taught by lecturers, as well as students under academic advisors. matric name code title credit program status STUDENT COURSE register session group semester grade LECTURER advise staffld name roomNum Figure 2: University database ERD a) Using a different notation (eg. crow foot, UML), redraw the given ERD. b) Transform the ERD into relational model form. c) Encik Sulaiman realized that he can actually improve the database design by removing the relationship of the lecturer from the 'register'. In fact, he can create a new relationship 'teach' between the lecturer and course and assign appropriate attributes. Draw the new ERD. d) Transform the new ERD into relational model form. e) Compare the mapping outcome b) and d). Do you agree with Encik Sulaiman'sopinion? Give your arguments to support your opinion.

Question 2: ( DATABASE APPLICATION DEVELOPMENT) Figure 2 shows an ERD produced by Encik Sulaiman to store course registration by students, course taught by lecturers, as well as students under academic advisors. matric name code title credit program status STUDENT COURSE register session group semester grade LECTURER advise staffld name roomNum Figure 2: University database ERD a) Using a different notation (eg. crow foot, UML), redraw the given ERD. b) Transform the ERD into relational model form. c) Encik Sulaiman realized that he can actually improve the database design by removing the relationship of the lecturer from the 'register'. In fact, he can create a new relationship 'teach' between the lecturer and course and assign appropriate attributes. Draw the new ERD. d) Transform the new ERD into relational model form. e) Compare the mapping outcome b) and d). Do you agree with Encik Sulaiman'sopinion? Give your arguments to support your opinion.

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

Subject: Database Topic: EERD -Based on the information given below, draw the conceptual EERD where you should include the enhanced features. [Using UML Design] A car dealership wishes to maintain data about the customers who purchase acar. Each customer may purchase one or more vehicles and each vehicle can bepurchased by many different customers over time (for example, a customer maypurchase a new vehicle, trade that vehicle in and someone else can purchasethe vehicle traded in.) Data that the dealership wishes to keep regardingcustomers includes customer identification number, name, address, homephone, work phone, cell phone and e-mail address. Information about vehicle includes vehicle identification number, make, model,year, transmission type, engine size and color. Vehicles can be a member of oneof the following categories: cars, trucks, minivans or SUVS. A vehicle can be amember of only one category at a given time. Trucks, minivans and SUVS haveunique attributes — cars does…
Q3) consider you have the Library database with the following relations, where the primary keys are underlined: Book (bookID, name, auther, No.-of-pages, section-name, category) Section(section-name, section-admin, no-of-books, library-code) Library(library-name, address, no-of-sections, manager-name, library-code, country)
E-R diagrams or DBDL may show database structure. Why do you prefer this method?
Need with explanation
Database course: a. List the details of all the employees who are from the department number 2. b. List the details of all the employees who joined the company after 01-JAN-11. c. List employeeNO and DepartmentNO of all the employees who work as ‘Engineer’ and earn more than 1800 Omani Rials. (I need the codes to copy it)
Problem: design a er diagram for a database to keep track of building inspections required by a department of Damaged Buildings (DB). DB building inspections are requested by builders every month. Each building inspection is either passed or not. Inspections have a type code (3 characters, e.g. PLU, FRM, ELE, etc.) and possibly sequencing requirements. Some inspections cannot be performed before other inspections, e.g. final plumbing inspection cannot be performed until the framing inspection is passed. Each inspection has a numeric score, with 75 or more out of 100 being sufficient for a pass status. Each inspection data contains the date of inspection, inspector identification, inspection score, and textual information about the inspection. The textual information can be updated later, but the score can never be changed. FODB maintains a pool of inspectors. Each inspector has a unique 5 digit employee ID, name, and date they were hired. They can conduct any type of inspection but…
Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…
CRISS CROSS PUZZLE This is a crisscross puzzle about Fundamentals of Database System I will write the number of characters needed Thank You ACROSS 4. the logical structure of the entire database (13 characters) 6. simply the way the data is stored on disk (14 characters) 7. Contain data stored in the database (16 characters) 9. A schema is an overall description of a database, and it is usually represented by the ___________. (3 characters) DOWN 1. Are closer to the physical level or file structure (14 characters) 2. high-level and abstract design phase (13 characters) 3. Are closely related to the real world as perceived by each user (14 characters) 5. deals with hiding the details of the storage structure from user applications (24 characters) 8. first step in the process of database design (16 characters)
Create a Crow’s Foot notation ERD to support the following business operations: A friend of yours has opened Professional Electronics and Repairs (PEAR) to repair smartphones, laptops, tablets, and MP3 players. She wants you to create a database to help her run her business.   When a customer brings a device to PEAR for repair, data must be recorded about the customer, the device, and the repair. The customer’s name, address, and a contact phone number must be recorded (if the customer has used the shop before, the information already in the system for the customer is verified as being current). For the device to be repaired, the type of device, model, and serial number are recorded (or verified if the device is already in the system). Only customers who have brought devices into PEAR for repair will be included in this system.   Since a customer might sell an older device to someone else who then brings the device to PEAR for repair, it is possible for a device to be brought in for…
Relation algebra (Database)
pls help me : Draw an ER diagram according to the following requirements:Database to manage daily medical examination and treatment in the hospital (not interested in treating inpatients):- The hospital has many doctors and nurses from different departments. Each doctor and nurse belongs to only one department- The patient when he comes to the doctor will be created a patient record if it is the first visit- Each visit will be made a medical record and assigned an initial clinic. Each visit is attended by a doctor and an assistant nurse.- The doctor may ask the patient to perform tests, x-rays, endoscopy, ....- After the results are available, the patient returns to the original clinic for the doctor to read the results and prescribe medicine if any- Patients can buy medicine in the hospital pharmacy or buy it outside