CSC-251 Applied Database Concepts

An introduction to database design and development. Database normalization, data integrity, concurrent updates, and data security will also be discussed and practiced. Emphasis will be on using at least two popular database management systems to build and maintain relational databases. The student will create databases, queries, custom forms and reports. Additionally, SQL programming will be used extensively.

Credits

3

Prerequisite

CSC-115 with a grade C or better or CSC-117 with a grade of C or better

Lecture Contact Hours

3

Lab Contact Hours

0

Other Contact Hours

0

Semesters Course Will Be Offered

• Spring

Course Learning Outcomes

1. Create relational databases, queries, custom forms and reports using a database management system.
2. Use SQL programming to perform database operations.
3. Utilize standard database management techniques including database normalization, data integrity, concurrent updates, and data security.

View Course Outline

CSC 251: Applied Database Concepts

Course Description

An introduction to database design and development. Database normalization, data integrity, concurrent updates, and data security will also be discussed and practiced. Emphasis will be on using at least two popular database management systems to build and maintain relational databases. The student will create databases, queries, custom forms and reports. Additionally, SQL programming will be used extensively.

Credit Hours

3

Contact Hours

Lecture	3
Lab	0
Other	0

Semester(s) Course Will Be Offered

Spring

Prerequisites

CSC-115 with a grade C or better or CSC-117 with a grade of C or better

Course Learning Outcomes

1. Create relational databases, queries, custom forms and reports using a database management system.
2. Use SQL programming to perform database operations.
3. Utilize standard database management techniques including database normalization, data integrity, concurrent updates, and data security.

Topic Outline

1. 1. Define and use common database terminology.

2. a. Background

3. b. History of Database Management

4. c. Advantages and disadvantages of Database Processing

5. d. Data, Storage, Retrieval, and Update

6. e. Shared Update

7. f. Backup and Recovery

8. g. Security

9. h. Integrity

10. i. Data Independence

11. j. Replication

12. k. Utilities

13.

14. 2. Determine how data are organized and manipulated using a database.

15. a. Relational Databases

16. b. The Relational Algebra

17. c. Hierarchical Databases

18. d. Network Databases

19.

20. 3. Identify data that are suitable and unsuitable for databases.

21. a. Distributed Databases

22. b. Client/Server Systems

23. c. Data Warehouses

24. d. Object-Oriented Databases Management System

25. e. The Internet and Intranets

26.

27. 4. Normalize Tables

28. a. Functional Dependence

29. b. Keys (Primary, Foreign and Secondary Keys)

30. c. First Normal Form, 2nd, 3rd normal forms

31. d. Incorrect Decompositions

32. e. Multivalued Dependencies and Fourth Normal Form

33. . Avoiding the Anomalies Problem

34.

35. 5. Design and build databases.

36. a. Information-Level Design

37. i. The Methodology

38. ii. Databases Design Examples

39. iii. Identify Relationships