{"id":452,"date":"2016-06-30T13:10:51","date_gmt":"2016-06-30T05:10:51","guid":{"rendered":"https:\/\/people.utm.my\/mohdzamri\/?page_id=452"},"modified":"2020-02-05T21:37:13","modified_gmt":"2020-02-05T13:37:13","slug":"skaa4412","status":"publish","type":"page","link":"https:\/\/people.utm.my\/mohdzamri\/skaa4412\/","title":{"rendered":"Civil Engineering Information System (SKAA4412)"},"content":{"rendered":"<p><strong>SYNOPSIS \u00a0 \u00a0<a href=\"https:\/\/people.utm.my\/mohdzamri\/ceis\/\">[Notes]<\/a><\/strong><\/p>\n<p><a href=\"https:\/\/people.utm.my\/mohdzamri\/notes-skaa-4412\/\">Notes for my Students Only<\/a><\/p>\n<p>This course is designed to expose the students in analysing, designing and developing the huge of data. It concerns on the management of information and how to model it in a structured manner. The used of Database Management System (DBMS) as an application tool give the student a further step in order to apply an IT application in solving their problems. This course also exposes the knowledge on the usage, management and sharing of data and information to ensure that information is manipulated and used effectively. The introduction of Knowledge Management also has been introduced. At the end of the course, students should be able to plan, analyse, and\u00a0modelling the information for develop DBMS related to civil engineering problems.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>COURSE LEARNING OUTCOMES<\/strong><\/p>\n<p>By the end of the course, students should be able to :<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"43\"><\/td>\n<td rowspan=\"2\" width=\"252\"><strong>Course Learning Outcomes, CO<\/strong><\/td>\n<td rowspan=\"2\" width=\"49\"><strong>PO*<\/strong><\/td>\n<td rowspan=\"2\" width=\"43\"><strong>CP*<\/strong><\/td>\n<td rowspan=\"2\" width=\"48\"><strong>CA*<\/strong><\/td>\n<td rowspan=\"2\" width=\"41\"><strong>KP*<\/strong><\/td>\n<td width=\"69\"><strong>Bloom\u2019s<\/strong><\/td>\n<td width=\"60\"><strong>Assessm.<\/strong><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"43\"><\/td>\n<td width=\"69\"><strong>Taxonomy<\/strong><\/td>\n<td width=\"60\"><strong>Methods<\/strong><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"43\"><\/td>\n<td width=\"252\"><\/td>\n<td width=\"49\"><\/td>\n<td width=\"43\"><\/td>\n<td width=\"48\"><\/td>\n<td width=\"41\"><\/td>\n<td width=\"69\"><\/td>\n<td width=\"60\"><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"43\"><\/td>\n<td width=\"252\"><strong>Explain <\/strong>system analysis concept, information<\/td>\n<td width=\"49\"><\/td>\n<td width=\"43\"><\/td>\n<td width=\"48\"><\/td>\n<td width=\"41\"><\/td>\n<td width=\"69\"><\/td>\n<td width=\"60\"><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"43\">CO1<\/td>\n<td width=\"252\">management system and basic knowledge<\/td>\n<td width=\"49\">PO1<\/td>\n<td width=\"43\"><\/td>\n<td width=\"48\"><\/td>\n<td width=\"41\"><\/td>\n<td width=\"69\">L1<\/td>\n<td width=\"60\">A, T, F<\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"43\"><\/td>\n<td width=\"252\">management.<\/td>\n<td width=\"49\"><\/td>\n<td width=\"43\"><\/td>\n<td width=\"48\"><\/td>\n<td width=\"41\"><\/td>\n<td width=\"69\"><\/td>\n<td width=\"60\"><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"43\"><\/td>\n<td width=\"252\"><strong>Analyse<\/strong>the work of process related to civil<\/td>\n<td width=\"49\"><\/td>\n<td width=\"43\"><\/td>\n<td width=\"48\"><\/td>\n<td width=\"41\"><\/td>\n<td width=\"69\"><\/td>\n<td width=\"60\"><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"43\">CO2<\/td>\n<td width=\"252\">engineering problem by using Data Flow<\/td>\n<td width=\"49\">PO2<\/td>\n<td width=\"43\"><\/td>\n<td width=\"48\"><\/td>\n<td width=\"41\">KP8<\/td>\n<td width=\"69\">L4<\/td>\n<td width=\"60\">A, T, F<\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"43\"><\/td>\n<td width=\"252\">Diagram.<\/td>\n<td width=\"49\"><\/td>\n<td width=\"43\"><\/td>\n<td width=\"48\"><\/td>\n<td width=\"41\"><\/td>\n<td width=\"69\"><\/td>\n<td width=\"60\"><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"43\">CO3<\/td>\n<td width=\"252\"><strong>Develop <\/strong>information model by using Entity<\/td>\n<td rowspan=\"2\" width=\"49\">PO3<\/td>\n<td width=\"43\"><\/td>\n<td width=\"48\"><\/td>\n<td width=\"41\"><\/td>\n<td rowspan=\"2\" width=\"69\">L3<\/td>\n<td rowspan=\"2\" width=\"60\">F<\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"252\">Relationship Diagram.<\/td>\n<td width=\"43\"><\/td>\n<td width=\"48\"><\/td>\n<td width=\"41\"><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"43\"><\/td>\n<td width=\"252\"><strong>Identify <\/strong>relevant information to produce<\/td>\n<td width=\"49\"><\/td>\n<td width=\"43\"><\/td>\n<td width=\"48\"><\/td>\n<td width=\"41\"><\/td>\n<td width=\"69\"><\/td>\n<td width=\"60\"><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"43\">CO4<\/td>\n<td width=\"252\">database management system using computer<\/td>\n<td width=\"49\">PO8<\/td>\n<td width=\"43\">CP4<\/td>\n<td width=\"48\">CA1<\/td>\n<td width=\"41\"><\/td>\n<td width=\"69\">L6<\/td>\n<td width=\"60\">Pr<\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"43\"><\/td>\n<td width=\"252\">software.<\/td>\n<td width=\"49\"><\/td>\n<td width=\"43\"><\/td>\n<td width=\"48\"><\/td>\n<td width=\"41\"><\/td>\n<td width=\"69\"><\/td>\n<td width=\"60\"><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"43\"><\/td>\n<td width=\"252\"><\/td>\n<td width=\"49\"><\/td>\n<td width=\"43\"><\/td>\n<td width=\"48\"><\/td>\n<td width=\"41\"><\/td>\n<td width=\"69\"><\/td>\n<td width=\"60\"><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>*Note : PO: Program Outcomes; CP: Complex Problems; CA: Complex Activities; KP: Knowledge Profiles A: Assignment; Pr: Project; Q: Quiz; HW: Homework; P: Presentation; T: Test; F: Final Exam; R: Report<\/p>\n<p>&nbsp;<\/p>\n<p><strong>STUDENT LEARNING TIME<\/strong><strong>\u00a0<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"56\"><strong>No.<\/strong><\/td>\n<td width=\"447\"><strong>Teaching and Learning Activities<\/strong><\/td>\n<td width=\"107\"><strong>SLT* (hours)<\/strong><\/td>\n<\/tr>\n<tr>\n<td rowspan=\"6\" width=\"56\">1.<\/td>\n<td width=\"447\">Face-to-Face Learning<\/td>\n<td width=\"107\"><\/td>\n<\/tr>\n<tr>\n<td width=\"447\">a.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Lecturer-Centered Learning (SCL)<\/td>\n<td width=\"107\"><\/td>\n<\/tr>\n<tr>\n<td width=\"447\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 i.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Lecture<\/td>\n<td width=\"107\">28<\/td>\n<\/tr>\n<tr>\n<td width=\"447\">b.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Student-Centered Learning (SCL)<\/td>\n<td width=\"107\"><\/td>\n<\/tr>\n<tr>\n<td width=\"447\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 i.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Laboratory \/ Tutorial<\/td>\n<td width=\"107\">&#8211;<\/td>\n<\/tr>\n<tr>\n<td width=\"447\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ii.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Student-centered learning activities \u2013 Active Learning, Project Based &#8211; Learning<\/td>\n<td width=\"107\">&#8211;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table style=\"width: 630px\">\n<tbody>\n<tr style=\"height: 16px\">\n<td style=\"height: 16px;width: 56px\"><\/td>\n<td style=\"height: 16px;width: 447px\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 304px;width: 56px\" rowspan=\"5\">2.<\/td>\n<td style=\"height: 56px;width: 447px\">Self-Directed Learning<\/td>\n<td style=\"height: 56px;width: 107px\"><\/td>\n<\/tr>\n<tr style=\"height: 80px\">\n<td style=\"height: 80px;width: 447px\">Non-face-to-face learning or student-centered learning (SCL) such as manual,<\/td>\n<td style=\"height: 80px;width: 107px\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px;width: 447px\">a.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Assignment, module, e-Learning, etc.<\/td>\n<td style=\"height: 56px;width: 107px\">26<\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px;width: 447px\">b.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Revision<\/td>\n<td style=\"height: 56px;width: 107px\">14<\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px;width: 447px\">c.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Assessment Preparations<\/td>\n<td style=\"height: 56px;width: 107px\">8<\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 168px;width: 56px\" rowspan=\"3\">3.<\/td>\n<td style=\"height: 56px;width: 447px\">Formal Assessment<\/td>\n<td style=\"height: 56px;width: 107px\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px;width: 447px\">a.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Continuous Assessment<\/td>\n<td style=\"height: 56px;width: 107px\">2<\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px;width: 447px\">b.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Final Exam<\/td>\n<td style=\"height: 56px;width: 107px\">2<\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px;width: 503px\" colspan=\"2\"><strong>Total Student Learning Time* (SLT)<\/strong><\/td>\n<td style=\"height: 56px;width: 107px\"><strong>80<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>TEACHING METHODOLOGY<\/strong><\/p>\n<ol>\n<li>Lecture<\/li>\n<\/ol>\n<ol start=\"2\">\n<li>Demonstration of software<\/li>\n<\/ol>\n<ol start=\"3\">\n<li>Assignment and discussion in class<\/li>\n<\/ol>\n<ol start=\"4\">\n<li>Project and presentation<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><strong>WEEKLYSCHEDULE<\/strong><\/p>\n<table width=\"605\">\n<tbody>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><strong>Week<\/strong><\/td>\n<td style=\"height: 56px\" width=\"72\"><strong>Lecture<\/strong><\/td>\n<td style=\"height: 56px\" width=\"463\"><strong>Topic \/ Content<\/strong><\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\">1<\/td>\n<td style=\"height: 56px\" width=\"463\"><strong>Introduction to the course<\/strong><\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 112px\" rowspan=\"2\" width=\"68\">1<\/td>\n<td style=\"height: 56px\" width=\"72\"><\/td>\n<td style=\"height: 56px\" width=\"463\"><strong>Information Management<\/strong><\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 112px\" rowspan=\"2\" width=\"72\">2<\/td>\n<td style=\"height: 112px\" rowspan=\"2\" width=\"463\">The role of information in the construction<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\"><\/td>\n<td style=\"height: 56px\" width=\"463\">Why bother managing information<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\">3<\/td>\n<td style=\"height: 56px\" width=\"463\">Information in the construction industry<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\"><\/td>\n<td style=\"height: 56px\" width=\"463\">Project co-ordination, the needs and benefits<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\"><\/td>\n<td style=\"height: 56px\" width=\"463\">Project information and Information Technology (IT)<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\">2<\/td>\n<td style=\"height: 56px\" width=\"72\">4<\/td>\n<td style=\"height: 56px\" width=\"463\">Managing the flow of information<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\"><\/td>\n<td style=\"height: 56px\" width=\"463\">The role of IT for managing the information<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\"><\/td>\n<td style=\"height: 56px\" width=\"463\">System Development Live Cycle (SDLC)<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\"><\/td>\n<td style=\"height: 56px\" width=\"463\"><strong><em>Assignment 1<\/em><\/strong><\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\">5<\/td>\n<td style=\"height: 56px\" width=\"463\"><strong>Information Modelling Approach<\/strong><\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\"><\/td>\n<td style=\"height: 56px\" width=\"463\">The need for information modelling<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 112px\" rowspan=\"2\" width=\"68\">3<\/td>\n<td style=\"height: 56px\" width=\"72\"><\/td>\n<td style=\"height: 56px\" width=\"463\">Activity\/process modelling<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"72\"><\/td>\n<td style=\"height: 112px\" rowspan=\"2\" width=\"463\">Data modelling<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 112px\" rowspan=\"2\" width=\"72\">6<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"463\"><strong>Data Flow Diagram Diagram (DFD)<\/strong><\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\"><\/td>\n<td style=\"height: 56px\" width=\"463\">Introduction &amp; basic terminology and review<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\">7<\/td>\n<td style=\"height: 56px\" width=\"463\">Levelling a DFD \u2013 scope, level and input\/output<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 80px\">\n<td style=\"height: 80px\" width=\"68\">4<\/td>\n<td style=\"height: 80px\" width=\"72\"><\/td>\n<td style=\"height: 80px\" width=\"463\">Levelling a DFD \u2013 level of details &amp; numbering the bubbles Drawing a DFD, steps to<\/td>\n<td style=\"height: 80px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\">8<\/td>\n<td style=\"height: 56px\" width=\"463\">follow<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 112px\" rowspan=\"2\" width=\"68\">5<\/td>\n<td style=\"height: 56px\" width=\"72\">9<\/td>\n<td style=\"height: 56px\" width=\"463\">Case study of a system<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 112px\" rowspan=\"2\" width=\"72\">10<\/td>\n<td style=\"height: 112px\" rowspan=\"2\" width=\"463\">Assignment 2<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\">11<\/td>\n<td style=\"height: 56px\" width=\"463\">Introduction to database<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 112px\" rowspan=\"2\" width=\"68\">6<\/td>\n<td style=\"height: 56px\" width=\"72\"><\/td>\n<td style=\"height: 56px\" width=\"463\">Data and information<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 112px\" rowspan=\"2\" width=\"72\">12<\/td>\n<td style=\"height: 112px\" rowspan=\"2\" width=\"463\">Methods of storing data manually and computerised<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<tr style=\"height: 56px\">\n<td style=\"height: 56px\" width=\"68\"><\/td>\n<td style=\"height: 56px\" width=\"72\"><\/td>\n<td style=\"height: 56px\" width=\"463\">Database management system (DBMS)<\/td>\n<td style=\"height: 56px\" width=\"2\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table width=\"606\">\n<tbody>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\"><\/td>\n<td width=\"1\"><strong>\u00a0<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\">13<\/td>\n<td width=\"463\"><strong>Entity-Relationship Diagrams<\/strong><\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\">Entity-Relationship analysis<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\">7<\/td>\n<td width=\"75\">14<\/td>\n<td width=\"463\">Data analysis &amp; conceptual modelling<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\">ERD modelling, terminology, ERD structures<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\"><strong><em>Test<\/em><\/strong><\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\">8<\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\"><strong><em>MID SEMESTER BREAK<\/em><\/strong><\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\">15<\/td>\n<td width=\"463\">More about E-R analysis<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\">Attributes and modelling relationship cardinality<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\">9<\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\">Building an ERD<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\">16<\/td>\n<td width=\"463\">Each set to model one concept<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\">Choosing attributes<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\">Choosing object set names<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\">An analysis sequence<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\">17<\/td>\n<td width=\"463\">Case-study \u2013 using an ERD<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\">10<\/td>\n<td width=\"75\">18<\/td>\n<td width=\"463\">ERD and DFD<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\">Reducing ERD into tables<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\">19<\/td>\n<td width=\"463\"><strong>Prototyping<\/strong><\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\">The importance of a prototype<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"66\">11<\/td>\n<td width=\"75\">20<\/td>\n<td width=\"463\">Building and evaluate a prototype<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"75\"><\/td>\n<td rowspan=\"2\" width=\"463\">Develop test plan<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\">Mapping<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\"><strong><em>Project<\/em><\/strong><\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\">21<\/td>\n<td width=\"463\"><strong>Introduction to Microsoft Access<\/strong><\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"66\">12<\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\">MS Access environment and build the table<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"75\">22<\/td>\n<td rowspan=\"2\" width=\"463\">Relationship between ERD and Access<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\">Query<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\">23<\/td>\n<td width=\"463\">Form and Report<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\">13<\/td>\n<td width=\"75\">24<\/td>\n<td width=\"463\">Macro<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\">Compile the Access works<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"66\">14<\/td>\n<td width=\"75\">25<\/td>\n<td width=\"463\">System Implementation and System Maintenance Convert to the new system<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"75\">26<\/td>\n<td rowspan=\"2\" width=\"463\">Create user documents<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"66\">15<\/td>\n<td width=\"75\">27<\/td>\n<td width=\"463\">Past year examination questions discussion<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"75\">28<\/td>\n<td rowspan=\"2\" width=\"463\">Syllabus Review and Discussion<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\"><\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td width=\"66\">16-18<\/td>\n<td width=\"75\"><\/td>\n<td width=\"463\">REVISION WEEK AND FINAL EXAMINATION<\/td>\n<td width=\"1\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>REFERENCES<\/strong><\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li>L. (1990), Information Management of Construction Projects (Draft), Published by T. W. Crow Associates and Crow Maunsell Pty. Ltd. Management and Project Consultants, Sydney, Australia, ISBN: 0 7316 8420 6.<\/li>\n<li>Kendall KE and Kendal JE , Systems Analysis and Design, Prentice-Hall Inc., 1992<\/li>\n<li>McFadden FR and Hoffer JA, Modern Database Management, 4ht Edition, The Benjamin\/Cummings Inc 1993<\/li>\n<li>Connolly T, Begg C and Strachan A, Database Systems, Addison-Wesley, 1996.<\/li>\n<li>Dewitz SD, \u201cSystems Analysis and Design and the Transition to Objects\u201d, McGraw Hill, 1996.<\/li>\n<li>.Edwards P, \u201cSystems Analysis and Design\u201d, Mitchell Publishing, Inc, McGrawHill, 1993.<\/li>\n<li>Pratt PJ and Adamski JJ, The Concept of Database management, 2nd Edition, Course Technology Inc., 1997.<\/li>\n<li>Pratt PJ and Leidig PM, Microcomputer Database Management using Microsoft Access, Boyd &amp; Fraser Publishing Co, 1995<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><strong>DISTRIBUTION OF MARKS<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"59\"><strong>No.<\/strong><\/td>\n<td width=\"177\"><strong>Assessment<\/strong><\/td>\n<td width=\"83\"><strong>Number<\/strong><\/td>\n<td width=\"72\"><strong>% each<\/strong><\/td>\n<td width=\"95\"><strong>% total<\/strong><\/td>\n<td width=\"101\"><strong>Weeks<\/strong><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"59\">1.<\/td>\n<td width=\"177\">Assignment and Project<\/td>\n<td width=\"83\">2<\/td>\n<td width=\"72\">10<\/td>\n<td width=\"95\">20<\/td>\n<td width=\"101\">Week 2 &amp; 5<\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"59\">2.<\/td>\n<td width=\"177\">Test<\/td>\n<td width=\"83\">1<\/td>\n<td width=\"72\">15<\/td>\n<td width=\"95\">15<\/td>\n<td width=\"101\">Week 7<\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"59\">3.<\/td>\n<td width=\"177\">Project<\/td>\n<td width=\"83\">1<\/td>\n<td width=\"72\">15<\/td>\n<td width=\"95\">15<\/td>\n<td width=\"101\">Week 11<\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"59\">4.<\/td>\n<td width=\"177\">Final Examination<\/td>\n<td width=\"83\">1<\/td>\n<td width=\"72\">50<\/td>\n<td width=\"95\">50<\/td>\n<td width=\"101\"><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"59\"><strong>Overall<\/strong><\/td>\n<td width=\"177\"><\/td>\n<td width=\"83\"><\/td>\n<td width=\"72\"><\/td>\n<td rowspan=\"2\" width=\"95\"><strong>100<\/strong><\/td>\n<td width=\"101\"><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"59\"><strong>Total<\/strong><\/td>\n<td width=\"177\"><\/td>\n<td width=\"83\"><\/td>\n<td width=\"72\"><\/td>\n<td width=\"101\"><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"177\"><\/td>\n<td width=\"83\"><\/td>\n<td width=\"72\"><\/td>\n<td width=\"95\"><\/td>\n<td width=\"101\"><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<tr>\n<td width=\"59\"><\/td>\n<td width=\"177\"><\/td>\n<td width=\"83\"><\/td>\n<td width=\"72\"><\/td>\n<td width=\"95\"><\/td>\n<td width=\"101\"><\/td>\n<td width=\"0\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>ATTENDANCE<\/strong><\/p>\n<p>The student should adhere to the rules of attendance as stated in the University Academic Regulation :-<\/p>\n<p>Student must attend not less than 80% of lecture hours as required for the subject.The student will be prohibited from attending any lecture and assessment activities upon failure to comply the above requirement. Zero mark will\u00a0be given to the subject.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SYNOPSIS \u00a0 \u00a0[Notes] Notes for my Students Only This course is designed to expose the students in analysing, designing and developing the huge of data. It concerns on the management of information and how to model it in a structured manner. The used of Database Management System (DBMS) as an application tool give the student [&hellip;]<\/p>\n","protected":false},"author":16174,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-452","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/people.utm.my\/mohdzamri\/wp-json\/wp\/v2\/pages\/452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.utm.my\/mohdzamri\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/people.utm.my\/mohdzamri\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/people.utm.my\/mohdzamri\/wp-json\/wp\/v2\/users\/16174"}],"replies":[{"embeddable":true,"href":"https:\/\/people.utm.my\/mohdzamri\/wp-json\/wp\/v2\/comments?post=452"}],"version-history":[{"count":1,"href":"https:\/\/people.utm.my\/mohdzamri\/wp-json\/wp\/v2\/pages\/452\/revisions"}],"predecessor-version":[{"id":5342,"href":"https:\/\/people.utm.my\/mohdzamri\/wp-json\/wp\/v2\/pages\/452\/revisions\/5342"}],"wp:attachment":[{"href":"https:\/\/people.utm.my\/mohdzamri\/wp-json\/wp\/v2\/media?parent=452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}