NEED Data Management Assignments IN 15 HOURS or LESS

Data Management

Required Text

Pratt, P. and M. Last. (2015). Concepts of Database Management, 8th ed. Boston: Cengage Learning.

ISBN: 9781285427102

Course Description

This course examines the development and administration of relational databases through the

stages of the database application life cycle, advanced topics in database administration, and

recent trends in database technologies.

Course Objectives

 Describe the database application lifecycle and identify its activities.  Describe the tools and techniques used in database design.  Identify the roles of data administrators, database administrators, and database

designers and discuss how they interact with users.  Apply the Entity-Relationship (ER) model, the Enhanced Entity-Relationship (EER)

model, and the normalization technique to database design.  Develop conceptual, logical, and physical database designs.  Identify methods for improving database performance.  Identify database security issues and describe how they can be addressed.  Describe how transaction management, concurrency control, and recovery services

maintain the consistent state of a database.  Form queries using relational algebra and relational calculus.  Describe the process of query optimization.

 Identify the concepts and issues involved with distributed databases.  Describe the issues involved in integrating databases into the Web environment and the

technologies that are involved.  Describe the importance of XML and its potential impact on database development.  Explain the basic concepts of data warehousing and data mining.

Credit Hours: 3

Prerequisites: None

Tentative Course Schedule

Course Week Weekly Content

Week 1 Introduction to Database Management

 Reading

 Lecture "Introduction to Database Management"

 Lecture "The Relational Model 1: Introduction, QBE, and Relational Algebra"

 Lecture "Database Application Lifecycle"

 Discussion "Introduction to Database Management, QBE, and Relational Algebra"

 Assignment "Introduction to Database Management, QBE, and Relational Algebra"

Week 2 Relational Model SQL

 Reading

 Lecture "What is a Query Optimization?"

 Lecture "The Relational Model 2: SQL"

 Discussion "The Relational Model: SQL"

 Assignment "The Relational Model: SQL"

Week 3 Relational Model Advanced Topics

 Reading

 Lecture "The Relational Model 3: Advanced Topics"

 Discussion "The Relational Model: Advance Topics"

 Assignment "The Relational Model: Advance Topics"

Week 4 Database Design Normalization

 Reading

 Lecture "Database Design 1: Normalization"

 Discussion "Normalization"

 Assignment "Normalization"

Week 5 Database Design Design Method

 Reading

 Lecture "Database Design 2: Design Method"

 Discussion "Design Method"

 Assignment "Design Method"

Week 6 DBMS Functions  Reading

 Lecture "Database Roles"

 Lecture "DBMS Functions"

 Lecture "Database Administration"

Course Week Weekly Content

 Discussion "DBMS Functions and Database Administration"

 Assignment "DBMS Functions and Database Administration"

Week 7 Database Administration

 Reading

 Lecture "Database Management Approaches"

 Discussion "Database Management Approaches and Using Access to Create and Publish a Web Database"

 Assignment "Database Management Approaches and Using Access to Create and Publish a Web Database"

Week 8 Database Management Approaches

 Discussion "Reflection"

 Student End of Course Survey

 Assignment "Final Project"

Grading Policy

Grading Category Grade Weight

Discussions 30%

Assignments 50%

Final 20%

Week Type of Activity Activity Estimated Hours Required

1

Online

Readings/Lectures 7.0

Discussions 3.0

Assignments 0.0

Preparation

Readings 2.6

Discussions 2.0

Assignments 3.0

Clinical/Lab Hours

Week Type of Activity Activity Estimated Hours Required

2

Online

Readings/Lectures 3.5

Discussions 3.0

Assignments 0.0

Preparation

Readings 1.6

Discussions 2.0

Assignments 2.0

Clinical/Lab Hours

Week Type of Activity Activity Estimated Hours Required

3 Online Readings/Lectures 3.3

Discussions 3.0

Assignments 0.0

Preparation

Readings 1.2

Discussions 2.0

Assignments 2.0

Clinical/Lab Hours

Week Type of Activity Activity Estimated Hours Required

4

Online

Readings/Lectures 2.9

Discussions 3.0

Assignments 0.0

Preparation

Readings 1.0

Discussions 2.0

Assignments 2.0

Clinical/Lab Hours

Week Type of Activity Activity Estimated Hours Required

5

Online

Readings/Lectures 4.3

Discussions 3.0

Assignments 0.0

Preparation

Readings 1.7

Discussions 2.0

Assignments 1.0

Clinical/Lab Hours

Week Type of Activity Activity Estimated Hours Required

6

Online

Readings/Lectures 6.1

Discussions 3.0

Assignments 0.0

Preparation

Readings 1.1

Discussions 2.0

Assignments 3.0

Clinical/Lab Hours

Week Type of Activity Activity Estimated Hours Required

7

Online

Readings/Lectures 3.4

Discussions 3.0

Assignments 0.0

Preparation

Readings 0.8

Discussions 2.0

Assignments 3.0

Clinical/Lab Hours

Week Type of Activity Activity Estimated Hours Required

8

Online

Readings/Lectures 0.2

Discussions 3.0

Assignments 2.0

Preparation Readings 0.0

Discussions 2.0

Assignments 3.0

Clinical/Lab Hours