Database Development
Course Introduction
Core Standards of the Course
Strand 1
Students will be introduced to Database Fundamentals.
Standard 1
Ethics of Database.
Standard 2
History of Databases.
Standard 3
Database industry aware of opportunities.
Standard 4
Types of Databases used today and where they are moving to in the future.
Strand 2
Students will be familiar with the languages types of database development.
Standard 1
DCL (Data Control Language).
Standard 2
DDL (Data Definition Language).
Standard 3
DML (Data Manipulation Language).
Strand 3
Students will demonstrate the creation of a Logical ERD model and taking it to the physical database.
Standard 1
Students will show an understanding of the 5 levels of Normal Form.
Standard 2
Create an ERD (Entity Relationship Diagram).
Standard 3
Create database tables.
Standard 4
Create views and understand views and their benefits.
Strand 4
Demonstrate use of data manipulation language to view, change, create and remove data in the database.
Standard 1
Demonstrate select statements to view data in the database.
Standard 2
Demonstrate insert statements to load data into the database.
Standard 3
Demonstrate update statements to change data.
Standard 4
Demonstrate delete statements to remove data.
Standard 1
Understand database security concepts.
Standard 2
Understand database backups and restore.
Workplace Skills
Workplace skills should be practiced and improved on daily in the classroom to help students become efficient and reliable employees.
http://www.uen.org - in partnership with Utah State Board of Education (USBE) and Utah System of Higher Education (USHE). Send questions or comments to USBE Specialist - Kristina Yamada and see the CTE/Computer Science & Information Technology website. For general questions about Utah's Core Standards contact the Director - THALEA LONGHURST. These materials have been produced by and for the teachers of the State of Utah. Copies of these materials may be freely reproduced for teacher and classroom use. When distributing these materials, credit should be given to Utah State Board of Education. These materials may not be published, in whole or part, or in any other format, without the written permission of the Utah State Board of Education, 250 East 500 South, PO Box 144200, Salt Lake City, Utah 84114-4200.