Question: DATABASE: Consider the following relation TJ (which stands for tutoring assignments): TJ(TutorId, TLName, TFName, StudentId, SLName, SFName, SubjectId, SubjectName, StartDate). A tuple in TJ may

DATABASE:

Consider the following relation TJ (which stands for tutoring assignments): TJ(TutorId, TLName, TFName, StudentId, SLName, SFName, SubjectId, SubjectName, StartDate).

A tuple in TJ may be: (t1, Smith, John, s10023, Paul, Adams, sub17, Chemistry, 2018-01-11), meaning that the T.A with id t1 and name John Smith is assigned as the T.A for the student with id s10023 and name Paul Adams on the subject Chemistry (with the subject id sub17) starting on 2017-01-11.

It is known that TutorId, StudentId and SubjectId are unique identifiers for t.a students and subjects respectively. Also, no two subjectId should be associated with the same subject name. A T.A can help many students and a student can have many T.As. However, given a specific subject for a specific student, the relation only stores the most recent T.A on that subject for the student.

(a) List all applicable functional dependencies. (Make reasonable assumptions if necessary.)

(b) What is the highest normal form? Why?

(c) If the highest normal form is not BCNF, can you decompose the relation TJ losslessly into component relations in BCNF while preserving functional dependencies? If yes, how. If no, why?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

please need help database! Consider the following relation: TUPLE# 10 10 bl 102. cl c2 cl C4 cl C4 12 13 14 1n3 bl 1n3 6 a. Given the previous extension (state), which of the following dependencies...

Keys and superkeys Database Consider the following relation: A1 A2 A3 X 4.0 q 4.0 Z 3.1 Z 4.0 Problem 2) Fill in the missing entries in the table below. For the "Superkey" and "Key" columns, write...

Help In Database: Consider the following relation with simple data: E4.8a Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if...

Consider the following relation schemas about a teaching database. Student: S(Sno,Sname,Sgender,Sage,Sdept) Couse: C(Cno,Cname,Cprerequisite,Credit) Takes: T(Sno,Cno,Grade) Underlined attributes...

Consider the following relation: laptops : Model + Brand where laptops = { legion5 lenovo, macbookair > apple, Ips15 dell, spectre hp Eps13 dell, swift3 acer, macbookpro apple, dragonfly Hhp,...

Consider the following relation: laptops : Model Brand where laptops = { legion5 # lenovo, macbookair apple, xps 15 dell, spectre hp, xps 13 dell, swift3 Hacer, macbookpro Happle, dragonfly hp,...

Q 1 . Consider the requirements for the following Election system, carefully and Create the E - R diagram. The US Election database keeps track of THE FOLLOWING: The database needs to keep track of...

(total marks 20) Given the same simple SalesRep-Worksin-SalesArea database schema you worked on in assignment 1, which contains three files described as follows: SalesRep (SRid: integer, SRname:...

Consider the relation R, which has attributes that hold schedules of courses and sections at a university; R = {Course_no, Sec_no, Offering_dept, Credit_hours, Course_level, Instructor_ssn, Semester,...

Draw the ER diagram and answer problem 1 - 5 please. Problem 1 : Create an ER diagram that corresponds to the following scenario. Be sure to capture all relevant entities, relationships, attributes,...

in a group project whose sole purpose is CRM has to come up with a budget. The group is part of a small cafe renovation project . Other than Salesforce software what else is important for CRM to...

Holding all else constant, an increase in the price of hot dogs would cause the marginal revenue (MR) curve in the market for hot dog buns to increase. marginal revenue (MR) curve in the market for...

All the following statements concerning the alternative minimum tax ( AMT ) are correct EXCEPT ( A ) Medical expenses in excess of 7 . 5 percent of adjusted gross income are deductible in computing...

Lucille Company has a cash shortage, which of the following is an ethical way to for a company to improve its cash flow? Select one: a. The company can finance its payables so that it can choose to...

5. Choose the appropriate evaluation design based on the characteristics of the company and the importance and purpose of the training.

8. One way to diagnose transfer of training problems or to ensure that transfer of training occurs is to complete the matrix shown below. This matrix considers the responsibilities of the manager,...

5. This assignment relates to Application Assignment 2 in Chapter 4. You now receive the following e-mail from the vice president of operations. Prepare an answer. Thanks for your recommendations...