|
acres |
| View Comments (0) |
| * | Group - Dept | Status | Approved | Date Reviewed | Reviewer | Comments |
|---|---|---|---|---|---|---|
| 1 | Curriculum Routing - CIS Computer Information Systems | Completed | Approved | 12/20/2019 | Julie Napier | |
| 2 | Curriculum and Assessment - CIS Computer Information Systems | Completed | Approved | 01/03/2020 | Carey Minnis | |
| 3 | Curriculum Committee - CIS Computer Information Systems | Completed | Approved | 02/12/2020 | Carey Minnis | |
| 4 | Curriculum and Assessment (Second Review) - CIS Computer Information Systems | Completed | Approved | 02/12/2020 | Carey Minnis | |
| 5 | Catalog and Articulation - CIS Computer Information Systems | Completed | Approved | 02/12/2020 | Julie Napier |
| Originator: | Burgess, Peter Status: Approved Department: CIS Computer Information Systems |
| Date Created: | 12/13/2019 Submitted: 12/13/2019 Completed: 02/12/2020 To ACETS: |
| Course Number: | 210 |
| Course Information: | Course Modification to an existing course |
| Effective Academic Year: | 2021 |
| Course Full Title: | Database Management and SQL Design |
| Program Modification Required?: | No |
| If yes, list the degree or certificate: | |
| Course Impact?: | No |
| Purpose of Submission: | Change to an Established Course |
| If yes, list the degree or certificate: | |
| Reason for Evaluation: | Description Change Objectives, Outcomes, and/or Competencies changes |
| Mode of Instruction: | traditional online hybrid plural |
| If other, please explain: | |
| Catalog Course Description: | This course will provide the student the tools needed to properly analyze a business need for a database system, create a proper design using modeling techniques, implement the design using ANSI Standard Structured Query Language (SQL), and create a database in DBMS software using code. |
| Prerequisite(s): | Successful completion of CIS 110 or CIS 120 |
| Corequisite(s): | |
| Previous Credit (Total): | 3 |
| Previous Lecture Hours: | 3 |
| Previous Lab Hours: | |
| Previous Clinical Hours: | |
| New Credit Hours (Total): | |
| New Lecture Hours: | |
| New Lab Hours: | |
| New Clinical Hours: | |
| New Internship Hours: | |
| Explanation of proposed modifications to course: | Change to course goals, objectives, competencies to better reflect the purpose of the course and not that of any particular textbook. |
| Contact person/email: | Pete Burgess/pburgess@mohave.edu |
| Is this course identified as a Writing Across the Curriculum (WAC) course?: | No |
| SUN Course?: | No |
| If yes, please provide the established SUN number: | |
| Is this an AGEC course: | No |
| Articulated?: | Yes |
| Transfer?: | ASU NAU |
| Course Learning Outcomes: | 1. Differentiate types of databases including Hierarchical, Network, Relational, Object-Oriented, and Hybrid and determine the best approach for a business need.
2. Create a database plan, including Mission Statement and Mission Objectives, to meet the needs of the business for whom it?s being created. 3. Using logical modeling tools and development methodologies, develop a relational database design that will allow the collection of data requested by a business or organization. 4. From the logical design, create the physical objects in the database using Structured Query Language (SQL) data definition tools, including database, tables, and fields in order to properly store the data. 5. Utilize SQL to provide user-interfaces to allow data entry using data manipulation tools and presentation of data through forms and reports. 6. Secure the database through SQL?s data control language, providing user rights and privileges using roles. 7. Discuss essential database topics of a Database Administrator (DBA) position including backup and recovery, distributed databases, security, and administration. 8. Introduce several database approaches used in business, industry, and organizations. |
| Course Competencies and Objectives OR Course Competencies and Outline: | Competency 1 Define different database types and understand the history and development of each and the current preferred models.
Objective 1.1 Differentiate between the DBMS and the DatabaseObjective 1.2 Explain different database models including hierarchical, networking, relational, object-oriented, and hybrid and choose the best model for the business. Objective 1.3 Describe the relational DBMS model and its logical objects, including catalog, schema, database, entities (tables), attributes (fields or columns), records (rows or tuples). Competency 2 Design a relational database management system (RDBMS) using logical tools for modeling the physical database. Objective 2.1 Analyze the business data needs of a company or organization for purposes of collecting necessary data and providing information from that data. Objective 2.2 Create a picture-perfect Entity Relationship Diagram and Data Dictionary using normalization methods and normal forms (first, second, and third). Objective 2.3 Provide support and organization of objects prior to the physical creation of the database. Objective 2.4 Assure the logical design meets the needs of the business in terms of its data requirements and reporting purposes. Competency 3 Create physical objects in the DBMS using SQL commands to store and manipulate the data. Objective 3.1 Write SQL commands using data definition language (DDL) to create tables to hold the data as planned in the Data Dictionary Objective 3.2 Create relationships between tables using primary and foreign keys. Objective 3.3 Populate tables using SQL code to enforce data integrity and insure other constraints are met. Competency 4 Use Query by Example (QBE) and SQL data manipulation language (DML) to query for desired results. Objective 4.1 Query database tables for selected data using GUI tools provided by the DBMS and user interface. Objective 4.2 Search for desired data using SQL data manipulation language (DML) to query the database table(s). Objective 4.3 Format and layout proper presentation of data using SQL formatting commands. Competency 5 Create data collection and presentation of objects using DBMS provided utilities. Objective 5.1 Utilize form utilities to create varying types of forms for data entry and presentation of data in a variety of formats. Objective 5.2 Use report utilities to create several report styles for presentation of data based upon user?s needs. Objective 5.3 Use views (saved queries) to create forms and reports for data entry and presentation of data to securely meet the requirements for information. Competency 6 Understand DBMS functions provided by the software to manage and maintain the database. Objective 6.1 Describe the process of concurrent updates. Objective 6.2 Perform backup and recovery using tools available in the DBMS. Objective 6.3 Assure proper levels of security of objects and the database through encryption, authentication, authorization, and views. Objective 6.4 Provide data integrity of the data in the database. Objective 6.5 Alter, modify, and add objects to the design of an existing database. Objective 6.6 Provide data replication and utility services. Competency 7 Explain the roles of a Database Administrator (DBA). Objective 7.1 Describe the education needed to become a Database Administrator. Objective 7.2 Understand the importance of the DBA to the initial design and planning for a database. Objective 7.3 Explain the importance of policy formulation and enforcement. Objective 7.4 Use tools in SQL to secure the data in the database using SQL code. Objective 7.5 Utilize DBMS functions and tools in SQL to maintain the database. Objective 7.6 Evaluate and improve database performance using performance tuning techniques. Competency 8 Understand advantages and disadvantages of several database approaches. Objective 8.1 List the benefits and usage of a distributed database. Objective 8.2 Describe the purpose and benefits of client/server systems. Objective 8.3 Allow web access to back-end databases. Objective 8.4 Illustrate the purpose and use of data warehouses in business and industry. Objective 8.5 Compare object-oriented databases (OODBMS) to relational databases (RDBMS) and discuss the hybrid approach. |