For each one of the domain specification given below, identify all the functional dependencies, and its highest normal form. Remember that the identification of a normal form requires analysis of the valid functional dependencies and the minimal keys. Providejustification of each answer. 4. In a company, employees involved in many projects, and each project may have many employees working on it. The number of hours each employee works in each project, and the start date on which the employee starts working on the project are capture in the following relational table. EmployeeProject (EmpeNum, ProjNum, HoursWork, DateStartWorkOnProj) 5. Each student is assigned with a counselor who will act as an advisor to the students. The student is given the counselor email address so that the student can contact the counselor for advice. The information on the student and counselor are stored in the following relational table. STUDENTCOUNSELOR (StdNum, StdName, CounselorName, CounselorEmail)

For each one of the domain specification given below, identify all the functional dependencies, and its highest normal form. Remember that the identification of a normal form requires analysis of the valid functional dependencies and the minimal keys. Providejustification of each answer. 4. In a company, employees involved in many projects, and each project may have many employees working on it. The number of hours each employee works in each project, and the start date on which the employee starts working on the project are capture in the following relational table. EmployeeProject (EmpeNum, ProjNum, HoursWork, DateStartWorkOnProj) 5. Each student is assigned with a counselor who will act as an advisor to the students. The student is given the counselor email address so that the student can contact the counselor for advice. The information on the student and counselor are stored in the following relational table. STUDENTCOUNSELOR (StdNum, StdName, CounselorName, CounselorEmail)

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

entities: Residential students which fields like student id, Student name, exam papersTransfer students with fields like student id, transferred school, exam papers etc.Exam papers with fields like subjects, total marks, invigilator, checkers.Exam center with fields like Center Id, location, seating capacity etc. -Create an ER Diagram using the enumerated entities.
DATABASE SYSTEM A relation R is given which is R(A,B,C,D,E). It has the following functional dependencies: BC -> D, AC -> BE, B->E . Answer the following based on this information. What is the candidate key of this relation? Is it in 2NF? Explain why or why not.
7
Which of the following statements are correct about EER model for this requirement? Book, Periodical, DVD, ReferenceItem, BorrowingItem, RegisteredUser, and TemporaryUser are set as entities. RegisteredUser and TemporaryUser can be generalized into a User entity. The specialization/generalization hierarchy for users is overlapping for disjoint constraint. Book, Periodicals, DVD, ReferenceItem, and BorrowingItem can be generalized into an Item entity
A client wishes to retrieve some domain object, say dom, from the database. Describe a possible problem with this scenario. Extend your design and provide a dynamic design model (focusing on the passage of time) that can solve the problem. Note: Do not provide any statements to describe the solution. The solution should be apparent in your design. Non-functional requirements include integrity of data and resource utilization.
Domain Model Class Diagram LAB 6: Academic Scenario With the following information given below, design a domain model class diagram. A university has only full-time and part-time instructors. The details of an instructor include name, address, email, and number. The students in the university can enroll in a seminar and the details to be stored for each student include name, student number, and email. Each seminar consists of seminar name and seminar code. Full-time instructors are responsible for taking the seminars. Each seminar can be taken by at least one and at most two instructors. Part-time instructors can teach courses as well as full-time instructors. Each course consists of a name and course code. Students can register for a maximum of five courses per semester. A course can either be a university elective or an area elective. The availability of an area elective course depends on the number of available students for that course. A student can either be a bachelor, master's,…
2. The relations SE Developer and Programmer below are mapped from the ERD on their left. Determine if they are in 4NF or not. If not, normalize it to 4NF. SW-Developer ID SW-Developer skill ID language proficiency language proficiency Programmer ID Programmer language phone ID language phone
Create an entity named country and capital and create a one-to-one mapping using JPA. |САPITAL Capital Name Capital_Population COUNTRY Country_Name Country_Population Capital Name Write a main program to assign values to the country and capital entity using entity manager instance.
Convert this Table into BCNF . pls show the result of each step in the normalization process. Books( book_id, title, publisher_id, ISBN, edition, price, num_page, publication_date) Functional Dependencybook_id -->title, publisher_idISBN -->title , edition, price, num_page, publication_dateedition -->publication_date
Please define both functional and non-functional demands, and provide two instances of each.
What are the key distinctions between overlapping and disjoint constraints, and how do you distinguish between the two?
Consider the following schema: Publisher (name, phone, city), PK: name. Book (ISBN, title, year, published_by, previous_edition, price), PK: ISBN, FK: published_by refs Publisher, previous_edition refs Book. Author (SSN, first_name, last_name, address, income), PK: SSN. Write (aSSN, bISBN), PK: (aSSN, bISBN), FK: aSSN refs Author, bISBN refs Book. Editor (SSN, first_name, last_name, address, salary, works_for, book_count), PK: SSN, FK: works_for refs Publisher. Edit (eSSN, bISBN), PK: (eSSN, bISBN), FK: eSSN refs Editor, bISBN refs Book. Author_Editor (aeSSN, hours), PK: aeSSN, FK: aeSSN refs Author, aeSSN refs Editor. Give SQL statements for the following plain English language queries based on the above schema.