test

test

group:UIBK - PS Databse Systems - Exercise Sheet 5 (Pizza)

Person = {
	name:string, age:number, gender:string
	'Amy'      , 16        , 'female'     
	'Ben'      , 21        , 'male'       
	'Cal'      , 33        , 'male'       
	'Dan'      , 13        , 'male'       
	'Eli'      , 45        , 'male'       
	'Fay'      , 21        , 'female'     
	'Gus'      , 24        , 'male'       
	'Hil'      , 30        , 'female'     
	'Ian'      , 18        , 'male'       
}

Frequents = {
	name:string, pizzeria:string 
	'Amy'      , 'Pizza Hut'     
	'Ben'      , 'Pizza Hut'     
	'Ben'      , 'Chicago Pizza' 
	'Cal'      , 'Straw Hat'     
	'Cal'      , 'New York Pizza'
	'Dan'      , 'Straw Hat'     
	'Dan'      , 'New York Pizza'
	'Eli'      , 'Straw Hat'     
	'Eli'      , 'Chicago Pizza' 
	'Fay'      , 'Dominos'       
	'Fay'      , 'Little Caesars'
	'Gus'      , 'Chicago Pizza' 
	'Gus'      , 'Pizza Hut'     
	'Hil'      , 'Dominos'       
	'Hil'      , 'Straw Hat'     
	'Hil'      , 'Pizza Hut'     
	'Ian'      , 'New York Pizza'
	'Ian'      , 'Straw Hat'     
	'Ian'      , 'Dominos'       
}

Eats = {
	name:string, pizza:string
	'Amy'      , 'pepperoni' 
	'Amy'      , 'mushroom'  
	'Ben'      , 'pepperoni' 
	'Ben'      , 'cheese'    
	'Cal'      , 'supreme'   
	'Dan'      , 'pepperoni' 
	'Dan'      , 'cheese'    
	'Dan'      , 'sausage'   
	'Dan'      , 'supreme'   
	'Dan'      , 'mushroom'  
	'Eli'      , 'supreme'   
	'Eli'      , 'cheese'    
	'Fay'      , 'mushroom'  
	'Gus'      , 'mushroom'  
	'Gus'      , 'supreme'   
	'Gus'      , 'cheese'    
	'Hil'      , 'supreme'   
	'Hil'      , 'cheese'    
	'Ian'      , 'supreme'   
	'Ian'      , 'pepperoni' 
}

Serves = {
	pizzeria:string , pizza:string, price:number
	'Pizza Hut'     , 'pepperoni' , 12          
	'Pizza Hut'     , 'sausage'   , 12          
	'Pizza Hut'     , 'cheese'    , 9           
	'Pizza Hut'     , 'supreme'   , 12          
	'Little Caesars', 'pepperoni' , 9.75        
	'Little Caesars', 'sausage'   , 9.5         
	'Little Caesars', 'cheese'    , 7           
	'Little Caesars', 'mushroom'  , 9.25        
	'Dominos'       , 'cheese'    , 9.75        
	'Dominos'       , 'mushroom'  , 11          
	'Straw Hat'     , 'pepperoni' , 8           
	'Straw Hat'     , 'cheese'    , 9.25        
	'Straw Hat'     , 'sausage'   , 9.75        
	'New York Pizza', 'pepperoni' , 8           
	'New York Pizza', 'cheese'    , 7           
	'New York Pizza', 'supreme'   , 8.5         
	'Chicago Pizza' , 'cheese'    , 7.75        
	'Chicago Pizza' , 'supreme'   , 8.5      
  'Coka Pizza', 'pepperoni', 4
  'Coka Pizza', 'sausage', 5
  'Coka Pizza', 'cheese', 6
  'Coka Pizza', 'supreme', 7
  'Coka Pizza', 'mushroom', 8
  'Coka Pizza', 'coka', 100
}