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!
Explain the concept of a data model ?
Data Model - Model is an abstraction procedure which hides irrelevant details although highlighting details relevant to the applications at hand. As same, a data model is a collection of concepts which can be used to elaborate structure of a database and gives the essential means to achieve this abstraction. Structure of database means the data types, relationships, and constraints which should hold for the data. In common a data model consists of two elements:
• A mathematical notation for expressing relationships and data.• Operations on the data which serve to express queries and other manipulations of the data.
Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher
Two Phase Locking (2PL) The two-phase locking protocol having of two phases: Phase 1 : The lock acquisition phase : If a transaction T needs to read an object, it wants to
By using the delete operation some consisting records can be deleted from a relation. To delete some definite records from the database a condition is also specified based on which
What is a virtual table that draws its data from the result of an SQL SELECT statement? View is a virtual table that draws its data from the result of an SQL SELECT statement.
What is DBMS and what are functions of DBMS? DBMS consist of collection of integrated data and set of program to admission those data. The functions performed by a typical
What is a heterogeneous distributed database? In a heterogeneous distributed database, dissimilar sites may use different schemas, and dissimilar dbms s/w. The sites may not be
Give the forms of triggers? The triggering event can be insert or delete. For updated the trigger can state columns. The referencing old row as clause The referencing
How many types of Views are there? There are Four types of views:- Database View Help View Projection View Maintenance View
Which language has presently become the defacto standard for interfacing application programs along with relational database system? The language which has recently become the
Describe the statement in SQL which allows to change the definition of a table? In SQL Alter statement is used to allow the changes the definition of a table.
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