Course Snapshot for CIS240 - Database Design and Development
The information listed below is subject to change. Please review the course syllabus within your online course at the start of class.
Course Competencies
The competencies you will demonstrate in this course are as follows:
The competencies you will demonstrate in this course are as follows:
- The student will gain a working knowledge of Relational Database Systems.
- The student will be able to effectively apply design tools to the design of a relational database.
- The student will be able to properly execute queries to retrieve information from a relational database.
- The student will be able to place database tables in the first three normal forms.
- The student will be able to implement concurrency control in a relational database.
- The student will be able to create a backup plan for a relational database.
Module Outcomes Mapped to Competencies
The module outcomes that will permit you to demonstrate course competencies are:
| Outcomes | Competencies | |
|---|---|---|
| 1 | Review basic database terminology (A, C) | A, C |
| 2 | Describe database management systems (DBMSs) (A, B) | A, B |
| 3 | Explain the advantages and disadvantages of database processing (A) | A |
| 4 | Describe the relational model associated with databases (B, C) | B, C |
| 5 | Review sample companies used throughout the text - BITS Corporation, Colonial Adventure Tours, and Sports Physical Therapy (A) | A |
| 6 | Explain and design Query-By-Example (QBE) (C) | C |
| 7 | Develop relational algebra statements (A, B) | A, B |
| Outcomes | Competencies | |
|---|---|---|
| 1 | Describe Structured Query language basics (SQL) (B) | B |
| 2 | Design SQL statements to update database data (B, C) | B, C |
| 3 | Define, describe, and use database views (A) | A |
| 4 | Implement indexes to improve database performance (B) | B |
| 5 | Describe the security feature of a DBMS (E) | E |
| 6 | Discuss entity, referential, and legal-values integrity (A, B, E) | A, B, E |
| Outcomes | Competencies | |
|---|---|---|
| 1 | Explain functional dependence and primary keys (A) | A |
| 2 | Define first normal form, second normal form, and fourth normal form (D) | D |
| 3 | Explain how normalization is used in the database design process (D) | D |
| 4 | Describe the problems associated with tables (relations) that are not in first normal form, second normal form, or third normal form, along with the mechanism for converting to all three (D) | D |
| 5 | Define user views and explain their function (B) | B |
| 6 | Define Database Design Language (DBDL) and use it to document database designs (B) | B |
| 7 | Design entity-relationship model for representing and designing databases (B) | B |
| 8 | Implement top-down and bottom-up approaches to database design and examine the advantages and disadvantages of both methods (B, D) | B, D |
| 9 | Design and implement a survey form to obtain information from users prior to beginning the database design process (B) | B |
| 10 | Present a method for database design at the information level and view examples illustrating this method (B, D) | B, D |
| Outcomes | Competencies | |
|---|---|---|
| 1 | Describe the functions, or services, provided by a DBMS (A, B, C, E, F) | A, B, C, E, F |
| 2 | Describe how a DBMS handles updating and retrieving data (A) | A |
| 3 | Define and describe data replication (A) | A |
| 4 | Present the utility services provided by a DBMS (B, F) | B, F |
| 5 | Examine the catalog feature of a DBMS (B) | B |
| 6 | Illustrate the concurrent update problem and describe how a DBMS handles this problem (C, E) | C, E |
| 7 | Explain the data recovery process in a database environment (F) | F |
| 8 | Describe the security services provided by a DBMS (B, E, F) | B, E, F |
| 9 | Examine the data integrity features provided by a DBMS (A, B) | A, B |
| 10 | Explain the need for database administration (A) | A |
| 11 | Explain the DBA’s responsibilities in formulating and enforcing database policies for access privileges, security, disaster planning, and archiving (A, B, E, F) | A, B, E, F |
| Outcomes | Competencies | |
|---|---|---|
| 1 | Describe distributed database management systems (DDBMSs) (A, B, E, F) | A, B, E, F |
| 2 | Explain client/server systems (A, B, F) | A, B, F |
| 3 | Examine the ways databases are accessed on the Web (A, B) | A, B |
| 4 | Describe data warehouses and XML (A, B, F) | A, B, F |
| 5 | Describe data warehouses structure and access (A, B, E) | A, B, E |
| 6 | Explore the general concepts of object-oriented DBMSs (A, E, F) | A, E, F |
Course Time Commitment and Expectations
The semester schedule for this course may be 15 weeks, 10 weeks, or 6 weeks in duration. Based on the course format, this table shows the approximate amount of time you should plan to spend per week on this course. This includes time to read/listen to the online content, participate in discussion forums, complete all assignments, and study the course material.
For accelerated courses, the amount of time required per week is greater. Note that regardless of course format, the course material is the same and all course competencies, module outcomes, and assignments will be covered.
| Course Credit Hours | Course Format (Duration) | Pace Relative to a 15 Week Course | Course Activity Hours | Student Learning Hours Per Week |
|---|---|---|---|---|
| 3 | 15 Weeks | - | 135 | 8.5 to 9.5 |
| 3 | 10 Weeks | 1.5x faster | 135 | 12.5 to 14.5 |
| 3 | 6 Weeks | 2.5x faster | 135 | 21 to 24 |
Aside from typical reading assignments, this course has the following (Please Note: This list is subject to change based on the discretion of the instructor facilitating this course.):
Summary of Grading:
|
Assignment |
Points |
|---|---|
|
Discussions, D2L (11 @ 20 points each) |
220 |
|
Review Questions, MindTap (9 @15 points each) |
135 |
|
Assignments, MindTap (9 @ 20 points each) |
180 |
|
Module Quizzes, D2L (5 @ 33 points each) |
165 |
|
Projects, D2L (3 @ 100 points each) |
300 |
|
TOTAL |
1,000 |
| Grading Scale | ||||
|---|---|---|---|---|
| A = 90-100% | B = 80-89% | C = 70-79% | D = 60-69% | F = 59%-below |
CCCOnline Course Quality Commitment
CCCOnline goes to great lengths to assure the quality of your online learning experience. You can expect the following from our courses:
- All CCCOnline courses are developed by content experts and a professional team of instructional designers.
- CCCOnline courses are built with a template that assures accessibility and Quality Matters Design Standards.
- There is navigation consistency across all CCCOnline courses.
- Most of our courses come with illustrative models and videos to enhance learning concepts.