SYNOPSIS [Notes]
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 modelling the information for develop DBMS related to civil engineering problems.
COURSE LEARNING OUTCOMES
By the end of the course, students should be able to :
| Course Learning Outcomes, CO | PO* | CP* | CA* | KP* | Bloom’s | Assessm. | ||
| Taxonomy | Methods | |||||||
| Explain system analysis concept, information | ||||||||
| CO1 | management system and basic knowledge | PO1 | L1 | A, T, F | ||||
| management. | ||||||||
| Analysethe work of process related to civil | ||||||||
| CO2 | engineering problem by using Data Flow | PO2 | KP8 | L4 | A, T, F | |||
| Diagram. | ||||||||
| CO3 | Develop information model by using Entity | PO3 | L3 | F | ||||
| Relationship Diagram. | ||||||||
| Identify relevant information to produce | ||||||||
| CO4 | database management system using computer | PO8 | CP4 | CA1 | L6 | Pr | ||
| software. | ||||||||
*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
STUDENT LEARNING TIME
| No. | Teaching and Learning Activities | SLT* (hours) |
| 1. | Face-to-Face Learning | |
| a. Lecturer-Centered Learning (SCL) | ||
| i. Lecture | 28 | |
| b. Student-Centered Learning (SCL) | ||
| i. Laboratory / Tutorial | – | |
| ii. Student-centered learning activities – Active Learning, Project Based – Learning | – |
| 2. | Self-Directed Learning | |
| Non-face-to-face learning or student-centered learning (SCL) such as manual, | ||
| a. Assignment, module, e-Learning, etc. | 26 | |
| b. Revision | 14 | |
| c. Assessment Preparations | 8 | |
| 3. | Formal Assessment | |
| a. Continuous Assessment | 2 | |
| b. Final Exam | 2 | |
| Total Student Learning Time* (SLT) | 80 | |
TEACHING METHODOLOGY
- Lecture
- Demonstration of software
- Assignment and discussion in class
- Project and presentation
WEEKLYSCHEDULE
| Week | Lecture | Topic / Content | |
| 1 | Introduction to the course | ||
| 1 | Information Management | ||
| 2 | The role of information in the construction | ||
| Why bother managing information | |||
| 3 | Information in the construction industry | ||
| Project co-ordination, the needs and benefits | |||
| Project information and Information Technology (IT) | |||
| 2 | 4 | Managing the flow of information | |
| The role of IT for managing the information | |||
| System Development Live Cycle (SDLC) | |||
| Assignment 1 | |||
| 5 | Information Modelling Approach | ||
| The need for information modelling | |||
| 3 | Activity/process modelling | ||
| Data modelling | |||
| 6 | |||
| Data Flow Diagram Diagram (DFD) | |||
| Introduction & basic terminology and review | |||
| 7 | Levelling a DFD – scope, level and input/output | ||
| 4 | Levelling a DFD – level of details & numbering the bubbles Drawing a DFD, steps to | ||
| 8 | follow | ||
| 5 | 9 | Case study of a system | |
| 10 | Assignment 2 | ||
| 11 | Introduction to database | ||
| 6 | Data and information | ||
| 12 | Methods of storing data manually and computerised | ||
| Database management system (DBMS) |
| 13 | Entity-Relationship Diagrams | ||
| Entity-Relationship analysis | |||
| 7 | 14 | Data analysis & conceptual modelling | |
| ERD modelling, terminology, ERD structures | |||
| Test | |||
| 8 | MID SEMESTER BREAK | ||
| 15 | More about E-R analysis | ||
| Attributes and modelling relationship cardinality | |||
| 9 | Building an ERD | ||
| 16 | Each set to model one concept | ||
| Choosing attributes | |||
| Choosing object set names | |||
| An analysis sequence | |||
| 17 | Case-study – using an ERD | ||
| 10 | 18 | ERD and DFD | |
| Reducing ERD into tables | |||
| 19 | Prototyping | ||
| The importance of a prototype | |||
| 11 | 20 | Building and evaluate a prototype | |
| Develop test plan | |||
| Mapping | |||
| Project | |||
| 21 | Introduction to Microsoft Access | ||
| 12 | MS Access environment and build the table | ||
| 22 | Relationship between ERD and Access | ||
| Query | |||
| 23 | Form and Report | ||
| 13 | 24 | Macro | |
| Compile the Access works | |||
| 14 | 25 | System Implementation and System Maintenance Convert to the new system | |
| 26 | Create user documents | ||
| 15 | 27 | Past year examination questions discussion | |
| 28 | Syllabus Review and Discussion | ||
| 16-18 | REVISION WEEK AND FINAL EXAMINATION |
REFERENCES
- 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.
- Kendall KE and Kendal JE , Systems Analysis and Design, Prentice-Hall Inc., 1992
- McFadden FR and Hoffer JA, Modern Database Management, 4ht Edition, The Benjamin/Cummings Inc 1993
- Connolly T, Begg C and Strachan A, Database Systems, Addison-Wesley, 1996.
- Dewitz SD, “Systems Analysis and Design and the Transition to Objects”, McGraw Hill, 1996.
- .Edwards P, “Systems Analysis and Design”, Mitchell Publishing, Inc, McGrawHill, 1993.
- Pratt PJ and Adamski JJ, The Concept of Database management, 2nd Edition, Course Technology Inc., 1997.
- Pratt PJ and Leidig PM, Microcomputer Database Management using Microsoft Access, Boyd & Fraser Publishing Co, 1995
DISTRIBUTION OF MARKS
| No. | Assessment | Number | % each | % total | Weeks | |
| 1. | Assignment and Project | 2 | 10 | 20 | Week 2 & 5 | |
| 2. | Test | 1 | 15 | 15 | Week 7 | |
| 3. | Project | 1 | 15 | 15 | Week 11 | |
| 4. | Final Examination | 1 | 50 | 50 | ||
| Overall | 100 | |||||
| Total | ||||||
ATTENDANCE
The student should adhere to the rules of attendance as stated in the University Academic Regulation :-
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 be given to the subject.
