Practical and applied approach to database management design and development. Introduction to database planning, design and management, data modeling and representation, and fundamental concepts of database access. Includes the study of design models with a focus on the relational model and includes the commonly used database systems. Will include hands-on experiences. Prerequisite: CIT 168.
At the end of this course, students should be able to:
CIT 214.1 Explain common database terms and concepts.
CIT 214.2 Apply SQL to create, read, update, and delete relational tables and records.
CIT 214.3 Apply recognized database principles such as basic entity relationship modeling to develop database designs.
CIT 214.4 Design and implement a normalized relational database.
CIT 214.5 Describe current trends in the database field.
CIT 214.6 Identify factors that need to be considered when selecting database management systems.
This is my final project for the course. We started out in the course going through learning the forms of normalization up to normal 3, making ER diagrams where I preferred to use crow's foot notation, and finally making the databases in SQL. This is a compilation of those efforts throughout the class.
I learned a lot in this course about the foundation for a database. Making the dependency diagrams takes a lot of logical thinking breaking off into the normalizations. Then thinking about the relationships to each table in the ER diagram can be a little tricky. Once you have the data table in my opinion making the SQL databases isn't very difficult. Thinking about what the user would want as search queries and reports was very interesting. Then having to come up with the code to fulfill those demands. Populating test data is tedious I imagine even more so for larger databases. I'm looking forward to my own database projects in the future and feel this course gave me the prerequisite knowledge to do that.
Contact austincshaw@gmail.com to get more information on the project