Saudi Electronic University Data Dependence Discussion and Responses
Description
Having Trouble Meeting Your Deadline?
Get your assignment on Saudi Electronic University Data Dependence Discussion and Responses completed on time. avoid delay and – ORDER NOW
1. Post your answer to the Question
Discuss the concept of data independence and justify whether it is useful or not in a database environment. Support your answer with an example. (2 marks)
2. Respond to two other classmates postings by critically reviewing your classmate’s answer
first classmate discussionData independence”Data independence” means that if you change the database schema at one level of a database system, you don’t have to change the schema at a higher level. With “data independence,” you can separate information from the applications that use it.It helps protect the data in the database even more, which is great.Example:-Take A and B, for example, two users. They’ve both chosen to look at the EmployeeNumber and EmployeeName columns.Ref: -Ludwig, C., Gillet, L., Rosenberger, G., Amon, S., Collins, B. C., & Aebersold, R. (2018). Data?independent acquisition?based SWATH?MS for quantitative proteomics: a tutorial. Molecular systems biology, 14(8), e8126.?
Second classmate discussion Data IndependenceCOLLAPSEData independence is a form of database management which keeps data separated from all programs that make use of it. Data independence can be defined as the capacity to change schema at one level without changing the schema at next higher level.Consider an example of a University Database. At the different levels this is how the implementation will look like:
Type of Schema Implementation External schema view 1: Course info. view 2: student info.
Conceptual schema Students Courses Enrolled
Physical schema Relations stored as unordered files. Index on the first column of Students.
