JustAnswer
DBM 380/Online Individual Assignment Rubric Template – Week 4Complete the following individual assignment. And post it to the Individual forum by Monday.The following assignment is based on the database environment chosen and created in the Week Three Individual Assignment.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 created in Week Three to 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.Submit the ERD and final database to the appropriate Assignment link by Monday (day 7).What I expect:ERD complete and normalized with all entities, their identifiers, attributes, relationships and cardinalities. If you don’t have Visio you can create the ERD using Access Relationships Diagram (under Database Tools menu)Tables normalized: each table contains only attributes of one entity, primary key defined and foreign keys.Database design best practices applied: tables (of operational databases) store only atomic elements (calculations and totals are not stored in the tables. They can be calculated on fly when needed)Test data is providedAt least one query that joins two tables and returns values from both tablesNormalization – grading form Content and Organization? 100 PointsPoints Earned:98/100Comments:? ? ? All key elements of the assignment are covered in a substantive way. The paper presented:ERD CompleteEach entities with attributes and identifiersRelationshipsCardinalities10/1010/1010/1010/10ERD completed in Access/Visio:Six entities with attributes and identifies. Identifiers were correct. Relationships were definedCardinalities were determined NormalizationEach table is normalizedDatabase design best practices appliedTest data is providedAt least one query that joins two tables and returns values from both tables20/2020/2010/108/10NormalizationTables were normalized: repeating fields were not found Database design best practices applied: only atomic values were stored in the database and calculated fields were not stored Tables were filled with test dataQuery joining at least two tables was presented in Word. Where is the SQL code for the query?Total 100 PointsPoints Earned:98/100Comments: Well done! All key aspects of the database modeling and normalization were contemplated in the assignment. ERD was drawn and design was normalized. Database with some test data and sample queries were presented ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.