+1 vote
187 views
in Database Management Systems by

1 Answer

+1 vote
by
selected by (user.guest)
 
Best answer

Data-Definition Language

We specify a database schema by a set of definitions expressed by a special language called a data-definition language (DDL).  

For instance, the following statement in the SQL language defines the account table: 

create table account (account-number char(10), balance integer) 

Executionn of the above DDL statement creates the account table. In addition, it updates a special set of tables called the data dictionary or data directory.  

A data dictionary contains metadata—that is, data about data. The schema of a table is an example of metadata. A database system consults the data dictionary before reading or modifying actual data.  

We specify the storage structure and access methods used by the database system by a set of statements in a special type of DDL called a data storage and definition language.  

These statements define the implementation details of the database schemas, which are usually hidden from the users.  

Related questions

+1 vote
1 answer 132 views
+1 vote
1 answer 195 views
+1 vote
1 answer 44 views
+1 vote
1 answer 72 views
+2 votes
1 answer 239 views
0 votes
1 answer 26 views
+1 vote
0 answers 16 views
+1 vote
1 answer 99 views
+1 vote
1 answer 99 views
+1 vote
1 answer 73 views
+1 vote
1 answer 163 views
+1 vote
1 answer 153 views
+1 vote
1 answer 68 views
+1 vote
1 answer 322 views
0 votes
2 answers 275 views
+2 votes
1 answer 145 views
asked Aug 14 in Database Management Systems by (user.guest)
+2 votes
1 answer 384 views
+2 votes
1 answer 1.4k views
+2 votes
1 answer 486 views
+2 votes
1 answer 153 views
+1 vote
1 answer 118 views
+1 vote
1 answer 181 views
+1 vote
1 answer 56 views
0 votes
0 answers 44 views
0 votes
0 answers 30 views
0 votes
1 answer 102 views
+1 vote
1 answer 87 views
0 votes
1 answer 265 views
0 votes
1 answer 190 views
0 votes
1 answer 230 views
0 votes
1 answer 546 views
+1 vote
1 answer 193 views
Welcome to CPENTalk.com
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...