CSCI235 Database Systems Assignment 1 2026 | University of Wollongong

CSCI235 Database Systems

Assignment 1 (10% of total marks)

Scope:

The tasks of this assignment cover functional dependency and indexing. The assignment covers the topics discussed in lecture 1, 2, and 3.

Assessment criteria:

Marks will be awarded for:

• Correct,
• Comprehensive, and
• Appropriate

application of the materials covered in this subject.

Assignment Specification:

Task 1 (2.0 marks)

Analysis of relational schemas

Consider the specifications of the sample database domains and the respective relational tables given below. For each one of the database domains listed below discover the respective sets of valid functional dependencies in the tables. For each one of the relational schemas identify its highest normal form. Remember that identification of a normal form requires analysis of the valid functional dependencies and the minimal keys. Provide justification of each answer. A solution with no comprehensive justification scores no marks.

a. A building of a newly constructed wall-climbing gym has two levels. Level 1 consists of three different walls; each wall is identified as wall 1, wall 2, and wall 3. Level 2 consists of one wall, and it is identified as wall 1. Walls at level 1 are designed for easy and intermediate climbing, while wall at level 2 is designed for expert level of climbing. To promote this sport, the organizer organizes demonstration sessions inviting public for viewing. The number of places available for booking to view the demonstration are recorded in order not to overcrowd the gym during demonstration. Information such as level number, wall number, places available for booking, and the type of demonstration (easy, intermediate, and expert) are stored in the following relational table.

WallClimbDemo (LevelNum, WallNum, PlaceAvailable, DemoType)
(0.5 mark)