4 datebase management questions

****MUST HAVE BY TOMORROW 1530.



      








































 
        








 




    
 















  

       








 












       


































  


  



         

























   




 




 

 
 































  








 

















 









  





 




















   









 




  


  













 











 





 



  

   


           





 

 








 



  



   

 




 






 







 









 



 





 

 
































 












   












 













 

 
























 























 





   
















         
 









































 












 


















   






























 










































 











   














 



  


 
 



 


 

 








 






 







 




 








 



























   

 




















 


  


 

 




 
  
 



 







 




 




 

















   


 


   
 





  



  


 

















 






 







 

 
















 












 







 







   


















 




 










 


























 





  

  

  

  





   









  
 


 





 



 






























 

 











 






 










   

 




  






     





 
 

 


 




















 







 











 

   

 












 

 


 
 



 








 





  





 

    


 
 
 









         






















 









 

 





 

 

 























  

 























 









































 

   



 


























 











 














  



   






 


 


















  
 







  





 










 
 






  
  












 



 
































 

























  






   








  









  



 





  



 

    



      
   





   

   

 

  




   






















 


  









 





  

   
















 




 








 





         


 


 








 

 


 


 








   

         





 


 







 






























 




 

 




   




 











 








 









 

























   

 


































 


  






 



         





 
 
















 















  








 























  




































   





















 


 












  







 















  

  





  
 

 
 



 
      

   




 
 

 


   


 



   








  
 
 






 


 

 











 




 


 


 



 

 
 

 
       
         























































   

   

 

   

   

 
























































































 

 

 




 



 








































































  



   










 



  

 



   




 



 

   
 



  
      


















      





      






      
 






 













  

      






   

 
 
 
 

 





 
 
 

 

 

 



 

 


 


 



 
 
 
 
 
 
 


 
 
 
 
 
 
 

 










 
 
 
 
 
 
 

 


 
 


 
 
 


 


 

 
 
 







       

  






    


















      

     










 
 
 
 
 


 


 

   

 


 



 


 
 




  
 



 

 
 


     


 
 

 



 
 
 
 
 

 
 



 




   
 

     
    


         
 

  


 







   


 
      



 


  



 



 


 







     
      


 

  



 




 



       

















   

 
 

 

       






   















 
 




        



 





 
  






      


 
 



 





 
     

        


 

 


 


 




       






 


 
       


 

 






 


 


  


 



 

 



       




















   

















       





      

     
















 


 






 


     




 
 


 



     

       



 
    














  


    



 


















       
  

     



   
       
        
 


  





  


   



     
  



    





 


 




 

  



   




 
 
 


      


 









 


 


 
 

 


 


 
  


 
 

   

  


 


        
 


 




 


      



 


 
     


 


       
 

 

    

 

      
    

 

  

    
   

   



 
 


 






 



 
 




 
     




     




    
 


        


 




    






   









       




      


 

     




  






       














        





 






 









  

      





  
 













 


 


 






       






















   







 







  

   

  



  

  

 

 

 

 

   

 

     







 

















      












 

 

 

 

 

 

 

 



 




 







        



 


 

     
 




 
 
 

   


 




         
       
 

    






  



      

      


 


   

This page intentionally left blank














   














 


 



  







      
 
 

  












   








   






     









 

 













































      





Answer the following questions. Other than #2 (problem and exercises 5), diagrams are required for all.

1. Problems and Exercises 3 (c, d, e) (Page 144) 25 Points

For simplicity, subtype discriminators were left off many figures in this chapter. Add subtype discriminator notation in each figure listed below. If necessary, create a new attribute for the discriminator.

c. Figure 3-4b (page 119)

d. Figure 3-7a (page 123)

e. Figure 3-7b (page 127)

2. Problems and Exercises 5 (Page 144) 25 Points

Refer to the EER diagram for patients in Figure 3-3 (page 118). Make any assumptions you believe are necessary. Develop sample definitions for each entity type, attribute, and relationship in the diagram.

3. Problems and Exercises 8 (Page 144) 25 Points

At a weekend retreat, the entity type PERSON has three subtypes: CAMPER, BIKER, and RUNNER. Draw a separate EER diagram segment for each of the following situations:

1. At a given time, a person must be exactly one of these subtypes.

2. A person may or may not be one of these subtypes. However, a person who is one of these subtypes cannot at the same time be one of the other subtypes.

3. A person may or may not be one of these subtypes. On the other hand, a person may be any two (or even three) of these subtypes at the same time.

4. d. At a given time, a person must be at least one of these subtypes.

4. Problems and Exercises 9 (Page 144) 25 Points

A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account:

CHECKING: Acct No, Date Opened, Balance, Service Charge

SAVINGS: Acct No, Date Opened, Balance, Interest Rate

LOAN: Acct No, Date Opened, Balance, Interest Rate, Payment

Assume that each bank account must be a member of exactly one of these subtypes. Using generalization, develop an EER model segment to represent this situation

using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor. Remember to include a subtype discriminator.