Universitas  Andalas

Faculty of Economics                                                                          

Unit Guide 1^st Semester 2012/2013 Session

 

Unit Name : Database Management

Credit Points : 2 points

Class Contact :

Lecturer-in-Charge : Amsal Djunid 

Email : amsaldjunid@yahoo.com

Web page : http://amsaldjunid.orgfree.com

Contact no : 0811665118

 

Descriptions  : The unit cover DBMS and database, develop the student’s ability to design and retrieve information from database.

Syllabus : Database management activities, database design and  modeling, normalization,  inforamtion security and control. 

Assessments:

Assignment  (case study) 50%

Examination  (include case study material) 50%

 

Course Outline

1. Introducing the unit
2. Database management activities
3. Information system technology overview
4. Relational database
5. Understanding and Designing Queries and Reports
6. Understanding and Designing Forms
7. Conceptual entity relationship model
8. Connectiontrap
9. Midterm Test
10. Physical database design
11. Normalization
12. Information security and control
13. Case study discussion/presentation
14. Case study discussion /presentation
15. Case study discussion /presentation
16. Final Exam (Case study group assignment due)

References:  

Silberscharts, Korth and Sudarshan (2002). Database System and Concepts, 4^th ed McGraw Hill or the later edition

Mc Leod and Schell (2007) Management Information Systems, 10^th ed. Pearson Prentice Hall

Howe (1990) Data Analysis for Database Design, 2^nd Edward Arnold

Amsal Djunid, Database Design, Lecture Note

 

Assigements

1. Project 9 Database Forms and Report  due Oct
2. Project 10 Database Queries – Text books Database Due Oct
3. Project 11 Database queries – ClassProjects Database Due Oct
4. Database design – Major assigment  - Due at final exam date