TIL

TIL

  • Docs
  • Contact
  • Feedback
  • Contribute

›Week 5

Getting Started

  • Introduction

Principles of Programming Languages

    Week 3

    • Pattern Matching and Recursive Data Types

    Week 8

    • Monads

Introduction to Databases

    Week 3

    • Cinema Database

    Week 4

    • Pine Valley Furniture
    • Pine Valley Furniture - Solution

    Week 5

    • ERD to Shorthand Conversions
    • ERD to Shorthand Conversions - Solution

    Week 6

    • Normalizations
    • Normalizations - Solutions

    Week 7

    • Other Normal Forms
    • Other Normal Forms - Solutions

    Week 8

    • SQL Introduction

    Week 9

    • More SQL

    Week 10

    • Joins and Subqueries

    Week 11

    • Functions, Procedures, Triggers and Embedded SQL

    Week 12

    • Prepared SQL Statements
Edit

ERD to Shorthand Conversions

Introduction

Work through the following Entity Relation diagrams and convert them to shorthand notation outlined in class.

An example of shorthand notation for an entity Course would be as follows:

Course(CourseCode, Name, EnrolmentCount, ProfessorID)

ProfessorID is the foreign key of an entity called Professor

In this case, primary keys are represented as bold attributes while foreign keys are italicized. In an exam setting you can simply use a hard underline for primary keys and a dotted underline for foreign keys. Also make sure you indicate which entity the foreign key belongs to.

Questions

Question 1

Exercise 1

Question 2

Exercise 2

Question 3

Exercise 3

Question 4

Exercise 4

Last updated on 1/4/2019
← Pine Valley Furniture - SolutionERD to Shorthand Conversions - Solution →
  • Introduction
  • Questions
    • Question 1
    • Question 2
    • Question 3
    • Question 4
TIL
Docs
Getting StartedPrinciples of Programming Languages (C24)Introduction to Databases (C43)
Community
PiazzaQuercus
More
GitHubStar
Facebook Open Source
Copyright © 2019 Rakin Uddin