Computers and Technology, 19.03.2020 01:09 JvGaming2001

Consider the relation courses (C, T,H, R,S, G), whose attributes may be thought informally as course, teacher, hour, room, student, and grade. Let the set of FD'S for courses be C\rightarrowT, HR\rightarrowC, HT\rightarrowR. HS\rightarrowR. CS\rightarrowG. Intuitively, the first says that a course has a unique teacher, and the second says that only one course can meet in a given room at a given hour, The third says that a teacher can be in only one room at a given hour, and the fourth says the same about student. The last says that students get only one grade in a course

a) What are all the keys for courses?

b) Verify that the given FD's are their own minimal basis.

c) Use the 3NF synthesis algorithm to find a a lossless-join, dependency-preserving decomposition of R into 3NF relations. Are any of the relations not in BCNF?

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 17:20

[a] create a class called “cycle” which has two instance integer variables as properties, “numberofwheels” and “weight.” create a constructor with two parameters, using the same variable names in the parameter list. assign each variable to numberofwheels” and “weight” respectively. write a separate application to test the class and display its properties. note: do not change the names of the instance variables or the variables listed in the constructor’s parameter list. [b] edit your class cycle by adding a default constructor which will assign the default values of 100 to represent the numberofwheels, and 1000 to represent the weight, by invoking a call to the other constructor. modify your application created in [a] to test the class.

Answers: 3

Answer

Computers and Technology, 23.06.2019 01:30

Jason works as an accountant in a department store. he needs to keep a daily record of all the invoices issued by the store. which file naming convention would him the most? a)give the file a unique name b)name the file in yymmdd format c)use descriptive name while naming the files d)use capital letters while naming the file

Answers: 3

Answer

Computers and Technology, 23.06.2019 01:30

1. which of the following is a search engine? a) mozilla firefox b)internet explorer c)google d)safari 2. which of the following statements is true? a) all search engines will provide the same results when you enter the same query. b) all search engines use the same amount of advertisements. c) some search engines are also browsers. d) search engines often provide different results, even when you enter the same query.

Answers: 2

Answer

Computers and Technology, 23.06.2019 14:30

The basic work area of the computer is it screen that you when you first fire up your computer

Answers: 1

Answer

You know the right answer?

Consider the relation courses (C, T,H, R,S, G), whose attributes may be thought informally as course...

Questions