Answer Posted / 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 |
Post New Answer View All Answers
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 I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
8. Supporting AP, AR and GL?
What is the importance of batch source set up in ar? : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
How many segment are present in Oracle Manufacturing
What is the disk migration? what is the steps involved in oracle disk migration?
Differentiate between transaction type and transaction source? : oracle accounts receivable
How would you go about increasing the buffer cache hit ratio?
What Are Cross Validation & Adi?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What is supporting issues GL AP and AR?
What are different types of receipt reversals ? Explain them : oracle accounts receivable