Database Design and Administration

DDA400 — Database Design & Administration, 3.0 hours

Description

Upon completion of this course students will be able to improve business performance and bring efficiency through the development of credible databases. Students will learn to strategically develop appropriate architecture and design while performing data modeling, data warehousing using the updated tools and technologies.

Program Objectives

  1. Students will learn the importance of database systems and data models.
  2. Students will gain an understanding in Relationship (ER) Modeling.
  3. Students will learn how to demonstrate skills in advanced data modeling, and normalization of database tables.
  4. Student will learn the Introduction to Structured Query Language (SQL), Advanced SQL, and Database Design.
  5. Students will show mastery in transaction management and concurrency control, and database performance tuning and query optimization.
  6. Students will learn the importance of Distributed Database Management Systems, Business Intelligence, and Data Warehouses.
  7. Students will gain the knowledge and understanding of Big Data and NoSQL, and Database Connectivity and Web Technologies.
  8. Students will demonstrate mastery in Database Administration and Security.

Professor

Professor

Walker Byrd

While pursuing a Master’s Degree in Information Technology from Grantham University, I developed skills in reverse engineering, computer forensics, networking, training and information security. This knowledge has enabled me to operate in Windows and Linux platforms and master multiple security principles virtual and physical. 

 During my 28 years in the Military as a Signal Warrant Officer I have had several opportunities to act in an instructor role; both face to face and virtual.  I have been trained as an instructor by both the U.S. Army and the Royal Danish Defense College in Copenhagen, Denmark. I take teaching to heart in all cases.

Online Support (IT) and Moodle Navigation

Online Support (IT) and Moodle Navigation:

All members of the Lakewood University community who use the University’s computing, information or communication resources must act responsibly. Support is accessible by calling 1-800-517-0857 option 2 or by emailing info@lakewood.edu

Books and Resources

Books and Resources

Carlos Coronel, Steven Morris. Database Systems. 13th ed. Cengage, 2018.

Evaluation Method

Evaluation Method

Graded work will receive a numeric score reflecting the quality of performance.
Course Requirement Summary

  • Assignments - Total of 60 Points
  • Weekly discussion forums-Total of 80 Points
  • Final Exam - 50 Points

 

Grading Scale

Grading Scale

Graded work will receive a numeric score reflecting the quality of performance as given above in evaluation methods. The maximum number of points a student may earn is 190. To determine the final grade, the student's earned points are divided by 190.

Your overall course grade will be determined according to the following scale:

A = (90% -100%)
B = (80% - 89%)
C = (70% - 79%)
D = (60% - 69%)
F < (Below 60%)

Academic Integrity/ Plagiarism

Academic Integrity/ Plagiarism:

Cheating (dishonestly taking the knowledge of another person whether on a test or an assignment and presenting it as your work) and plagiarism (to take and pass off as one's own the ideas or writing of another) are a serious issue. While it is legitimate to talk to others about your assignments and incorporate suggestions, do not let others "write" your assignments in the name of peer review or "borrow" sections or whole assignments written by others. We do get ideas from life experiences and what we read but be careful that you interpret these ideas and make them your own.

I am aware that many types of assignments are available on the internet and will check these sources when there is legitimate suspicion.

Penalty is a zero on the assignment. In cases where there is a major or continuous breach of trust, further discipline, such as an "F" in the course, may be necessary.

The major consequence of any form of cheating is damage to your character and the result of trust and respect.

Disability Accommodations

Disability Accommodations

Students who may have a disability meriting an academic accommodation should contact Jim Gepperth, the Disabilities Services Coordinator and Academic Dean. For accommodations to be awarded, a student must complete a form and provide documentation of the disability to the Disability Services Coordinator. Any accommodations for disabilities must be re-certified each year by the Disability Services Coordinator before course adjustments are made by individual instructors. Additional information on disability accommodations may be found in the Lakewood University Catalog.

Supplemental Texts

Supplemental Texts

You can use the following resources to assist you with proper source citation. 

American Psychological Association Style Guide- https://www.mylakewoodu.com/pluginfile.php/118179/mod_resource/content/1/APA%20Style%20Guide%207th%20edition.pdf

The Purdue OWL website is also a helpful resource for students. Here is a link to the OWL website: https://owl.purdue.edu/owl/research_and_citation/apa_style/apa_formatting_and_style_guide/general_format.html

Library

Library

 

Mary O'Dell is the Librarian on staff at Lakewood University

She is available by appointment. You can make an appointment with her by emailing her at modell@lakewood.edu or call at 1-800-517-0857 X 730

You may also schedule a meeting at this link: https://my.setmore.com/calendar#monthly/r3a761583354923270/01032020

She can assist you with navigating LIRN, research, citations etc.

Support

Support

Each student at Lakewood University is assigned a Success Coach. Your Success Coach exists to assist you with academic and supportive services as you navigate your program. They will reach out to you, often, to check-in. Please use the resources they offer.

Student Services is available to assist with technical questions regarding Lakewood University and all services available to you.

1-800-517-0857 option 2
info@lakewood.edu
studentservices@lakewood.edu

Career Services

Career Services

Students are offered Career Services at any point as they journey their academics at Lakewood University.

1-800-517-0857 option 2
careerservices@lakewood.edu

Objectives

Objectives
  1. Students will learn the importance of database systems and data models.
  2. Students will gain understanding in Relationship (ER) Modeling.
  3. Students will learn how to demonstrate skills in advanced data modeling, and normalization of database tables.
  4. Student will learn the Introduction to Structured Query Language (SQL), Advanced SQL, and Database Design.
  5. Students will show mastery in transaction management and concurrency control, and database performance tuning and query optimization.
  6. Students will learn the importance of Distributed Database Management Systems, Business Intelligence, and Data Warehouses.
  7. Students will gain the knowledge and understanding of Big Data and NoSQL, and Database Connectivity and Web Technologies.
  8. Students will demonstrate mastery in Database Administration and Security.

Lessons

Lessons
Title
Lesson #1
Course Topic
  • Database Systems
  • Data Models
Readings/Assignments

Study Course Syllabus
Read Chapters 1 & 2
Participate in the Discussion Forum
Complete Assignment 1
Lesson Evaluation

Due

Assignment 1 upon completion of the lesson

Objectives
Objective 1
Title
Lesson #2
Course Topic
  • The Relational Database Model
  • Entity Relationship (ER) Modeling
Readings/Assignments

Read Chapters 3 & 4
Participate in the Discussion Forum
Lesson Evaluation

Objectives
Objective 2
Title
Lesson #3
Course Topic
  • Advanced Data Modeling
  • Normalization of Database Tables
Readings/Assignments

Read Chapters 5 & 6
Participate in the Discussion Forum
Lesson Evaluation

Objectives
Objective 3
Title
Lesson #4
Course Topic
  • Introduction to Structured Query Language (SQL)
  • Advanced SQL
Readings/Assignments

Read Chapters 7 & 8
Participate in the Discussion Forum
Complete Assignment 2
Lesson Evaluation

Due

Assignment 2 upon completion of the lesson

Objectives
Objective 4
Title
Lesson #5
Course Topic
  • Database Design
  • Transaction Management and Concurrency Control
Readings/Assignments

Read Chapters 9 & 11
Participate in the Discussion Forum
Lesson Evaluation

Objectives
Objective 5
Title
Lesson #6
Course Topic
  • Database Performance Tuning and Query Optimization
  • Distributed Database Management Systems
Readings/Assignments

Read Chapters 11 & 12
Participate in the Discussion Forum
Lesson Evaluation

Objectives
Objective 6
Title
Lesson #7
Course Topic
  • Business Intelligence and Data Warehouses
  • Big Data and NoSQL
Readings/Assignments

Read Chapters 13 & 14
Participate in the Discussion Forum
Lesson Evaluation

Objectives
Objective 7
Title
Lesson #8
Course Topic
  • Database Connectivity and Web Technologies
  • Database Administration and Security
Readings/Assignments

Read Chapter 15 & 16
Participate in the Discussion Forum
Complete Assignment 3
Complete the Final Exam
Request the Next Course
LessonEvaluation
THANKS FOR A GREAT CLASS

Due
Assignment 3 and Final exam upon completion of the lesson
Objectives
Objective 1

Overview

Course

Course

Contact Information

Contact Information

E-mail: wbyrd@lakewood.edu
Cell Phone: 800-517-0857 X 787