Need help with DBM/380 Homework Your database project must …
Need help with DBM/380 Homework Your database project must meet the following assessment requirements: Design and develop a database using professional principles and standards. Provide a logical and physical design of the database. Use relational database software application to develop database. Provide an entity relationship diagram. Normalize the database. Generate and provide test data. Use a Microsoft® Visio® diagram to normalize the ERD to third normal form (3NF). Use the Microsoft® Access® database that you just created for me, create a minimum of 10 rows of test data in each table. Also, create at least one query that joins two tables and returns values from both tables. Note. Only the Microsoft® Visio® diagram must be normalized to the 3NF. The 3NF is not required for a Microsoft® Access® database.
The requirements for the database project in the DBM/380 class are quite specific. The project involves designing and developing a database using professional principles and standards. The database should have a logical and physical design, and should be implemented using a relational database software application. An entity-relationship diagram (ERD) should also be provided, which shows the relationships between the entities in the database.
One important step in the project is to normalize the database. Normalization is the process of organizing the data in a database to eliminate redundancy and ensure data integrity. It involves breaking down a database table into smaller, more manageable tables, and establishing relationships between these tables. The goal of normalization is to minimize data duplication and improve efficiency and accuracy of data querying and updating.
The project also requires generating and providing test data for the database. Test data is used to evaluate the functionality and performance of the database. It should be representative of the actual data that will be stored in the database, and should cover a variety of scenarios to ensure that the database can handle different types of data and operations.
Additionally, the project requires using Microsoft® Visio® to create a diagram that normalizes the ERD to third normal form (3NF). 3NF is a level of database normalization that ensures that there are no transitive dependencies in the database. In other words, it ensures that each non-key attribute depends only on the key attribute(s) of the table.
Finally, using the Microsoft® Access® database that has been created, the project requires creating a minimum of 10 rows of test data in each table. This is to ensure that the database is functioning correctly and can handle a reasonable amount of data. The student should also create at least one query that joins two tables and returns values from both tables. This demonstrates the ability to retrieve data from multiple tables using the relationships established in the database.
It is important to note that while the Microsoft® Visio® diagram needs to be normalized to 3NF, this level of normalization is not required for the Microsoft® Access® database. The 3NF requirement only applies to the diagram.
In conclusion, the database project for the DBM/380 class involves designing and developing a database, providing a logical and physical design, normalizing the database, generating test data, and using a Microsoft® Visio® diagram to normalize the ERD to 3NF. It also requires creating test data in the Microsoft® Access® database and creating a query that joins two tables.