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 Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter9: Database Design

Section: Chapter Questions

Problem 5P

See similar textbooks

Similar questions

Consider the following business rule:An employee can manage multiple customers. A customer can be managed by multiple employees. How does this business rule(s) affect the database design? a.) The business rules define that there isn't a need for a relationship between the EMPLOYEE and CUSTOMER entities, as the relationship isn't a strong one. b.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:M relationship between those two entities. c.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and an M:N relationship between those two entities requiring a bridge table. d.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:1 relationship between those two entities.
1) Discuss the advantage of commit statement over rollback statement. 2) Database approach was introduced to overcome problems of File Based System. List out problems in File Based System. DATABASE SYSTEM
‘Problem 2: Data Modeling The recrultment agency TEMPO proposes intemship. employees for enterprises for a period of time. An internship employee is a temporary employee that will be recruited for a period of time. You must develop a database application in order to salisfy these: specifications: - The enterprises (id, name, address and phone number) define the posts for which they nead one or many employees. A post is defined with a label, a daily remuneration, the start date, the end cate and the number of employees for this post. A post needs eventually diploma(s) and a list of many skills. - Anintemship employee s described by a ssn, first name, last name, an address, a phone number, histher diplomas (we store for each diploma the year when it is obtained) and his/her skills. - An empioyee could be recruited for one or many posts. This recruitment of an employee for a given post is validated by a chief (ssn, first name, last name, address) designated by the enterprise. This chief…
"2.1,2.2,2.3, and 2.4 are answered" Introduction The given problem is related to the normalization process of a database table where the requirement is to identify the normal forms of the given sample table and decompose the table. The normalization is a process to break the table into smaller tables to that: a) There is no redundancy b) Table is free from insertion, update and delete anomaly. c) Data in the tables can be handled easily **As per Bartleby guidelines, as the required number of sub-parts to be answered is not mentioned and it is needed to solve first 3 sub-parts. Kindly find the solution to half assignment(first 4 sub-parts). 2.1 Normal form of given table The given table is in unnormalized form i.e. it is not even in the first normal form of the database normalization. Explanation: a) For a single Invoice number, there are many products added to the table. b) There is no direct primary key that can be used to store the data uniquely. c) The given table…
1b)By using a scenario, explain program-data dependence issue found in previous database technologies such as file-oriented database before relational database model was introduced.
SQL databases conform to ACID properties. Briefly describe the ACID properties, and state the purpose of each. How does conformance to ACID properties affect the performance of SQL databases?

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS