Maddy VanSpeybroeck Info 330 Blog

Relational Database Design Process             A relational database’s design is based on the relationships that different entities in the database have with each other. This approach allows for data to be navigated in logical and user-friendly ways. In the early stages of database design all of the different features of the database will be present but poorly organized. Good database design allows ensures that these entities will be displayed logically, and data can be easily interpreted and manipulated. Planning             Using a database planning tool before any features of the database are hard coded into the design will prevent an access of work. A metadata worksheet was used to design the midterm database. A metadata worksheet, as its name suggests, shows data about the data. A spread sheet is made that normalizes the data into its atomic values a...

Introduction A database will only be as good as the data it contains. When complex updates and transformations are introduced into database management there is potential for the data to get degraded. SQL has several tools built in to maintain security and accuracy of data. These tools include views, functions, stored procedures and transactional statements. Recommended Features of Professional Databases A constraint is the first line of defense in database management to prevent “bad” data from being entered into the database. Constraints will prevent duplication, ensure data is formatted correctly and allow tables to reference each other. A view is a saved select statement; views are recommended for use in database design as it allows developers to work with a copy of the data, preserving the integrity and allows developers to work around complex SQL code. A stored procedure returns single or multiple values from a database and can accept different parameters to cr...