Courses / Module

On successful completion of the module, students should be able to:

• Identify major Database Management Systems (DBMS) functions and describe their role in a database system
• Design a relational schema from a conceptual model developed using the entity-relationship model
• Demonstrate the creation of databases from external data sources such as files
• Explain and demonstrate the concepts of entity integrity constraints and referential integrity constraints
• Demonstrate queries in relational algebra
• Use a declarative query language (SQL) to extract information from a database
• Demonstrate use of SQL to work with many different data types (strings, timestamps, numerical, etc) in large databases
• Explain the concepts of database security in the context of web-based database applications.

Delivery methods	Hours
Lectures	24
Labs / Practicals	24
Tutorials	0
Planned learning activities	0
Independent student activities	77
Total	125

• Module Graded (numeric value) or Ungraded (Pass/Not Passed): Graded

Assessment type	Weighting	Duration
Continuous Assessment	100%
University scheduled written examination	0%
Other	0%
Total	100%

• Pass standard: 40%

• Are Supplemental registrations permitted? Yes
• Resit mark is by supplemental CA (completed online if necessary) capped at 50%.
• Is Supplemental Continuous Assessment registration permitted? Yes
• Is Supplemental Continuous Assessment capped? Yes

For a full timetable search, go to NUIM Timetable. Venue locations can be found here.