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!
Attributes having a one value for a particular entity.
For instance, Age is a single valued attribute of a student entity.
Attributes that have more than single values for a specific entity is known as a multivalued attribute. Different entities may have dissimilar number of values for these types of attributes. For multivalued attributes we can also states the minimum and maximum number of vales that can be attached. For instance, phone number for a person entity is a multivalued attribute.
The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but
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 represen
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)
FDs in Entities : Student entity : Enrolment number → Student name, Address Course Entity :
Differentiate between the object oriented decomposition and the structured decomposition? Process-oriented (structural) decomposition divides a complex process, function or tas
What is the used of specifying alias? Specifying alias: is used to rename column or attribute in a table.
Increased parallelism : Since the replicated date has several copies a query can be distributed or can be answered from the smallest loaded site. Also, with more replicas you have
draw ER diagram of student entity and course entity where attribute of student entity are student roll, student name, student phone and student address and attribute of course enti
What are the three data anomalies that are similarly to take place as a result of data redundancy? Can data redundancy be completely eliminated in database approach? Why or why n
Which method of access uses key transformation? A Hash method of access uses key transformation.
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