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!
A relation has:
Relational Schema:
A relational schema shows the relation's name, its attributes and the domain of every attribute. If R is the name of a relation and A1, A2...An is a list of attributes showing R then R (A1, A2...An) is known as a relational schema. Every attribute in this relational schema takes a value from some explicit domain called Domain (Ai).
For instance, the relational schema for relation PERSON as in Figure will be: PERSON (PERSON_ID:integer, NAME: string, AGE:integer, ADDRESS:string)
Total number of attributes in a relation indicates the degree of a relation. Hence the
PERSON relation includes four attributes, so this relation is of degree 4
Rearrange Classes and Operations Sometimes, the similar operation is defined across different classes and can easily be inherited from a familiar ancestor, but more often oper
Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible? Yes. Because Transact-SQL supports recursion, you can write kept proced
Why 'AS' clause is used in SQL ? 'As' clause is used for Rename operation. ‘AS' clause is used in SQL for rename operation. (e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)
Explain the following functions of Oracle with suitable examples: (i) To_Char( ) (ii) Count( ) (iii) Trim( ) (iv) Length( ) Ans: (i) To_char( ): The TO_CHAR function conver
Table_Name( attribute_1, attribute_2, attribute_3, ….. ,attribute_x) Primary Key ( attribute_1, attribute_2) Foreign Key attribute_4 References Table_Name_2 (repeat for each fore
Define data model? A data model is a collection of conceptual tools for explaining data, data relationships, data semantics and consistency constraints.
Explain Recursive relationship type? Recursive relationship type: A recursive relationship is one in that the similar entity participates more than once in the relationship
For every n-ary relationship type R where n>2, we make a new table S to represent R. We contain as foreign key attributes in s the primary keys of the relations that show the parti
The External or View Level The external or view level is the highest level of abstraction of database. It gives a window on the conceptual view, which permits the user to see
Explain the Dynamic Hashing Techniques There are two methods in it: extendible hashing - stores an access structure in addition to the file, and therefore is somewhat identica
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