Singapore University of Social Sciences

Database Systems: Implementation and Administration (ICT322)

Applications Open: To be confirmed

Applications Close: To be confirmed

Next Available Intake: To be confirmed

Course Types: Modular Undergraduate Course

Language: English

Duration: 6 months

Fees: To be confirmed

Area of Interest: Science & Technology

Schemes: To be confirmed

Funding: To be confirmed


Synopsis

This course covers the use of SQL in constructing a new database and in redesigning existing databases. It touches on database administration issues in the context of a multi-user processing environment. SQL Server will be used as the DBMS tool to examine some of the database administration techniques.

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

Topics

  • Construct the database given the logical model
  • Implement business rules via views, stored procedures and triggers
  • Assess, plan and redesign the existing database
  • Demonstrate the basic techniques of concurrency control and (ACID
  • Recommend database security and recovery measures
  • Formulate SQL statements to create and manage table structures and views
  • Create triggers and stored procedures
  • Apply changes to existing databases

Learning Outcome

  • Construct the database given the logical model
  • Implement business rules via views, stored procedures and triggers
  • 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