The objective highlights the indispensable role of databases in supporting the infrastructure of modern daily life, from online transactions and search engines to course catalogs, emphasizing our reliance on them for various aspects of daily living. It underscores the importance of proper design, implementation, and management of databases, especially in the context of the expanding Internet of Things and the growth of online transactions, pointing out that these areas offer numerous employment opportunities. The project discussed aims to guide readers through the processes involved in the design, development, and implementation of a relational database, underlining the critical nature of databases in our increasingly digital world.
Therefore my objective was to "Design a database system using ER diagrams and normalization. Create the database in a Relational Database Management System using SQL and create queries to retrieve data from the database."
Files Associated to This Project
For this part of the project I had to install the software onto my systems and it up to create the database with the Server Site and Company information.
For this phase of the project I had to create tables that would store the data for the company and use multi-references to cross with other tables using Primary keys and look up fields.
For this part of the project I was tasked with creating the company queries that the users would need to retrieve the data. I also had to cross reference several tables using the queries to create user friendly interfaces for the for UI.
The final phase of the project was to test the UI for interactivity, and check to make sure that the queries quired correctly. After finishing the testing the project was handed off to another team.
Helping Small Business Compete With Corporations
0 Comments