Hi guys are these defintions up to par? I\'m not sure if Ishould add more or not
ID: 3608586 • Letter: H
Question
Hi guys are these defintions up to par? I'm not sure if Ishould add more or not, I want to make sure I'm getting my pointacross:External Level
This I think is just the user view of the database, nothing indepth about the relationships.
Conceptual Level
This is more of what a data architect would be invovled withbecause it describes what kind of data is stored in thedatabase.
Internal Level
This is more of a physical representation of database perhaps likethe exact tables, etc.
Logical Data independence
When you change the external schema it doesn't change theconceptual schema .
Physical data independence
Changes to the internal scheme doesn't affect this
Explanation / Answer
External Level Its the user view of the database, describes the part of databasewhich is relevant to a particular user Conceptual Level Community view of database, describes what kind of data is storedin the database and relationship among data. Internal Level Physical representation of database,describes how data is stored ina database. Logical Data independence Immunity of external schema to changes made in conceptual schema. Physical data independence Refer to immunity of schema to changes made in internal schema.
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.