Database Development
Printable Version (pdf)

 

Course Introduction

 

Core Standards of the Course

Strand 1
Students will be introduced to Database Fundamentals.

Standard 1
Ethics of Database.

1. Identify ethics within the industry.
   
2. Identify personal ethics.
   

Standard 2
History of Databases.

1. Order of database management systems in history (DBMS, RDBMS, OODBMS, ORDBMS).
   
2. Understand what a relational database is.
   
3. Understand the need for relational data management systems (RDMS).
   

Standard 3
Database industry aware of opportunities.

1. Identify career opportunities in the database industry (DBA, programmer, reporting programmer, database designer, and database developer).
   

Standard 4
Types of Databases used today and where they are moving to in the future.

1. Show understanding of the difference between OLTP vs Reporting.
   
2. Data Lakes/reservoirs
   

Strand 2
Students will be familiar with the languages types of database development.

Standard 1
DCL (Data Control Language).

1. Grant rights to database objects.
   
2. Revoking rights to database objects.
   

Standard 2
DDL (Data Definition Language).

1. Create a database.
   
2. Create objects in a database.
   
3. Maintenance of the database and objects.
   
4. Remove database objects
   

Standard 3
DML (Data Manipulation Language).

1. Create the data in the database.
   
2. Read the data in the database.
   
3. Update the data in the database.
   
4. Remove the data in the database
   

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.

1. Differences between Data Marts (DM) vs Online Transactional Process (OLTP) databases.
   
2. Understand each level and why 3NF is used in the industry for OLTP databases.
   
3. Understand why 2NF is used in the industry for DM databases
   

Standard 2
Create an ERD (Entity Relationship Diagram).

1. Demonstrate knowledge of one-to-one, one-to-many, and many-to-many relationships.
   
2. Create attributes for the entities.
   
3. Understand the reasons for keys in database.
   
4. Understand choosing appropriate primary keys.
   
5. Understand selecting appropriate data types for keys.
   
6. Understand selecting appropriate fields for composite keys.
   
7. Understand the relationship between foreign and primary keys.
   

Standard 3
Create database tables.

1. Create database tables using proper ANSI SQL syntax.
   
2. Define primary keys, foreign keys, unique keys, columns and rows.
   
3. Choose data types and understand why they are important for storage requirements.
   
4. Identify violations of data-integrity rules.
   

Standard 4
Create views and understand views and their benefits.

1. Create a view for query using SQL or another graphical designer.
   
2. Understand views.
   
3. Understand when to use views.
   

Standard 5
Create indexes.

1. Understand clustered and non-clustered indexes.
   
2. Add, delete and manage indexes for fast access to table rows and enforcing certain constraints.
   
3. Explain benefits and costs of using indexes.
   

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.

1. Demonstrate simple one table selects.
   
2. Demonstrate joined tables using inner and outer joins.
   
3. Understand what a Cartesian product is and how to avoid creating one.
   
4. Demonstrate grouping and sorting in joins.
   
5. Demonstrate the use of inline functions in SQL.
   
6. Check for NULL values.
   

Standard 2
Demonstrate insert statements to load data into the database.

1. Demonstrate inserting data into a table.
   
2. Demonstrate order when inserting into parent/child tables.
   

Standard 3
Demonstrate update statements to change data.

1. Demonstrate updating one row updates.
   
2. Demonstrate multiple rows to full table updates.
   

Standard 4
Demonstrate delete statements to remove data.

1. Demonstrate deleting one row.
   
2. Demonstrate deleting multiple rows to full table deletes.
   
3. Show understanding of the difference between truncate and delete.
   

Strand 5
Database Security.

Standard 1
Understand database security concepts.

1. Understand the need to secure a database.
   
2. Understand what objects can be secured.
   
3. Understand what objects should be secured, user accounts, and roles.
   

Standard 2
Understand database backups and restore.

1. Understand various backup trips, such as full and incremental.
   
2. Understand importance of backups.
   
3. Understand how to restore a database.
   

Performance Skills

1. Understand Database Fundamentals.
   
2. Know the language types of database development.
   
3. Demonstrate the creation of a Logical ERD model and taking it to the physical database.
   
4. Demonstrate use of data manipulation language to view, change, create and remove data in the database.
   
5. Understand Database Security.
   

Workplace Skills
Workplace skills should be practiced and improved on daily in the classroom to help students become efficient and reliable employees.

1. Communication
   
2. Problem Solving
   
3. Critical Thinking
   
4. Dependability
   
5. Accountability
   

---

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.