Singapore University of Social Sciences

Database Systems: Modelling and Design

Database Systems: Modelling and Design (ICT321)

Synopsis

This course offers perspectives on relational databases, based on the storage of data as tables. It highlights the use of databases in key organisational information systems. There is in depth coverage of data modelling and the theory of relations as applied to the representation of models of data. The practical use of the database language SQL will be extensively covered, using MySQL.

Level: 3
Credit Units: 5
Presentation Pattern: Every July

Topics

  • Introduction to Databases and SQL
  • The Relational Model and Normalisation
  • Database Design Using Normalisation
  • Data Modelling with the ER Model
  • Transforming Data Models into Database Designs

Learning Outcome

  • Apply database processing concepts to solve the information requirements of organizations
  • Compose the appropriate SQL code to perform queries on a relational database
  • Analyse the data requirements to design databases for new information systems
  • Assess the Logical Model for modification anomalies
  • Solve common design problems
  • Formulate SQL code, including those requiring calculation functions, to query database
  • Design a relational database based on the RM principles
  • Construct conceptual (ER) and logical models from a statement of requirements
Part-time Programmes / CET Courses
Back to top

This site uses cookies to offer you a better browsing experience. By continuing to navigate through this site or by clicking “Close”, you are consenting to the use of cookies on your device as described in our privacy policy.

Close
Follow us on
Alumni
Back to top