logging in or signing up ADVANCE DATABASE MANAGEMENT SYSTEM aSGuest52798 Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: Embed: Flash iPad Dynamic Copy Does not support media & animations Automatically changes to Flash or non-Flash embed WordPress Embed Customize Embed URL: Copy Thumbnail: Copy The presentation is successfully added In Your Favorites. Views: 1758 Category: Entertainment License: All Rights Reserved Like it (0) Dislike it (0) Added: July 04, 2010 This Presentation is Public Favorites: 1 Presentation Description No description available. Comments Posting comment... Premium member Presentation Transcript ADVANCE DATABASE MANAGEMENT SYSTEM : ADVANCE DATABASE MANAGEMENT SYSTEM “Schema” Definition of Schema : Definition of Schema is a complete description of the content and structure of the fields, records, and data relationship for the database. Example Kinds of Schema : Kinds of Schema Conceptual Schema Logical Schema Physical Schema Schema Objects Conceptual Schema : Conceptual Schema Also known as conceptual data model, is a map of concepts and their relationship Logical Schema : Logical Schema Is a data model of a specific problem domain expressed in terms of a particular data management technology. Physical Schema : Physical Schema Is a term used in relation to data management Schema Objects : Schema Objects Is a logical data storage structure. Schema Objects : Schema Objects Table Views Sequences Synonyms Indexes Clusters Database links snapshots procedures functions packages Table : Table Is a set of data elements (values) that is organized using a model of columns and rows. Example Views : Views A view consists of a stored query accessible as a virtual table composed of the result set of a query Sequence : Sequence Is an ordered list of objects or Event). Example Synonyms : Synonyms Is nothing more than an alias or alternate name for a table, view, sequence or other Schema objects. Indexes : Indexes Is a data structure that improves the speed of data retrieval operations on a database at the cost of slower writes and increased storage space. Snapshots : Snapshots Refer to an actual copy of the state of a system. Example Slide 17: A, B, C, D….. 1, 2, 3,…. L, O, V, E Thank you For Listening : Thank you For Listening Reported By: Frank G. Corpuz Farrah Jane Austria You do not have the permission to view this presentation. In order to view it, please contact the author of the presentation.