Access Millions of academic & study documents

DBMS 663 Network Infrastructure Presentation

Content type
User Generated
Subject
Powerpoint
Type
Presentation
Showing Page:
1/33

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/33

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/33

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 33 pages?
Access Now
Unformatted Attachment Preview
Database Environment Three Level Architecture Uses ….. External Level Conceptual Level Internal Level Physical Data Organization Views Views Views Conceptual Schema What data is to store in DBMS Internal Schema How data is to store in DBMS Database External Level ◼ ◼ ◼ ◼ The users’ view of the database. This level describes that part of the database that is relevant to end users. External level consists of a number of different external views of the database. The external view includes, entities, attributes and relationships that the user is interested. Other entities, attributes or relationships that are not of interest may be represented in the database and user will be unaware of them. Conceptual Level ◼ ◼ The community view of the database. This level describes what data is stored in the database and the relationship among the data. It represents: ❑ ❑ ❑ ❑ All entities, attributes and relationships The constraints on the data. Semantic information about the data. Security and integrity information Internal Level ◼ ◼ The physical representation of the database on the computer. This level describes how the data is stored in the database. The internal level contains: ❑ ❑ ❑ ❑ Storage space allocation for data and indexes. Record description for storage (with stored sizes for data items) Record placements. Data compression and data encryption techniques. Physical Level (Physical Data Organization) ◼ ◼ ◼ ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Documents