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 model in database system mostly defines the organisation of data or structure and a set of operations on that data. Relational model is a easy model in which database is represented as a collection of "Relations", where every relation is represented by a two dimensional table. Therefore, because of its simplicity it is most commonly used. The following table shows a simple relation:
PERSON_ID
NAME
AGE
ADDRESS
1
Sanjay Prasad
35
b-4,Modi Nagar
2
Sharad Gupta
30
Pocket 2, Mayur
Vihar.
3
Vibhu Datt
36
c-2, New Delhi
Figure: A Sample Person Relation
Following are some of the benefits of relational model:
The easy tabular representation of database helps the user define and question the database conveniently. For example, you can simply find out the age of the person whose first name is "Vibhu".
As the database is a collection of tables, new data can be added and removed easily. Also, manipulation of data from several tables can be done simply using several basic operations. For instance, we can add a telephone number field in the table at Figure.
In relational databases the relational algebraic operations are used to influence database. These are mathematical operations and make sure accuracy (and less of ambiguity) as compared to other models.
Our company hires independent contractors to install equipment at precise locations across North America. We want to track the installation data and generate reports. The compan
Represent the following scenarios with E-R diagrams drawn using the ER Assistant software. The diagrams should indicate cardinality and optionality of relationships. Transform each
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
what do you mean by consistency in rdbms?
What is relational model feature? A relational model feature is much more data independence than some other database models.
Process of Adjustment of inheritance During object design, inheritance is readjusted by rearranging classes and operations, and abstracting common behaviour.
Backward Recovery (UNDO): In this system the uncommitted changes made by a transaction to a database are undone. Instead the system is reset to the last consistent state of databa
Create table employee and enter employee data in SQL? Consider the following relational schemas: EMPLOYEE (EMPLOYEE_NAME, STREET, CITY) WORKS (EMPLOYEE_NAME, COMPANYNAME, SAL
What is Explicit update In explicit update, each derived attribute is defined with respect to one, or more fundamental base object(s). The object designer determines that de
Question 1: Define the term business intelligence tools? Briefly explain how the data from one end gets transformed into information at the other end? Definition Exp
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