Given the following relation R and its functional dependencies: R(workerNumber, repairNumber, workerName, machineNumber, spentTime, repairDate, machineName, workshopNumber, workshopName )   workerNumber à workerName repairNumber à repairDate, machineNumber machineNumber à machineName, workshopNumber workshopNumber à workshopName 1)Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table

Consider the following database instance. Table name: Students  Primary key: sid Sid sname 7 Ricky 2 Ellen 6 MaryLou 4 Ellen   Table name: Courses  Primary key: cid cid cname 1 ICS 2 Finance   Table name: Register Primary key: sid,cid Foreign key: sid references Students(sid) Foreign key: cid references Courses(cid) sid cid 7 2 2 2 7 1 4 1   5.1) For each of the following statements, show whether the statement is correctly executed or not (assume that the statements are executed in order, which means that if a statement is correctly executed, its effect is reflected in the following statement). If you say the statement is not executed, explain why. INSERT INTO Students VALUES (3, ‘Ellen’);     INSERT INTO Students VALUES (6, ‘Ellen’);     INSERT INTO Register VALUES (1, 2);     INSERT INTO Courses VALUES (5, ‘Systems’);     INSERT INTO Register VALUES (6, 5);     INSERT INTO Register…

Consider the following database instance. Table name: Students  Primary key: sid Sid sname 7 Ricky 2 Ellen 6 MaryLou 4 Ellen   Table name: Courses  Primary key: cid cid cname 1 ICS 2 Finance   Table name: Register Primary key: sid,cid Foreign key: sid references Students(sid) Foreign key: cid references Courses(cid) sid cid 7 2 2 2 7 1 4 1   5.1) For each of the following statements, show whether the statement is correctly executed or not (assume that the statements are executed in order, which means that if a statement is correctly executed, its effect is reflected in the following statement). If you say the statement is not executed, explain why. INSERT INTO Students VALUES (3, ‘Ellen’);     INSERT INTO Students VALUES (6, ‘Ellen’);     INSERT INTO Register VALUES (1, 2);     INSERT INTO Courses VALUES (5, ‘Systems’);     INSERT INTO Register VALUES (6, 5);     INSERT INTO Register…

With the following Object Oriented Relational Database schema, select the attributes that a tuple in Teachers would have.     create type Person    (ID varchar(20) primary key,     name varchar(20),     address varchar(20))  ref from(ID); create table people of Person;     create table students    ( degree varchar (20))    inherits people ;create table teachers    ( salary integer )    inherits people ;     a. id   b. salary   c. degree   d. name

For merging two relations that are not physically sorted but share an index on the characteristics in question, it is necessary to develop a hybrid merge-join method.

How many of the relations in Johnny's logical database design have a composite primary key?

The following is the relation notation of a database table in 1NF ORDER(CustNum, CustFN, CustLN, OrderNum, OrderDate, ProdNum, ProdDesc, Qty, UnitPrice) The functional dependencies are given below: CustNum → CustFN, CustLN OrderNum - OrderDate, CustNum, CustFN, CustLN ProdNum → ProdDesc OrderNum, ProdNum -> UnitPrice, Qty Use the functional dependencies above to answer the following questions. Don't not make additional assumptions and functional dependencies. A. List all partial dependencies in the relation only (if any) using the dependency numbers. Don't write the dependencies in X->Y format, just indicate their numbers (which are listed on the left side, i.e., 1, 2, 3, 4). Indicate only the dependencies that you think are partial. B. Identify and show the 2NF. Show primary keys and foreign keys references. Use relational notation (show references). Write down all relations and their references below. C. List all transitive dependency in your answer to question b (if any)…

DATABSE

Q3. Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club's members, to plan the meals, to keep track of who attends the dinners, and so on. Each dinner serves many members, and each member may attend many dinners. A member receives many invitations, and each invitation is mailed to many members. A dinner is based on a single entree, but an entree may be used as the basis for many dinners. For example, a dinner may be composed of a fish entree, rice, and corn. Or the dinner may be composed of a fish entree, a baked potato, and string beans. Because the manager is not a database expert, the first attempt at creating the database uses the structure shown in the table below: Attribute Name MEMBER_NUM MEMBER_NAME MEMBER_ADDRESS MEMBER_CITY MEMBER_ZIPCODE INVITE_NUM INVITE_DATE ACCEPT_DATE DINNER_DATE DINNER_ATTENDED DINNER_CODE DINNER_DESCRIPTION Sample Value…

A relation r(A, B, C) had multi-valued dependencies among all its attributes. It was decomposed for achieving a better database as follows r1(A, B) r2(B, C) r3(C, A) This is an example of what kind of normalization? BCNF 4NF OPJNF DKN