Database Design and Implementation. Now that you have learned the concepts of da
ID: 3920112 • Letter: D
Question
Database Design and Implementation.
Now that you have learned the concepts of database models and you have practiced creating entity relationship diagrams, let us focus on the implementation of that design into a Database Management System (DBMS).
Based on the example of the business function / operation that you described within the Weeks 1-3 discussions, describe the queries that you would need to create in order to support the business function / operation in question.
Based on the database model described in the Week 2 and Week 3 discussions for your business function / operation, determine the major / minor issues that might arise when creating these queries.
Explanation / Answer
ANSWER:
Queries that you would need to create in order to support business function:
Queries are needed because you can get answers from your data for every specific question. It is easy to answer those questions using queries rather than tables. Moreover queries are used to review, add, change or delete data from your database.
The queries that you would need to create in order to support business function are queries to filter your data, queries to perform calculations with your data, queries to summarize your data, queries to automate many data management tasks and queries to review changes your data before you commit those changes.
Coming to our example the queries that are needed to create are queries for StudentId, queries for requesting student,class and instructor for singular report for attendance related output.
Major or minor issuses that might arise when creating these queries:
The major or minor issuses that might arise when creating these queries are as the data is entered in a timely fashion so the data must be continuously modified because names will be changed and students are going to be dropp clases and enroll in another class. The data can be kept accurate and up to date by using Compliance.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.