CIS4365: Database Applications
Fall, 2017

Database Administration Tutorials

This page is intended to add coverage to the material presented in the lectures, lecture slides and material otherwise available on this website. It IS NOT intended as a substitute for attending class.

NOTE: Topics available for the Tutorial Assignments are those which DO NOT have links to them.

Please Choose from the Topics below:

  Database Administration
 8.00100 What did a typical IS organization look like, and why?
 8.00200 What does a typical IS organization look like now, and why?
 8.00300 What is the difference between a DA, DBA and Data Steward?
 8.00400 What are Data Policies, Procedures and Standards? 
 8.00500 What is involved in Data Planning?
 8.00600 What other Data Administrator functions are there?
 8.00700 What are the functions of the Database Administrator?
 8.00900 What functions are shared between the DA and the DBA? 
 8.01100 What are Data Dictionaries and Repositories?
 8.01200 How can we improve database performance?
 8.01300 What is database security, and what threats are there to it?
 8.01400 How can we manage database security? (2 people may work together on this)
 8.01500 What are statistical database and how do they work?
 8.01600 What is encryption and how does it work?
 8.01700 What are the basic facilities and components in database recovery?
 8.01800 What are the ongoing and periodic back-up facilities and how do they work?
 8.01900 What are the basic back-up concerns and approaches?
 8.02000 What are journalizing facilities and how do they work?
 8.02100 What are checkpont facilties and how do they work?
 8.02200 What is a recovery manager and for what types of failures is it applied?
 8.02300 What are the basic recovery-restar procedures? (2 people may work together on this)
 8.02400 What strategies can be applied to database recovery?
 8.02500 What is a transaction and what properties does it have?
 8.02600 What is an example of a transaction and how would it work?
 8.02700 What are transaction logs and how do they work?
 8.02800 What is concurrency control and what are some issues involved? (2 people may work together on this)
 8.02900 What is transaction scheduling and how does it work?
 8.03000 What is database locking and on what levels can it be applied? (2 people may work together on this)
 8.03100 What types of locks are there and how do they work?
 8.03200 What is deadlock and what is an example of how it can occur?
 8.03300 How can we manage deadlock?
 8.03400 What is versioning and how does it work?
 8.05000 What Questions should I be able to answer?