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!
Discuss the count function?
The COUNT function used returns the number of tuples or values fixed in a query.
The count function comprises two types of syntax: (1) COUNT (*) - returns the number of rows in the result query, (2) COUNT ([DISTINCT] ) - in this means, the NULL values are discarded and if employed then the duplicates are as well discarded in the count.
Project Description: I would like to get a database of a website which has clients email name and phone number. If you are able to get information from a website, by entering
The PROJECT operation The project operation is used to choose the records with specified attributes as discarding the others based on some related criteria. This is denotes as ∏
Selective replication: This is a combination of generating small fragments of relation and replicating them rather than a entire relation. The data should be fragmented on require
QUESTION (a) Consider a car database consisting of car model, car make, car origin, Engine capacity, color, cost.
Write short notes on data ware housing? Data ware housing applications needs the transformation of data from many sources into a cohesive reliable step set of data configured a
File Organisation And Its Types Just as arrays, trees, lists and other data structures are used to execute data Organisation in main memory, a number of planning's are used to
What are the disadvantages of relational data ? Disadvantages • Performance - If the number of tables among that relationships to be established are large and the tables t
Consider the following relational schema: Doctor(DName,Reg_no) Patient(Pname, Disease) Assigned_To (Pname,Dname) Give expression in both Tuple calculus and Domain calculus for
Serialisable Schedules: If the processes of two transactions conflict with each other, how to verify that no concurrency related problems have happened? For this, serialisability t
Describe the GRANT function and explain, how it associates to security. What kind of privileges may be granted? How are they revoked? Ans: Since more than one user can aacce
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