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!
If R1 and R2 are two relations or functions, then the result of R3 = R1 × R2 is the combination of tuples that are in R1 and R2. The product is associative and commutative.
Degree (R3) =Degree of (R1) + Degree (R2).
In case, R3 will have tuples such that R3 = {t1 || t2 | R1 ∋ t1 ∧ R2 ∋ t2}.
Example:
R2
A
B
A1
B1
A2
B2
A3
B3
A4
B4
R1
C
C1
C2
R3 = R1 × R2 is
Q. Explain data aggregatio n and discuss different design constraints. Sol. Aggregation One limitation of the E-R model is that it cannot express relationships amon
How many types of users works on database? Users are differentiated through the way they expect to interact along with the system (i) Application programmers-interact with
Briefly describe the different kinds of users of a DBMS. Ans: Different sorts of DBMS users are: (a) Software Engineers: These are the people accountable for developing ap
what is inverted and multilist structure
SET concept is used in which type of modelling? SET concept is used in Network Model.
Components of database manager The above functions are reached by the database manager. The major elements of a database manager are: Authorisation control: This mod
The physical location of a record is determined by which mathematical formula that transforms a file key into a record location? The physical location of a record is determined
What are called jukebox systems? Jukebox systems have a few drives and numerous disks that can be loaded into single of the drives automatically.
Having Clause with sub queries: First we have to recollect the GROUP BYclause. The following query searches the minimum salary in every department. SELECT DEPTNO, MIN (SAL)
Which data manipulation command combines the records from one or more tables ? JOIN data manipulation command combines the records from one or more tables.
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd