DATABASE SCHEMA

 DATABASE SCHEMA

  • A Schema can be defined as the design of a database
  • The overall description of the database is called the database schema.
  • It defines how the data is organized and how the the relations among them are associated.
ex. (user store student details in Database) 

It can be categorized into three parts.



1. view schema

  • Defined as the design of database at view level
  • At view level, a user can able to interact with the system
2. Logical schema

  • Programmer work on that level
  • at this level, data can be described as certain types of data records which can stored in the form of data structure.
3. Physical schema

  • Data are storage(in bytes, gigabytes, terabytes or higher) in memory and these elements often remain hidden from the programmer.

Comments

Post a Comment

Popular posts from this blog

DBMS TUTORIALS

Image
DBMS TUTORIALS This tutorial will helpful for the students who wants to understand each and every topic of particular subject  INDEX 1. INTRODUCTION OF DATABASE What is DBMS? What is Database? Why DBMS is Important? What is DBMS vs FILE BASED SYSTEM? What is Data schemas 2. DATA MODEL What is data model? Types of Data models. what is E-R Model? what is E-R Diagram and how to draw it. 3. DR.CODD'S 12 RULES Which are Dr. Codd's rules? 4. RELATIONAL DATABASE DESIGN What is relational database design? Relational Database design part-2 What is Database joins and types of join? 5. TRANSACTION AND  CONCURRENCY What is Database Key? Which type of database key. What is Database Transaction? What is Database concurrency control? What is Database lock concurrency control? which type of lock  lock concurrency control. FINAL QUIZ
Read more

WHAT IS DBMS?

Image
 WHAT IS DBMS? WHAT IS DBMS? DBMS STANDS FOR DATABASE MANAGEMENT SYSTEM. (DBMS का मतलब है  डेटाबेस मैनेजमेंट सिस्टम ) WE CAN REPRESNET IT AS MATHEMATICAL EXPRESSION LIKE... DBMS= DATABASE + MANAGEMENT + SYSTEM NOW WE WILL LEARN ABOUT THESE WHOLE WORD... DATABASE Database is a place where related peace of information is stored and various operations can be performed on it. डेटाबेस एक एसी जगह है जहाँ पर डाटा को संगृहीत किया जाता है और उसपे कई तरह के ओपरेशन परफोर्म किये जाते है | Database means collection of interrelated data where data can be easily access, managed and updated. डेटाबेस का मतलब है  डाटा का संग्रह करना जहाँ से उसे एक्सेस मैनेज और अपडेट किया जा सके | (example:- student details) #2.MANAGEMENT A database management system is Software that provide user to stores data. डेटाबेस मैनेजमेंट सिस्टम  एक एसा सॉफ्टवेर है जो यूजर को सॉफ्टवेर के जरिये  डाटा  संग्रह करता है. It becomes easier to retrieve, manipulate and produce information for user. SYSTEM It ...
Read more

What is Database

Image
  What is Database? - The design of a DBMS depends on its architecture. -Database Architecture done through polices, rules and standards. -Architecture control that how to store data and how to use data. -Database Architecture is logically divided into three types. ONE TIER ARCHITECTURE :   (simple and easy presentation layer) All in one computer application data  presentation example: MS Office (word, Excel )  TWO TIER ARCHITECTURE : (client server architecture) Used for Application program that runs of client side clients are direct communication faster communication done by ODBC(OPEN DATABASE CONNECTIVITY) example: college/ organization THREE TIER ARCHITECTURE : (used for WEB APPLICATION) (internet) example: Facebook client-web server-Database server here, we can see that user is using a social media like Facebook so he will become client and now he will register himself and enter his details then that data will be pass to the web server. This data will be v...
Read more