Database Systems

Section outline

• Select section General

  General

  Collapse all Expand all

  • Select activity Announcements

    

    Announcements Forum
  • Select activity LIVE CLASS

    

    LIVE CLASS External tool
  • Select activity COURSE OUTLINE

    

    COURSE OUTLINE File
  • Select activity COURSEWORK TWO TAKEHOME ASSIGNMENT

    

    COURSEWORK TWO TAKEHOME ASSIGNMENT

    Opened: Wednesday, 23 October 2024, 12:00 AM

    Due: Saturday, 26 October 2024, 11:59 PM

    Your assignment must be uploaded to the MUBSEP system by 26th October 2024. Each student is required to scan any hand-drawn diagrams and compile all answers (only SQL statements), including diagrams, into a single PDF document. A printed version of this document must also be submitted in class on the presentation day, 28th October 2024, for assessment. Please note that the submission of both the digital and printed versions is mandatory for the completion of this coursework.

• Select section Topic 1

  Topic 1

  • Select activity Introduction to Database Systems

    

    Introduction to Database Systems File
• Select section Topic 2

  Topic 2

  • Select activity Data Modeling and ERDS

    

    Data Modeling and ERDS File
• Select section Topic 3

  Topic 3

  • Select activity Introduction to SQL

    

    Introduction to SQL URL
• Select section Topic 4

  Topic 4

  • Select activity Retrieving Data - SELECT Clause

    

    Retrieving Data - SELECT Clause URL
• Select section Topic 5

  Topic 5

  • Select activity Sorting Retrieve Data - ORDER BY Clause

    

    Sorting Retrieve Data - ORDER BY Clause URL
• Select section Topic 6

  Topic 6

  • Select activity Limiting Retrieved Data - WHERE Clause

    

    Limiting Retrieved Data - WHERE Clause URL
• Select section Topic 7

  Topic 7

  • Select activity Single Row Functions

    

    Single Row Functions URL
• Select section Topic 8

  Topic 8

  • Select activity Group Functions

    

    Group Functions URL
• Select section Topic 9

  Topic 9

  • Select activity Joins

    

    Joins URL
• Select section Topic 10

  Topic 10

  • Select activity Creating Tables

    

    Creating Tables URL
• Select section Topic 11

  Topic 11

  • Select activity Modifying Tables

    

    Modifying Tables URL
• Select section Topic 12

  Topic 12

  • Select activity Data Manipulation

    

    Data Manipulation URL