Assignment: Database Management Systems
Question One
Draw the family tree corresponding to the following Prolog Based on following rules:
female(Mary).
female(Sandra).
female(Juliet).
female(Lisa).
male(Peter).
male(Paul).
male(Tom).
male(Bob).
male(Harry).
parent(Bob, Lisa).
parent(Bob, Paul).
parent(Bob, Mary).
parent(Juliet, Lisa).
parent(Juliet, Paul).
parent(Juliet, Mary).
parent(Peter, Harry).
parent(Lisa, Harry).
parent(Mary, Tom).
parent(Mary, Sandra)
parent(x,y) means x is parent of y
Question Two
Apply the Apriory Algorithms to the following data set to find frequent (Large) itemsets using minimum support value 0.5.
|
Transaction ID
|
Items Purchased
|
|
101
|
Milk, Bread, Cookies, Juice
|
|
102
|
Milk, Juice
|
|
103
|
Milk, Eggs
|
|
104
|
Bread, Cookies, Coffees
|
Question Three
Consider these two tables:
Daily_avg_tempreature(year, month_nber, day_nber, avg_temp )
Monthly_maximas(year, month_nber,max_temp )
a. Using Oracle notation, write a trigger that allows to automatically update table Monthly_maximas on each insert of a new record in table Daily_avg_tempreature
b. Using Oracle notation, write a trigger that allows to automatically update table Monthly_maximas on each update of records in table Daily_avg_tempreature
Question Four
What are the differences between valid time, transaction time, and bitemporal databases?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.