This unit introduces fundamental concepts and principles of database and explains its role and purpose in information system design and analysis. Students gain mastery of standard techniques to identify system requirements and design a simple database system. Content includes: systems concepts; role of the analyst; Systems Development Life Cycle (SDLC), process modelling, Entity-Relationship (ER) modelling; relational database design using ER and Extended ER modelling, SQL (Structured Query Language), normalisation; and database management systems (DBMS).
On successful completion of this unit, students will be able to:
This unit is studied as part of the following course(s):