|
|
|
|
Introduction to basic database development concepts. Extensive exploration of
data manipulation using a relational DBMS and SQL. Students develop a
microcomputer database application using fourth generation database technology
|
- Learn basic data management concepts. (ABET a)
- Learn the structure and methods of the relational data model. (ABET a)
- Create and manipulate relational databases using a microcomputer DBMS and SQL. (ABET a, c)
- Model logical data requirements using object-oriented techniques. (ABET a, b)
- Transform a logical data model into a relational database structure. (ABET a)
- Apply normalization techniques to a database. (ABET a)
- Understand the functions of a DBMS and database administration. (ABET a)
|
- a.
Use and apply current technical concepts and practices in the core information technologies.
- b.
Analyze, identify and define the requirements that must be satisfied to address problems or opportunities faced by organizations or individuals.
- c.
Design effective and usable IT-based solutions and integrate them into the user environment.
|
-
Communicate orally in one-on-one and group settings.
-
Make efficient use of information resources and technology for
personal and professional needs.
-
Synthesize information in order to arrive at reasoned conclusions.
-
Evaluate the logic, validity, relevance of data.
-
Solve challenging problems.
-
Apply knowledge to meet professional standards and competencies.
-
Demonstrate substantial knowledge and understanding of at least one field of study.
-
Modify their approach to an issue or problem based on the contexts and requirements
of particular situations.
|
- Database Overview & Literacy
- Data Models, with emphasis on Object-Relationship Model
- Relational Database Design
- Normalization
- Data Manipulation and Retrieval using Relational Algebra, QBE, and SQL
- Database Administration
- Putting Your Database on the Web
|
|
