Course Learning Outcomes and Outcomes for Chapter 1

Course Learning Outcomes

 

  1. Database Management - Use a modern database management program such as Oracle, MySQL and PostgreSQL to perform such tasks as writing operational and correct SQL (DDL, DML and DCL) statements.


  2. Database Fundamentals - Write SQL statements that perform fundamental database concepts, including Relational Algebra, and successfully use a Relational Database System.


  3. ER Diagrams - Create and translate Entity Relationship (ER) Diagrams using a software diagramming tool.


  4. Ethics - Explain common ethical issues related to the use of information technology systems and the handling of data, including privacy and security issues.


  5. Structured Query Language - Write operational and correct SQL (DDL, DML and DCL) statements.


  6. Data Mining and Big Data - Describe new concepts and terminology in DBMS such as Data Warehousing, Data Mining, NoSQL and Big Data.


  7. Database Design - Implement a relational database from initial requirements and conceptual design (ER Diagram) to the physical database in a modern enterprise relational database management system

 

Upon completion of this course students will be additionally be able to:


1. Design and Create Conceptual Relational Database Using a professional modeling application

2. Implement Physical Database from a Conceptual Design

3. Work as part of a professional team to design, code, test and debug normalized databases

4. Correctly use the elements of Relational Algebra retrieving result sets from relational databases

5. Create source code and execute SQL statements that are syntactically correct

6. Demonstrate a knowledge of input and output routines, data types, and data operations

7. Demonstrate a knowledge of key concepts in Database Theory

 

Outcomes for Chapter 1

 

Link to Audio of Text

 https://access.sensus.dk/sb4/sb4amrsp/rba20-14-04-2020-95539.mp3 Links to an external site.

 

 

  • The difference between data and information

     

  • What a database is, the various types of databases, and why they are valuable assets for decision making

     

  • The importance of database design

     

  • How modern databases evolved from file systems

     

  • About flaws in file system data management

     

  • The main components of the database system

     

  • The main functions of a database management system (DBMS)