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 are the DBMS languages? Briefly explain?
Data Definition language (DDL):A database schema is specified through a set of definitions expressed through a special language called data definition language. For instance, the subsequent statement in the SQL describes the account table
Create table account (account_number char(10), balance integer)
Execution of the above DDL statement creates the account table. DDL permits a user to specify storage structure and access techniques used through the database system as well as specify certain consistency constraints such as balance of an account should on fall below Rs1000.
Data Manipulation language (DML): A data-manipulation language (DML) is a language which enables users to access or manipulate data as organized through the appropriate data model.
There are basically two types:
1) Procedural DMLs needs a user to specify what data are required and how to get those data. 2) Declarative DMLs (also referred to as nonprocedural DMLs) need a user to specify what data are required without specifying how to get those data.
Question 1 Draw a Data Flow Diagram for a University scenario Question 2 Discuss the following with suitable examples Relational Algebra Operators Database Pla
(1) Insert into PERSON Violated constraint: - Key constraint Reason: - Primary key 1 already exists in PERSON. Dealing: - DBMS could ask the user to provide valid PER
what factors might influence a company to outsource its IT infrascture.
Question : (a) Differentiate between database integrity and database security (b) Database security involves measures to avoid loss of privacy and loss of confidentiality. D
1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an
State about the Tables- DBMS Data is stored in columns and rows (much like a spreadsheet -main difference is how data is organised). Every row in a table is known as a record
Data Definition Language It organises the data in the form of columns and rows. But what does the data field column of table accumulate? How do you describe it using SQL? Th
The ABC Bank authority now wants to create a database for their customers. So you are requested to modify your program of Assignment A3 as follows. The main program first displa
Explain the term - Adjustment of inheritance The inheritance can be enlarged as object design progresses by changing class structure. The designer should do: i) Adjust or r
Now that she understands more about the benefits of databases, the play-scheme manager would like to extend the play-scheme database to include data for schools and instructors as
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