Week 3. Discussion
Entity Relationship Diagram
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 2.2, 3.2services?
2. Write a 200- to 300-word short-answer response for the following:
•What are four types of cardinality constraints? Provide personal examples of each.
3. 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.
4. 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.
5. Write 200- to 300-word short-answer response to the following:
What is the difference between a database and a table?
6. Write 200- to 300-word short-answer response to the following:
What does it mean to say that a database displays both entity integrity and referential integrity?
7. Write 200- to 300-word short-answer response to the following:
Why are entity integrity and referential integrity important in a database?
8. Write 200- to 300-word short-answer response to the following:
What are the requirements that two relations must satisfy to be considered union-compatible?
APA format requires a concluding paragraph which sums up the wholepaper.
Format your paper consistent with APA guidelines.
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.
Note. The database environment chosen will be used in the Weeks Three and Four Individual Assignments.
Format your paper consistent
dbm_380___database_concepts_wk3.docx
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more