Define the terms physical schema and logical schema., Database Management System

Assignment Help:

Define the terms 1) physical schema 2) logical schema.

Physical schema: The physical schema explains the database design at the physical level, which is the lowest level of abstraction describing how the data are actually stored.

Logical schema: The logical schema explains the database design at the logical level, which explains what data are keeps in the database and what relationship exists between the data.

Related Discussions:- Define the terms physical schema and logical schema.

Define the concept of design documentation, Design Documentation The ...

Design Documentation The Design Document shall be an extension of Requirements Analysis Design. "The Design Document will comprise a revised and much more detailed descrip

Computing the closure of a set of functional dependency, What is meant by c...

What is meant by computing the closure of a set of functional dependency? The closure of F denoted by F + is the set of functional dependencies logically implied by F.

DBMS, You are managing the following database system: • DBMS: Oracle 11g...

You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR manage

Assigning responsibility for operation, Assigning Responsibility for Operat...

Assigning Responsibility for Operation Many operations might have obvious target objects, but some of these operations could be used at numerous places in an algorithm, by one

Explain the shadow paging recovery technique, Explain the shadow paging rec...

Explain the shadow paging recovery technique. Ans: Shadow paging is a method used to acquire atomic and durable transactions, and provides the capability to manipulate pages i

Define the two phase locking protocol, Define the Two Phase Locking Protoco...

Define the Two Phase Locking Protocol This is a protocol that is used to make sure serializability of transactions. This protocol needs that every transaction issue lock and u

Optimistic concurrency contents -write-set(t), write-set(T): Each data ite...

write-set(T): Each data items that are written by a transaction T

Two phase locking technique, growing phase and shrinking phase are disjoint...

growing phase and shrinking phase are disjoint, why ?

Describe participation constraints, Describe Participation Constraints? ...

Describe Participation Constraints? Participation Constraints - The participation constraint exacts whether the existence of an entity depends on its being related to another

Primary key, what is primary key

what is primary key

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages