CSCI260 Database Applications. Database Administration Part 2. Chapter Six. Chapter Objectives. Understand the need for and importance of database administration Learn different ways of processing a database Understand the need for concurrency control, security, and backup and recovery
Admin Asst: Read, Insert and change data in all tables.
ONLY delete from SEMINAR-CUSTOMER (un-enroll customer from seminar) and LINE-ITEM (take item off order).
Management: Take all actions except delete customers.
Never want to delete a customer.
Sys Admin: Only define permissions. No other rights. Not a user, no need to change data.
End of Presentation on Chapter Six
Final Project for CSCI260