Differance between ddl and sdl, Database Management System

Assignment Help:

Differance between DDL and SDL?

DDL and SDL - The data definition language (DDL) is used through DBA and database designers to describe internal schema, conceptual schema, and mappings between these two. In a few DBMSs, a clear separation is maintained among conceptual schema and internal schema. In that case, DDL is used to exact the conceptual schema only. The other language, storage definition language (SDL) is used to specify the internal schema. The mappings among the two schemas may be specified in either one of these languages.


Related Discussions:- Differance between ddl and sdl

What is a merge sort, QUESTION (a) Using an appropriate example, explai...

QUESTION (a) Using an appropriate example, explain what is a recursive function? (b) Explain in detail the C++ function given below. void search2(int list[],int n,int ele

Explain strict two-phase locking, Explain Strict Two-Phase locking A tr...

Explain Strict Two-Phase locking A transaction T does not release any type of its exclusive (X) locks until that transaction commits or aborts. In this method no other transact

Data base design, how to design a bakery business in data base

how to design a bakery business in data base

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))

Group by clauses-data manipulation language, Group By clauses  • It is ...

Group By clauses  • It is used to group database tuples on the basis of definite common attribute value like as employees of a department. WHERE clause still can be used

Transactions t1 and t2 are in a deadlock, Evaluate: a.When transactions...

Evaluate: a.When transactions T1 and T2 are in a deadlock, one of the transactions will eventually implement to completion and let the other one continue implementation. b.

ER diegrams, How to draw an ER diagram to a finance companz

How to draw an ER diagram to a finance companz

Define weak and strong entity sets, Define weak and strong entity sets?  ...

Define weak and strong entity sets?  Weak entity  set:  entity  set  that  do not  have  key  attribute  of  their  own are  known as weak entity sets.  Strong entity set

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd