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!
Strong entity set and weak entity set?
Strong entity set and weak entity set: A strong entity set has a primary key. All tuples in the set are distinguishable through that key. A weak entity set has no primary key unless attributes of the strong entity set on that it depends are involved. Tuples in a weak entity set are partitioned according to their relationship along with tuples within a strong entity set. Tuples within each partition are distinguishable through a discriminator that is a set of attributes. A strong entity set has a primary key. All tuples in the set are distinguishable through that key. A weak entity set has no primary key unless attributes of the strong entity set on that it depends are included. Tuples in a weak entity set are partitioned according to their relationship along with tuples in a strong entity set. Tuples within every partition are distinguishable through a discriminator, which is a set of attributes.
Define instance and schema? Instance: Collection of data kept in the data base at a particular moment is known as an Instance of the database. Schema: The o
What kind of advantages to copying records from one table to another? -) When an algorithm that modifies a table is used after that it's safer to work with the copy -) When
I need help with data warehousing and business intelligence course project about designing a data warehouse for a jewelry company that does not have one
Many-to-many : Entities in A and B are related with any number of entities from each other. Example: Taught_by Relationship among course and faculty. One faculty member ca
Question 1 Discuss the classification of DBMS based on location of database Question 2 Explain with examples different SQL commands used for creating and deleting relations.
Define the concept of generalization A generalization is relationship between specific kind of thing and general thing. It is also known as "is-a-kind-of" relationship. Inher
triggering
Describe the tools that are available for managing MySQL Server. Given below are the tools to manage MySQL server: mysqld - MySQL server daemon. This is used to begain t
Explain sorted File with advantages? Sorted file The sort utility shall perform one of the subsequent functions: 1.Sort lines of all the named files together and write the
How does a query tree represent a relational algebra expression? Discuss any three rules for query optimisation, giving example as to when should each rule be applied. Ans
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