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 two phase commit, Define Two phase commit Two phase commit: To m...

Define Two phase commit Two phase commit: To make sure atomicity, all the sites where a transaction is being executed must agree on the final outcome of the execution. The tran

Discuss the problem of spurious tuples, Discuss the problem of Spurious tup...

Discuss the problem of Spurious tuples and how we may prevent it. Ans: A spurious tuple is, mainly, a record in a database that gets created while two tables are joined bad

What is the aim of object design, What is the aim of object design The ...

What is the aim of object design The aim of object design is to identify object which the system contains and the interactions among them. The system implements specification

Explain the need for the bcnf normal form, Surgeons identified by doctor ID...

Surgeons identified by doctor ID (DOCID) operate on patients identified by patient ID (PATID) in operating theaters identified by room numbers (ROOMNO). Each surgeon can operate on

What is null, What is NULL? Simply NULL means not in value.

What is NULL? Simply NULL means not in value.

Define the one-way associations, One-way Associations When an associat...

One-way Associations When an association is traversed only in the one direction, then it is implemented as a pointer i.e.an attribute which contains an object reference. If mu

File sharing, random file sharing

random file sharing

Queries, Find the names of all Albums that have more than 30 tracks. Result...

Find the names of all Albums that have more than 30 tracks. Result: (name: varchar(255))

Functional dependency, Functional Dependency Consider a relation R that...

Functional Dependency Consider a relation R that has 2 attributes A and B. The attribute B of the relation is functionally dependent on the attribute A if and only if for every

File manager-database management system, File Manager File manager ha...

File Manager File manager handles the allocation of space on disk storage. It starts and maintains the list of structures and indices described in the internal schema that is

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages