Draw the family tree corresponding to given prolog

Assignment Help Database Management System

Reference no: EM132268223

Questions: 1. 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

2. 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

3. 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

4. What are the differences between valid time, transaction time, and bitemporal databases?

Reference no: EM132268223

Questions Cloud

Interactive prototype and only five participants : Early in the development of a new product, you conduct a formative usability test with an interactive prototype and only five participants

Discuss crime control versus individual rights : Your decisions reflect your competence, discretion, judgment, and the balancing of "crime control versus individual rights" models.

What should be the level of influence : What roles should be included and what should be the level of influence?

Briefly explain the assumptions of the theory : Choose a theory only one and briefly explain the assumptions of the theory, and then using the theory explain the most important theme in the chapter.

Draw the family tree corresponding to given prolog : Draw the family tree corresponding to the following Prolog Based on following rules. Apply the Apriory Algorithms to the following data set to find frequent.

How analyzing glass fractures can assist investigators : You are required to write an essay explaining in detail how you reached this conclusion to include a discussion about how glass fractures.

Calculate the average access delay for a drive : Calculate the average access delay for a drive with HTH switching time of 3 ns, 6 R/W heads

The development of the department of homeland security : A potential problem that might exist with the development of the Department of Homeland Security (DHS) is the notion many of the departments.

Type of membership based on the amount of points : Python program with if-elif-else structure that can decide the type of membership based on the amount of points entered by the user:

User Account

All Pages