SEEM3550/ ESTR3506 Fundamentals in Information Systems

Course Code and Name: SEEM3550 Fundamentals in Information Systems
Course Objectives:

Basic elements of information systems, their concepts and interrelations. Database systems: database models, relational database, database application programming. Information retrieval: models, indexing, performance evaluation. Expert systems: knowledge and data engineering, expert system shell, application studies.

Course Outcomes:

1. Able to perform conceptual database design using Entity Relationship Diagram (ERD).

2. Able to perform logical database design by transforming a ERD to a relational database table

3. Learn how a relational database table are maintained on secondary disk storage,

Programme Outcomes:
(P1) The ability to apply knowledge of mathematics, science, and engineering appropriate to the degree discipline (K/S)
(P2) The ability to design and conduct experiments, as well as to analyze and interpret data (K/S)
(P3) The ability to design a system, component, or process to meet desired needs within realistic constraints, such as economic, environmental, social, political, ethical, health and safety, manufacturability and sustainability (K/S)
(P4) The ability to function in multi-disciplinary teams (S/V)
(P5) The ability to identify, formulate, and solve engineering problems (K/S)
(P6) The understanding of professional and ethical responsibility (V)
(P7) The ability to communicate effectively (S)
(P8) The ability to understand the impact of engineering solutions in a global and societal context, especially the importance of health, safety and environmental considerations to both workers and the general public (V)
(P9) The ability to recognize the need for, and to engage in life-long learning (V)
(P10) The ability to stay abreast of contemporary issues (S/V)
(P11) The ability to use the techniques, skills, and modern engineering tools necessary for engineering practice appropriate to the degree discipline (K/S)
(P12) The ability to use the computer/IT tools relevant to the discipline along with an understanding of their processes and limitations (K/S/V)
(P13) The ability to apply the skills relevant to the discipline of operations research and information technology and their applications in engineering and managerial decision making, especially in financial services, logistics and supply chain management, business information systems, and service engineering and management (K/S)

K = Knowledge outcomes
S = Skills outcomes
V = Values and attitude outcomes
Weights (in %):
Course Outcome(s) is/are measurable or not: Yes / Yes (Partial) / No (Please choose).
If Yes, please suggest ways to measure:

(P1) Students are given 3 assignments to teach them how to apply their knowledge to practical problems. The assignments contribute to 15% of the scores in the course.

(P3) Students have to do a database design project, which contributes to 35% of the scores in the course.

(P5) The database design project is divided into 3 phases: function design (10%), database design (10%) and implementation (15%). Students are requested to apply what they have learnt in class to a real problem.

(P11) Entity Relationship Diagram (ERD) is used for phases 1 and 2; and Oracle Database System is used for phase 3.

(P13) During the project, students learnt how to deign and implement under the application constraints. Their outcomes of each phase are separately evaluated.