.

Saturday, July 27, 2019

Evaluating my course project Essay Example | Topics and Well Written Essays - 250 words

Evaluating my course project - Essay Example Further, there are parameters especially in the physical storage that are important in developing the model using a data definition language. That is what is used to create the database. The creation of the database structure consisted of establishing the number of tables, the fields to use and the records of those tables. The three tables are a result of a thorough normalization process to minimize redundancies of information. It included going through the first normal form, the second and the third form of normalization (Morris, 2014). I then created an entity relationship diagram to map the type of relationships in the architectural engineering database. The implementation stage also included coming up with data dictionaries for the three tables. I also examined the relationships critically to ensure that there is the consistency of information especially on similar fields in different tables. These connections are important in restricting redundancies. Further, I went on to look at the queries that will allow the users to retrieve information from the database that meets particular conditions. The questions included joining information from more than one table and grouping the data based on specific criteria (Keogh, 2007). For instance, grouping of projects according to the customers. The subsequent sections of the report examined the errors the architectural engineering database is likely to encounter such as read data and multiplicity update problem. In addition, it also includes a section covering the best practices for building and implementing the database (Morris, 2014). These are standard procedures already acceptable in the market. The final stage is the conclusion that states the use of Microsoft Access as the relational database of choice. It further states that a database requires maintenance after designing and its

No comments:

Post a Comment