Singapore University of Social Sciences

Database Systems: Modelling and Design

Applications Open: To be confirmed

Applications Close: To be confirmed

Next Available Intake: To be confirmed

Schemes: To be confirmed

Language: English

Duration: 6 months

Fees: To be confirmed

Area of Interest: To be confirmed


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
Back to top
Back to top