Tuesday, June 18, 2019
Evaluating my course project Essay Example | Topics and Well Written Essays - 250 words
Evaluating my course project - Essay ExampleFurther, there are parameters especially in the physical storage that are important in developing the model using a data definition language. That is what is single-valued functiond to create the database.The creation of the database organise 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 education. It included going through and 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 technology 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 connectio ns are important in restricting redundancies.Further, I went on to look at the queries that volition 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 peculiar(prenominal) 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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment