DATABASE DESIGN
Project Title:
Managing a Database
Project Description:
Updating, removing, and inserting data in the Database. Running queries on
single and multiple tables in the database,
Associated Course:
CMIS 350 (Database Design)
Associated Course Description: Basic concepts/terminology of
relational models with emphasis on current technology and business
applications including SQL.
Materials/Technology Used:
Wordpad, WinScp, Microsoft Office document, Putty, Laptop
| Skills | Details |
|---|---|
| Database Management | Managed database record by removing duplicate data and merging relevant data and record based on Primary key assignment, which is identified as a unique data in the table. |
| Structural Query Language (SQL) | Used SQL to run query on the database that either modify the data or output the data. |
| Entity-Relationship Diagram (ERD) | Designed Entity-Relationship Diagram (ERD) to give a visual representation of the entities on the database record and how tables and entities relate with other tables and entities. |
| Normalization | Transformed table from original form to normalized form. |
Description:
The database should contain a non-redundant data and non-duplicate record and data that can easily
be index based on the table's primary key.
Result:
A database system that contain no duplicate record with unique primary key and other key that help
identify a table and its relationship with other tables.
Reflection:
I learned how to manage the database and output data to the screen using SQL queries. I also learned
how to read an ERD diagram to understand how a databse system is creted and maintained.