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!
Example:
RELATIONAL SCHEMA for PERSON:
PERSON (PERSON_ID: integer, NAME: string, AGE: integer, ADDRESS: String)
RELATION INSTANCE
In this instance, m = 3 and n = 4
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
Therefore current relation state reflects only the valid tuples that show a particular state of the real world. Though, Null values can be assigned for the cases where the values are missing or unknown.
Explain the steps for reduction of E-R model into relational model. Ans:(a) Entity set in E-R model will be considered as table name in relational Model. (b) Attributes of e
explaination
Every School has many teachers and many students. Each student is assigned to one school and each teacher works for one school only. Each teacher teaches more than one subject but
Critically explained the benefits and limitations of different database technologies with proper examples
random file sharing
Normal 0 false false false EN-US X-NONE X-NONE
Determine the concept of Process Process: A process transforms the data values. It is represented as ellipse containing a description of transformation. Each procedure has a
A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;
Prepare a data flow diagram for computing the volume and surface area of a cylinder. Inputs are the height and radius of the cylinder. Outputs are the volume and surface area of th
Describe Object Relational model ? Object Relational Model - This model combines the characteristics of both relational model and object oriented model. It extends the tradit
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