Final Project Part III: Create and Evaluate ChecklistFor this assignment, create a checklist that can be used to verify that the Logical Design has addressed the user’s requirements and includes all the database objects required at this stage of design (i.e. entities, attributes, relationships, cardinality, etc.). The checklist is something that can be used to convert a situation’s requirements into a Database Logical Design. Support your answers by providing reasons for the checklist items.Evaluate the checklist created by at least two classmates, and present your views on why you approve or do not approve a checklist item(s), if any. http://www.justanswer.com/computer-programming/5yxxh-for-logicpro-only-bit-time-sensitive.html
Browser (if necessary): IE
HiWelcome backThank you for asking me, I will cehck and reply ASAP
WelcomeDo you have 'the checklist created by at least two classmates' as you question says
I have one and that will be sufficient
Database Verification Checklist
Verify that each table contains the required number of fields for recording information. This is an important step because users will not be able to enter information if there is not field for that information.
Verify the existence of Forms and their relationship to the database. If there are existing forms they should relate to their target records.
Make sure that correct triggers are in place. For instance, If no repetition is allow, a trigger should fire a message box indicating that no duplicate is allow. Triggers can also be use for other possible types of errors due to null values, or wrong character type. They can also be use for other events, such as the execution of additional programs.
Check that each column is properly and uniquely identified. This is an important to prevent duplicate data from entering the database.
Verify that data type and values are set for each field. The purpose of this step is to prevent user errors due to typing of characters in numeric fields and vise versa. Similarly, data entry should not exceed the maximum and the minimum number of character per cell.
Make sure that proper data sorting has been set for each field. It is always good to organize data in a orderly fashion, either in an ascending or a descending order, it makes the records more accessible.
Verify that each column accepts the correct data type. This is important because if the purpose of a field is to collect numeric values for calculations, then text should not be allowed to be recorded in the field, the same applies for numeric values in text fields.
Verify the setting of minimum and maximum cardinality at each entity. If more than one student are to be taking classes at a particular is school the minimum cardinality should be >1 and the maximum can be that of (M) Many.
Check restriction for “Null” or “Not Null”. This is important to make sure that users do not leave empty cells.
Test any existing query to make sure that they return desired results. Each query should include only specific data. So, eliminating any unnecessary record from the query will facilitate the understanding of the results.
Query the database for redundant data. Redundant data affects database performance, so it is good to delete any duplicate record.
Delete any existing duplicate. This will improve database performance.
Verify that referential integrity has been set and that records update accordingly. Verify that child tables are not accepting input that has already been recorded on other tables. This is important because it prevents duplicates. Similarly, updates that are made to one table should reflect on other relations.
Check that there is a correct relationship between tables by making sure that they are using an adequate type of relationship (1:1, 1:N, N:1, N:M). This is important because one customer can order many parts, and many parts can be ordered by one customer; however no part can order a customer.
Re-check Normalization. Re-check the previous steps to make sure that the database complies with proper normalization.
I will be back in one hour
Welcome lease bookmark my profile page:http://www.justanswer.com/computer/expert-logicpro/so you can come back and ask me a question anytime.If you’re a subscriber, you can ask other questions from me at no additional cost beyond your monthly payment. Rate this answer as 'Excellent Service' or ask me if you need more information