4 questions Chapter 4

4 questions Chapter 4 – see attached word document





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

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

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



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







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

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

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

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

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

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





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

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

      



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



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

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



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

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

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

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



  
  


  

  











 

  
   


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

   





  



  

   

  

   

   

 

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




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



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




  
 
  
 

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

 

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

 










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

  











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



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



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

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

 


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

 




 



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

 
 
             
 


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

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



  

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



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

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



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

   



     

     



 

     

     

 

   

     

 

  

 

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

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

    
 
















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



     
     

    

     
     

    

   

      

      





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

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

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

 



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



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



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

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



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





   





 















 





  



 




 



 

  

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



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



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



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



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

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


 










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

 


 


 

   

   

   

   



   

   

   

   

   

   

   

    

   

   

   



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

   

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

     


   





  



 





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

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




 





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

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



 
 






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






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

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

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

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

    




      

    

    

    

   

  





      

   

     









      

    

    

  

     





      
      

     



 



 





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



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

   

  

   

  

   

   

  

    

    

 



  


          



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



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






 



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

 


 




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

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

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











 

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



 

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





  



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

 

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






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




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

 







  



     






   








 















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

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





 


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



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










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

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





   

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

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

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

 







  


























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









   










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

   






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

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






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

 

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





 
 


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

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



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

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

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








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

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



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

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

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

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

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














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

 







 

 









   
















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

 

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



  

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

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

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






 
 


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

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

 







  





   

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

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

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

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

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

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














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



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







  

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



  




 







   



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

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

 
 









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



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

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





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









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

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









 






 



  



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

 





 





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

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


 








 



 










  

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



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

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



 





   







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


  
  




 




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











  

 









 

 









   

 













 


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

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

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

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



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

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










  





 



 





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

   





   

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

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


 









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

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



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



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

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









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

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

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



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

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



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

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

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



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

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

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

 

   










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








  

 

  

 

 


 
 

 
 

   
   


 




     


   

 

 




 

  






 

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

   

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

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

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

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

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

 
 
 


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






 




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

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

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

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

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

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



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










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



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

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

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

 

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

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

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

   



   



























































 

  



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

   

 


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

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


  
 





 
 



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

  
  



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



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


   

 



    

 



   

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









 


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

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

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




 



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





 

 







 



 



  

 
 

 









    





 







   
 

 



   

    
 
 

 

  

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

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

  

          

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





         

       

        

  

       

 

       



 

        

  

  










      

   

 

         
       

          

  

    



    

 

         

  

     

 

  

 

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

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

 


 
 
 
 









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

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







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

  



 




   





 

  





 

   

  
 
  

  
  






 
 
     



 
 




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

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

 


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






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




  

  


 

     

 



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



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

   

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

 



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

 





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

  
  

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









 


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

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

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


 




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



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

 



   

   

   

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

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



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






























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






 



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

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



 


 



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

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

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

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

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

 


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





 





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



   






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

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

 




            
 

  





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

 

 


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

 


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



















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

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

 


 







 


 









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

 


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






 

 



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

   

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

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

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




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





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

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






   










































































 
















 









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

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



     
   




 









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

   

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

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

      
      






















































































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



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

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

 




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



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

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






















 
 
 


 
 


 


  


 

 

 

 
  
 
 
 
 
 

 
 



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

 

 
 

 



 


   


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



 
 
 
 
 
 
 

  

 



 
 
 
 

 

 
 

 

 

 




 

 







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

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

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

 


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

 


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

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

   

  


  


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

 

 


   
 


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

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

 
        
 


 
 

 

 
 
  
  
  
  
  
  

 
 
 


 
 

 

 
 
 
 
 

 




 
 
    
 

    
 


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

  
 
 

       


 
 
 

   





 
 
 

   




 



 


 



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


 

 

   

    
    
    

 

   





 

























 



 



 

    

    

  

    

  

  

    


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

  

 


 
 
 


 


  

 


 
 
 


 


 


 
 
       

   

       

  
 

  
  

 



 

 

 



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

 



     




 

           

           

          

         

          

 

    

    

 

    



     

     



     



 

 



         

            

     

             

    

    

   

 


 






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

 



 


 



 


 
 
 


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

 




 


 
 



  
 

 

 

 

  

 

 

 

 

 



 

 

   

    

     

    

   

   

 


















 






















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

   

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

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

 


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

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

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

  

    
 


  




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




 
 

 



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

  


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

  
     

 


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







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



























 



   
























































 




 





 

   

















     

       

 

 

   

    

   

 

   

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










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

 
 


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

















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







   

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

 


 









































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





 

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

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

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

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

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

    




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



 
   

  
 

  


 


 


 


  


 



 
   

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

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

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

  
     

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

  

 

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

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

     



   


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

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

    



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

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

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

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

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

 


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

 


 

  






 




 
      


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

 





 

   




 

 



   


 
 

     







 




 
 
 










 

 

 
 

 

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




 























 



 















 

 

 

 
 

 

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



    

 

 

  

  

  



 

 

 

 



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

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

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

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

 


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

 





    




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

 
 


 


 



           







 



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

 


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




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

 

  



 

 



























 



        

           







     









  

 



 

 


    


  

   
 



 

        

   

    



 

    

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



     

       



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



 

  

  

   

  

 



          

     

    

 

     



  



     

         

      

        

         

        

  



  

    

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

  

 





  





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

 


 


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

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

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



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

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

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

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

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












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

      

 

Provide answers the the following questions:

1. What is a well-structured relation?  Why are well-structured relations important in logical database design?

2. What is the primary purpose of normalization?

3. List three conditions that you can apply to determine whether a relation that is in first normal form is also in second normal form.

4. Explain how each of the following types of integrity constraints is enforced in the SQL CREATE TABLE commands:

a. entity integrity

b. referential integrity