Interested to Buy Any Domain ? << Click Here >> for more details...
What is database schema?
- 4 Answers
- 16120 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jaya shanker prasad
The overall design of the database structure is called
database schema.for example the lecturer will go to the
class room only the part of the database schema that is
attendence register.
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / v p sharma
The term schema refers to the overall design of the data
base. it is a logical database description and is drawn as
a chart of the type of data that are used it gives the
name of the entity and relationship between them for eg an
information display system that gives info about arrival
and departure of train and aircraft at stations. the schema
will remain the same though the values diplayed in the
sysytem will change from time to time. the term subschema
refers to the same view but but for the data item types and
record types which are used ina particular application or
by particular user.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / dbramesh
Schema is where all the user objects are logically grouped.
usage of Schema and user are interchangeble
Schema is an user
schema is for users
Cheers,
Ramesh
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / neeraj sharma
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
| Is This Answer Correct ? | 3 Yes | 0 No |
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)
Explain the difference between a data block, an extent and a segment.
can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )
how to create an user in oracle 10g.please give me an example..
What is the difference between recovery and restoring of the oracle database?
what is correlated subquery
How to clone the database using RMAN back
Explain the difference between a hot backup and a cold backup and the benefits associated with each
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
how can we send a concurrent program output to the clients through mail or fax give me example.
Oracle General 
