Extended National Diploma in IT

Unit 18: Database Design

This session will focus on designing a relational database using Visual Paradigm, Use Case Diagrams and E-R Diagrams.

Resources »

Learning Outcomes

  1. Be able to design, create and populate a relational database

Assessments

Week 2 Activities - Entity Relationship Diagrams

Week Lesson Activity Learning Assessment Skill Developed

design a relational database for a specified user need

discuss how potential errors in the design and construction of a database can be avoided

1.1
  • 10 min Recap the main features of a relational databases
  • 10 min Explain how to install Visual Paradigm 14.1 on PC or Memory Stick
  • 30 min Demonstrate creating an Entity-Relationship Diagram for Students enrolling in Courses at Oaklands College where the Courses are delivered in timetabled Sessions.
  • 30 min Demonstrate the identification of Entities and Attributes
  • 30 min Demonstrate customising the specification of each attribute with data types, allow null, default values, validation rules, unique
  • 30 min Demonstrate the identification of Primary Keys, Relationships and Foreign Keys
  • 10 min Examine the Pizza Shop Spreadsheet and and answer any questions
  • 10 min Summarise the key concepts and answer any questions
  • Questions and Answers
  • P2 D1 E-R Diagram
  • Database Design
  • Visual Paradigm

Useful Resources

Week Index