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!
What is DDL? Make a list of commands with short description used in DDL
Ans: Data Definition Language that is abbreviated as DDL is a computer language for defining data structures. The phrase was first introduced in relation to the Codasyl database model in which the schema of the database was written in a Data Definition Language explaining the records, fields, and "sets" making up the user Data Model.
List of DDL commands:
(a) To define a table/ relation
CREATE TABLE ------
(b) To eliminate table/relation definition
DROP TABLE ----
(iii) To alter the definition of an existing table
ALTER TABLE-------
Differentiate between Key and superkey? Key and superkey - A key a single attribute or a combination of two or more attributes of an entity set in which is used to identify o
er diagram on cosmetics.
draw er diagram using entities crop,employee,department,plot,cultivation plan,machinery,seed,fertilizer
how draw er diagram
Distributed Database Management System
Define the terms i) Entity set ii) Relationship set Entity set: The set of all entities of the similar type is termed as an entity set. Relationship set: The set of all rela
Benefits: It limits data access. It makes difficult queries look easy. It permits data independence. It presents dissimilar views of the similar data.
What is SQL Server Agent? SQL Server agent plays a significant role in the day-to-day tasks of a database administrator (DBA). It is often overlooked as one of the major tools
education.
what is union compatable?
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: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd