| School/Faculty: | Faculty of Computing |
| Program name: | SECD2523 |
| Course code: | SECD2523 |
| Course name: | Database |
| Credit hours: | 3 |
| Academic Session/Semester: | 20232024/01 |
| Pre/co requisite (course name and code, if applicable): | None |
- Course Synopsis
- CLO/PLO/T&L
- Details on Innovative T&L practices
- Transferable skills
- Student learning time (SLT) details
- Special requirements
- Learning Resources
- Academic Honesty and Plagiarism
- Disclaimer
This course introduces students to the concept of database system and how it is used in daily human life and profession. The focus of the course is to equip students with the knowledge and skills on important steps and techniques used in developing a database, especially in the conceptual and logical database design phase. Among topics covered are database environment, database design, entity relationship diagram, normalization, and structured query language (SQL). Students will be taught to use a database management system (DBMS). Students are required to design and develop the database component of an information system using the learned techniques, DBMS and a development tool. At the end of the course, students should be able to apply the knowledge of designing and developing a good database system.
- Connolly, T., Begg, C. Database Systems: A Practical Approach to Design, Implementation, and Management. 6th Edition, Pearson Education International, 2015. - Coronel, C., Morris, S. Database Systems: Design, Implementation, and Management. 13th Edition, Course Technology-Cengage Learning, 2019. - http://elearning.utm.my
| Course coordinator (if applicable) | Dr. Izyan Izzati Kamsani | ||||
| Course lecturer(s) | Name | Office | Contact no. | ||
|---|---|---|---|---|---|
| 01 | SECBH | Dr Haslina binti Hashim | |||
| 02 | SECRH | Dr Izyan Izzati binti Kamsani | |||
| 03 | |||||
| 05 | SECJH | Dr Haslina binti Hashim | |||
| 06 | Dr Izyan Izzati binti Kamsani | ||||
| 07 | Dr Nur Eilliyah @ Wong Yee Leng | ||||
| 08 | Dr. Noor Hidayah binti Zakaria | ||||
| 09 | SECVH | Dr Sharin Hazlin binti Huspi | |||
| 10 | Pn Rozilawati binti Dollah @ Md Zain | ||||
Mapping of the Course Learning Outcomes (CLO) to the Programme Learning Outcomes (PLO), Teaching & Learning (T&L) methods and Assessment methods:
| No. | CLO | PLO (Code) | *Taxonomies and **generic skills | T&L methods | ***Assessment methods |
|---|---|---|---|---|---|
| CLO1 | Apply the fundamental database (DB) principles in DB system lifecycle. | PLO1 (KW) 20% | C3 | Lecture, KWL Chart, Think-pair-share. | Weekly task (10%) Mid-Term Exam (5%) Final Exam (5%) |
| CLO2 | Develop a logical database design using entity-relationship diagram (ERD) and normalization techniques. | PLO2 (AP) 35% | C5 | Lecture, KWL Chart, Think-pair-share, cooperative learning, problem-solving, PoBL | Mid-Term (10%) Final Exam (15%) Project Report (10%) |
| CLO3 | Construct Structured Query Language (SQL) statements for database manipulation using a database management system (DBMS). | PLO3 (PS) 35% | C5 | Lecture, Lab work, PoBL | Lab Exercise (10%) Final Exam - SQL (10%) Mid-Term Exam (5%) Project Report (10%) |
| CLO4 | Develop the database component for a database application solution using learned designing techniques, DB language, DBMS, and development tools. | PLO5 (TH) 10% | TH3 | PoBL | Project Report (10%) |
| Refer *Taxonomies of Learning and **UTM’s Graduate Attributes, where applicable for measurement of outcomes achievement | |||||
| No. | Type | Implementation |
| 1. | Active learning | Conducted through in-class activities |
| 2. | Project-based learning | Conducted in a group project assignment. Students, in a group of 3 or 4, are required to develop a database application system for a selected company. Students are required to go through the database system development methodology starting from determining the database requirements until developing the database application system. Students shall apply all relevant knowledge acquired throughout the semester on the project. Students are assessed on their ability to deliver a creative database design solution that will be able fulfill the requirements identified. |
Transferable skills (generic skills learned in course of study which can be useful and utilised in other settings):
- Team working
- Written communication
| Distribution of Student Learning Time (SLT) Course Outline | Guided Learning (Face to Face) | Guided Learning (Non-Face to Face) | Independent Learning (Non-Face to Face) | SLT | |||
|---|---|---|---|---|---|---|---|
| CLO | L | T | P | O | |||
| CLO 1 | 4 | 4 | 7.5 | 15.5h | |||
| CLO 2 | 4 | 8 | 5 | 18 | 35h | ||
| CLO 3 | 4 | 4 | 4 | 5 | 13.5 | 30.5h | |
| CLO 4 | 10 | 4 | 10 | 24h | |||
| Total SLT | 12 | 8 | 22 | 14 | 52 | 105h | |
| Continuous Assessment | PLO | Percentage | Total SLT | |
|---|---|---|---|---|
| 1 | Weekly task | PLO 1 CLO1 | 10 | 3.5h |
| 2 | Lab Exercises | PLO3 CLO3 | 10 | 6h |
| 3 | Project | PLO2 CLO2 PLO3 CLO3 PLO4 CLO4 |
10 10 10 |
As in CLO 2, 3, 4 |
| Assessment | Percentage | Total SLT | ||
| 1 | Final Exam | PLO1 CLO1 PLO2 CLO2 PLO3 CLO3 |
5 (MCQ) 15 (Structured) 10 (SQL) |
3h |
| 2 | Lab Exercises | PLO1 CLO1 PLO2 CLO2 PLO3 CLO3 |
5 (MCQ) 10 (Structured) 5 (SQL) |
2.5h |
| Grand Total | 100 | |||
Special requirements to deliver the course (e.g.: software, nursery, computer lab, simulation room):
- Computer lab that is equipped with Database Management System (DBMS) software, ERD software designer tool, application program software
- Connolly, T., Begg, C. Database Systems: A Practical Approach to Design, Implementation, and Management. 6th Edition, Pearson Education International, 2015. - Coronel, C., Morris, S. Database Systems: Design, Implementation, and Management. 13th Edition, Course Technology-Cengage Learning, 2019. - http://elearning.utm.my
Assignments are individual tasks and NOT group activities (UNLESS EXPLICITLY INDICATED AS GROUP ACTIVITIES) Copying of work (texts, simulation results etc.) from other students/groups or from other sources is not allowed. Brief quotations are allowed and then only if indicated as such. Existing texts should be reformulated with your own words used to explain what you have read. It is not acceptable to retype existing texts and just acknowledge the source as a reference. Be warned: students who submit copied work will obtain a mark of zero for the assignment and disciplinary steps may be taken by the Faculty. It is also unacceptable to do somebody else’s work, to lend your work to them or to make your work available to them to copy.
All teaching and learning materials associated with this course are for personal use only. The materials are intended for educational purposes only. Reproduction of the materials in any form for any purposes other than what it is intended for is prohibited. While every effort has been made to ensure the accuracy of the information supplied herein, Universiti Teknologi Malaysia cannot be held responsible for any errors or omissions.