Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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.
File Organisation In Dbms Introduction Databases are used to store information. Usually, the principal operations we have to perform on database are those relating to:
Determine the concept of Process Process: A process transforms the data values. It is represented as ellipse containing a description of transformation. Each procedure has a
Consider employee table of (i) and list names of department(s) for which average salary for department is more than 10,000. (SELECT d_name FROM dept WHERE d_code IN (SELECT d_c
What is Primary key? Primary Key - Primary key is one of the candidate keys which uniquely identifies each row in the relation.
. Ashutosh Dubey who is the director of Gyan Gurukul want a three-level schema architecture for the Gyan Gurukul Company that provide better security also design a data abstraction
Explain the Exec statement in SQL Ans: Exec statement has the structure EXEC SQL END-EXEC Embeded SQl statements are of a form identical to non embedded SQL statem
Write short notes on relational model The relational model uses a collection of tables to show both data and the relationships between those data. The relational model is an ex
The physical location of a record is determined by which mathematical formula that transforms a file key into a record location? The physical location of a record is determined
examples of fields in a database
Explain the Project-Join normal form A relation R is in PJNF along with respect to a set of functional dependencies D if for all join dependencies of the outline *(R 1 , R 2 ,
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd