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 data model? Explain object based and record based data models?
Ans: A data model is an abstract model in which describes how data is represented and accessed.
(i) Object based data models: Same to a relational database model, but objects, classes and inheritance are directly supported within database schemas and in the query language
(ii) Record based data models: is a database model based on first-order predicate logic. Its core idea is to elaborate a database as a collection of predicates over a finite set of predicate variables, describing constraints on the possible values and combinations of values.
Let us now talk about the relational operations: SELECT The select operation is used to select few specific record from the database based on different criteria, This is a un
Consider the following relations: S (S#, SNAME, STATUS, CITY) SP (S#, P#, QTY) P (P#, PNAME, COLOR, WEIGHT, CITY) Give an expression within SQL for each of queries b
Group By clauses • It is used to group database tuples on the basis of definite common attribute value like as employees of a department. WHERE clause still can be used
A Data Model in software engineering is an abstract model that organizes and documents the business data for interaction between team members and is used as a plan for creating
Consider the subsequent relations RENTER(rno, fname, lname, address, tel_no, pref_type, max_rent) VIEWING(rno, pno, date, comment) PROPERTY_FOR_RENT( pno, street, area ,city,
Using SQL create a view RS for the relations R and S. The view consists of the columns A and D renamed as X and Y in that order. Insert a tuple into it. Show the contents of t
draw er diagram using entities crop,employee,department,plot,cultivation plan,machinery,seed,fertilizer
Failures and Recovery In practice various things might occur to prevent a transaction from completing. Recovery methods are used to bring database, which does not satisfy consi
Hardware failure : Hardware failures are the failures when some disk or hardware chip fails. This may result in loss of data. One such trouble can be that a disk gets damaged and
Write short notes on tuple relational calculus. The tuple relational calculation is anon procedural query language. It defines the desired information without giving a particul
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