Database design

Database design and development
Class Name

Intro to Database Design

Database design is a critical part in designing a dynamic WEB site.This course will give you the steps to design a database. The steps that you learn in this course can be applied to designing any other relational database, such as (MySql, Oracle or Microsoft SQL Server, etc.). You will design two databases. The first one will be defined by the instructor and the second one you will define.
Outline
Week 1:
  • Database Model - What is it?
  • Project Functional Specification and the database design
  • Database Concepts
Week 2:
  • Entities
  • Attributes
  • Logical and Physical Data Models
Week 3:
  • First Normal Form
  • Second Normal Form
  • Third Normal Form
Week 4:
  • Tables
  • Columns
  • Rows
  • Data Format
Week 5:
  • Primary Keys
  • Foreign Keys
  • Referential Integrity
  • Relationships and Cardinality
  • 1:N Relationships
  • N:N Relationships
Week 6:
  • CASE Tools
  • Data Definition Language
  • Data Manipulation Language
Prerequisites
None
Requirements
Access 97 or later version installed on a Windows computer.Web space where assignments can be posted.
Class Books
No text required.
[
]
Course Price
  • Price: $80.00 US
[Register Now]

Additional Information:
This online course is limited to 100 participants. Your place in the course is confirmed by your payment. Introductory courses are intended for students with no experience in the subject matter and are seeking beginner level training.

Refund Policy: All Online Class fees are only refundable or creditable during the first week of class. A processing fee of five dollars ($5.00) will be charged for each refund request. If you have any questions please contact us

Additional Cost: Book and software migh be required for the course. Read the Requirements and Book section for more information. Course fee does not include the book and software cost .

Start Date: Click on the Register Now button to process to the registration page. You will see the start date of the class on that page. To get the start date of other courses, click on Open Class List link on the top navigation bar.

How eClasses Work:The classroom environment is based on Lundeen & Associates Web Crossing technology, a threaded messaging system. Instructors post lectures, reading selections, and hands-on assignments once a week in the online classroom. Students can discuss the assignments with the instructor and amongst themselves in the classroom area. This format has no set meeting time, which allows students to attend class at a time most convenient to them, yet still provides logically organized communication between class participants. Students can apply for the completion certificate after finishing the class. Web Study certificate is also available. Click on the Certificates link on the top navigation bar for more information.

 

Register Now

Before you register for this class, please read carefully the Outline, Prerequisites, Requirements, Books, and Refund Policy section.

Instructor: Sharon Hall
Sharon HallSharon Hall has over 15 years experience in designing databases and software engineering, currently designing and developing dynamic WEB sites. She is experienced in data warehouse architecture, database architecture, software engineering and implementation of major computer systems. Sharon holds a MS degree in Computer Science from Webster University, St Louis, Missouri.

 book
4 Web Study Certificates

 Valid XHTML 1.0!  Valid CSS1!  Level Triple-A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0

Other Topics of Our Web Training Program: