A Real-World Database Application. Think of a real-world application that uses -
ID: 3664614 • Letter: A
Question
A Real-World Database Application.
Think of a real-world application that uses -- or could use -- a database system to store its data. One example is an ATM machine or some other banking application like the one that we discussed in the lecture notes on Database Fundamentals, but you should pick something other than this for your answer.
a. Describe the application briefly, including the types of data that it uses a database to store.
b. Give an example of how the logical view of data that a database system provides would be useful in the context of this application.
c. Describe at least one other advantage of using a database system in this context. Hint: consider the other three key functions of a DBMS mentioned in the notes on Database Fundamentals.
Explanation / Answer
a) We can take an example of "Client Tracking Application", its basically an application that keep track of all of our client, who you are contacting on daily, weekly or monthly bases. The types of data that it used a database to store is as follows:
1. Id of Client (each of our client will have its own unique identification )
2. Address (address of the client)
3. Contact Name (name of the client)
4. Contact Number (telephone number of client)
5. Contact Email (email id of client)
6. Comment Section (use to add some more information of the client)
b) Logical view of data is very important in any databae system. Through logical view you can easily understand the different types of data used in database system. you can easily see the various database tables and its relations. Through logical schema you can gets the knowledge of various entities and there relationship
c) In our client tracking application, with help of database system we can easily generate reports and easily perfrom any addition or deletion of clients date with very minimul efforts