Print Course information
E-mail to a friend
Return to Course Catalog

Course Catalog

Database Design  

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

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

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, and group 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.

Prerequisite:
  • Basic Relational Database Essentials, familiarity with a database product, or equivalent knowledge

 

Item: R8305
CEUs:  0.9
Schedule: 6:00 PM - 9:00 PM, 3 M W - 6/24/2020 - 7/1/2020

Instructor(s):  April Johnson
Location: ONL   Room: ONL
Online courses require an internet connection and the ability to interact both through audio and video using either a web cam/microphone, speakers/headset using a computer or via a mobile phone connection. Any costs associated with connectivity or equipment are the responsibility of the student.

Total cost: $329.00

 

 

 

If the class you are registering for lists a required textbook, you are responsible for ordering and purchasing it prior to the start of class. Please note that there is no bookstore at North Campus. 
 

 
Copyright © Bellevue College Continuing Education, 14673 NE 29th Place | 425.564.2263 | Main Campus, 3000 Landerholm Circle SE