Description of this paper

week 3 dbm

Description

solution


Question

Supporting Activity;DBMS and Data Mining;Write a 200- to 300-word short-answer response for the following;? A motor vehicle maintenance center wants to improve its services by using database management systems (DBMS) and data mining. What tables are needed in such a database and how can it help improve their services?;1;Supporting Activity;Cardinality Constraints;Write a 200- to 300-word short-answer response for the following;? What are four types of cardinality constraints? Provide personal examples of each.;Note. The examples from the textbooks cannot be used for this question.;1;Supporting Activity;Primary Key;Write a 200- to 300-word short-answer response for the following;? How do you select the primary key from the candidate keys? How do foreign keys relate to candidate keys? Provide examples from either your workplace or class assignments.;1;Supporting Activity;Overall Design;Write a 200- to 300-word short-answer response for the following;? Under what circumstances would you break down an overall design to include individual user views? Provide examples from either your workplace or class assignments.;1;Learning Team Instructions;Service Request SR-ht-003: Change Request 3;Continue working on Service Request SR-ht-003, due in Week Five, by completing Change Request 3.;Create documentation that explains the process of creating the entity-relationship diagrams in the change request relative to this project.;Format your paper consistent with APA guidelines.;Submit a draft of your team?s documentation;2;Individual;ERD Creation Project;The following assignment is based on the database environment chosen and discussed in the Week Two Individual Assignment.;Use a Microsoft? Visio? diagram to create a detailed ERD using the data specifications noted in the Week Two Individual Assignment. Make any necessary changes provided in your faculty?s feedback.;Use a Microsoft? Access? database to create the preliminary database tables, columns with data types, primary keys, and relationships.;12

 

Paper#68922 | Written in 18-Jul-2015

Price : $57
SiteLock