Asked by Andy Blackwell Uncategorized
How you edit a schema?
We need you to answer this question!
If you know the answer to this question, please register to join our limited beta program and start the conversation right now!
A. What is the different between conceptual schema and external schema?
An External Schema is to support views of data and to provide programmers with easier data access, whereas a Conceptual Schema is the schematics of the Programme. It describes the things that are important to the programme. So the External schema is for user views and the Conceptual schema integrates external schematics.
What is a database schema?
A database schema is described in a formal language supported by the database management system (DBMS). In a relational database, the schema defines the tables, the fields in each table, and the relationships between fields and tables. Schemas are generally stored in a data dictionary. Although a schema is defined in text database language, the term is often used to refer to a graphical depiction of the database structure Levels of database schema 1. Conceptual schema, a map of concepts and their relationships 2. Logical schema, a map of entities and their attributes and relations 3. Physical schema, a particular implementation of a logical schema 4. Schema object, Oracle database object 5. Schema is the over all structure of the database
Asked in Microsoft Windows, Database Programming
Difference between schema sub schema and instance in DBMS in detail?
Asked in Microsoft Windows, Database Programming, MySQL
How do different schema definition languages support the three schema architecture?
Asked in Web Programming
What is xml schema?
XML Schema is an XML-based alternative to DTD.An XML schema describes the structure of an XML document.The XML Schema language is also referred to as XML Schema Definition (XSD).An XML schema is a description of a type of XML document, typically expressed in terms of constraints on the structure and content of documents of that type, above and beyond the basic syntactical constraints imposed by XML itself.
Asked in Database Programming
What are the Types of database schema architecture?
Asked in Database Programming
What are the 3 views of dbms?
Asked in Software and Applications (non-game), Database Programming, The Difference Between, Oracle Database
Difference between user and schema oracle?
The both words user and schema are interchangeble,thats why most people get confusion on this words.Below i explained the difference between them --User User is a account to connect database(Server). we can create user by using CREATE USER user_name IDENTIFIED BY password. --Schema Actually Oracle Database contain logical and physical strucutre to process the data.The Schema Also Logical Structure to process the data in Database(Memory Component). Its Created automatically by oracle when user created.It Contains All Objects created by the user associated to that schema.For Example if i created a user with name santhosh then oracle createts a schema called santhosh,oracle stores all objects created by user santhosh in santhosh schema. We can create schema by CREATE SCHEMA statement ,but Oracle Automatically create a user for that schema. We can Drop the schema by using DROP SCHEMA schema_name RESTRICT statement but it can not delete scehema contains objects,so to drop schema it must be empty.here the restrict word forcely specify that schema with out objects. If we try to drop a user contain objects in his schema we must specify CASCADE word because oracle does not allow you to delete user contain objects. DROP USER user_name CASCADE so oracle deletes the objects in schema and then it drops the user automatically,Objects refered to this schema objects from other schema like views and private synonyms goes to invalid state.