Database design Essay Example | Topics and Well Written Essays - 500 words

Database design - Essay Example From the introduction, I learned that the idea of database management system arose as a result of the unending complexities associated with managing data using spreadsheet. Though the spreadsheet enables on to store various data, it is difficult to manage it because the data in different sheets are disjointed (Brathwaite, 2012). The spreadsheets do not a have tools which enables data which are related to be linked. I also learned about database management systems. These are software package or a set of programs that are used by the people to interact with the database system. These packages were developed because managing the database is a complicated and inherent task. The DBMS enable complete manipulation of the underlying database. The diagrams representing the interaction between the programs, user, database and database management system enabled me to internalize the database design concept. Considering the strength and weaknesses of the database, I realized that database system is inherently important to any organization which uses a computerized system. The advantages outdo the disadvantages by far. The henry books database case is an ideal case study for database design. It provides all the information required in designing a database system. The course also introduced me to relational databases and different low level programming features such as Query-By-Exam (QBE), simple and compound query criteria, database fields, tables and functional. All these are programming features used when designing and developing a database system. I also learned about different features used in manipulating data in the database system. These include and not limited to co sorting, joining tables, the use of update query statements, make table query, delete-table query, select, project data select and normal sets. The case study gave detailed illustrations of these database features. The course also introduced me to