9) Name the level to represent an organization view in the three-level ANSI-SPARK architecture.
10) Name the terminology of storing subject-oriented, integrated, time variant and nonvolatile data for generating useful decision making report.
9. There are three levels in the three tier ANSI SPARC architecture:
Internal level
conceptual level
External level
External level helps to represent organization view as it contains schema that is called view schema and also describes the end user interaction with the database.It helps to end to end interaction giving the view of the database to the user.
In this user dont have to worry about the schema used and concept used in the database.
10. This terminology is called data warehousing which helps in decision making process in the system as it contains all the data including all raw and facts table .
If you like my answer please give a thumbsup and if you have any query please get back to me in comment section will be happy to help you.
Get Answers For Free
Most questions answered within 1 hours.