Database Design

Grasp the basics of designing new databases or redesigning existing databases.

course image

Course details

ceus icon CEUs 0.9

schedule icon Schedule Evenings

location icon Location Main Campus

cost icon Cost

Registration details

Database Design

Grasp the basics of designing new databases or redesigning existing databases.

What you’ll be able to do — competencies

  • Create databases from scratch and apply formal design processes
    Modify an existing database so that it conforms to the first normal form of relational integrity
  • Modify an existing database so that it conforms to the second normal form
  • Modify an existing database so that it conforms to the third normal form
  • Redesign an existing database that meets requirements based on specific business rules, that enforces data integrity per the business rules and database design recommended techniques, and that conforms to the third normal form

Course description

expand drawer icon collaspe drawer icon

Learn how to design and create new databases, as well as work with relationships between tables in existing databases. Students will create databases from scratch and apply formal design processes. Course covers how to identify database fields and data types, as well as grouping fields into tables. Students will learn to understand primary and foreign keys and apply them to database design.

This course is recommended for anyone who needs to either create new databases or redesign existing databases. It’s also recommended for anyone who needs to convert an Excel spreadsheet into a database.

Prerequisites

expand drawer icon collaspe drawer icon
  • Basic Relational Database Essentials, familiarity with a database product, or equivalent knowledge

Syllabus

expand drawer icon collaspe drawer icon

Modify an existing database so that it conforms to the first normal form of relational integrity.

  • Assign primary keys to all tables in a database according to best practices for their key attributes
  • Define appropriate table relationships
  • Predict the problems that can result when a table is not in first normal form
  • Identify and fix non atomic fields in each table
  • Identify and fix repeated fields in each table

Modify an existing database so that it conforms to the second normal form.

  • Identify dependent fields in each table
  • Predict the problems that can result when a table is not in second normal form
  • Identify and fix fields that are not dependent on the entire primary key in each table
  • Define appropriate table relationships as needed

Modify an existing database so that it conforms to the third normal form.

  • Identify when a field is a key field or a non key field in each table
  • Predict the problems that can result when a table is not in third normal form
  • Recognize when a field is dependent on a non key field and fix the problem
  • Define appropriate table relationships as needed

Redesign an existing database that meets requirements based on specific business rules, that enforces data integrity per the business rules and database design recommended techniques, and that conforms to the third normal form.

  • Write a database purpose
  • Apply appropriate key attributes to each field to enhance data integrity
  • Follow the recommended steps while designing or redesigning an existing database

Next available start dates

Main Campus — Evenings

Registration open expand drawer icon collaspe drawer icon
Database Design
hours icon

Total classroom hours

9 hours

schedule icon

Schedule

Main Campus

Evenings, 6:00 PM - 9:00 PM, 3 M W - 4/10/2023 - 4/17/2023

Class Location:
3000 Landerholm Cir. SE Bellevue, WA 98007
Building A, Room 134
Campus Map
 

Quarter: Winter

cost icon

Total cost

$329

instructor icon

Instructor: Murray Law

Murray Law is a software engineer and network administrator. He spent 10 years at Microsoft working on the Windows Networking team and the Real Time Communications group, helping to develop networking protocols and messaging features for Office Communications Server and Lync. He is a Microsoft Certified instructor and has taught C# programming, SQL and applications such as Windows Active Directory and Cloud integration services.

Interested in custom learning solutions for your team?

Tombolo Institute Corporate Solutions offers tailor-made professional development programs to meet your organization’s goals.

Get started