Database Management Systems
moe1990
IT344Assignment3-Questions-.docx|
Pg. 01 |
|
Question One |
|
|
|
|
( Assignment 3 Deadline: Day 06/04/2019 @ 23:59 [Total Mark for this Assignment is 6] ) ( Database Management Systems IT 344 )
( Instructions: This Assignment must be submitted on Blackboard ( WORD format only ) via the allocated folder. Email submission will not be accepted. You are advised to make your work clear and well-presented, marks may be reduced for poor presentation. This includes filling your information on the cover page. You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question. Late submission will result in ZERO marks being awarded. The work should be your own, copying from students or other resources will result in ZERO marks. Use Times New Roman font for all your answers. ) ( Student Details: Name: ### CRN: ### ID: ### )
College of Computing and Informatics
|
|
|
|
|
|
|
|
( 1.5 Marks ) ( Learning Outcome(s): LO3 )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
( 1.5 Marks ) ( Learning Outcome(s): LO3 )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 |
( 2 Marks ) ( Learning Outcome(s): LO3 )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
( 1 Marks ) ( Learning Outcome(s): LO3 )Question Four
What are the differences between valid time, transaction time, and bitemporal databases?
