Skip to main content

SQL Set Operators

SQL Set Operators   Traditional Set Operators: Union Compatibility:     Requirement for the traditional set operators.    Strong requirement.                         - Same number of columns.                         - Each corresponding column is compatible.                         - Positional correspondence.     Apply to similar tables by removing columns first. SQL UNION Example:           Example 1: Retrieve basic data about all university people.                     SELECT FacNo AS PerNo, FacFirstName                                      ...
Post a Comment

Correction For ERD

 d. For each consistency error in Figure 1, you should identify the consistency rule violated and suggest possible resolutions of the error. The ERD has generic names to help will concentrate on finding diagram errors rather than focusing on the meaning of the diagram.



Answer:


            Entity6 is violation of the Primary key rule. As there are 3 attributes from within Entity6 that are marked as primary key. Entity6 also violates the Identifying relationship rule, as there is no foreign key in the Entity6 table to identify the item from Entity7. Since this a weak entity type, the cardinality must be 1:1, which it is not. Entity2 is a violation of the Identifying relationship rule due to it not being a weak entity type when there is an identifying relationship.











Our Official Website : Web Conquerors (https://www.webconquerors.com/) 

Want to get digital services? Contact US

Want to know about our services? Our Services

Comments

Post a Comment

Popular posts from this blog

SQL Set Operators

SQL Set Operators   Traditional Set Operators: Union Compatibility:     Requirement for the traditional set operators.    Strong requirement.                         - Same number of columns.                         - Each corresponding column is compatible.                         - Positional correspondence.     Apply to similar tables by removing columns first. SQL UNION Example:           Example 1: Retrieve basic data about all university people.                     SELECT FacNo AS PerNo, FacFirstName                                      ...
Post a Comment
Read more

Differences Between Algorithm and Pseudocode

  "Differences Between Algorithm and Pseudocode" Algorithm Pseudocode 1.       Systematic logical approach which is a well-defined, step-by-step procedure that allows a computer to solve a problem. It is a simpler version of a programming code in plain English which uses short phrases to write code for a program before it is implemented in a specific programming language. 2.       Algorithms can be expressed using natural language, flowcharts, etc. There are several formats which are used to write pseudo-codes and most of them take down the structures from languages such as C, Lisp, FORTRAN, etc. 3.      Procedure of algorithm is like this Start from the leftmost element of arr[] and one by one compare x with each element of arr[]. If x matches with an element, return the index. If x doesn’t match with an...
Post a Comment
Read more

Entity

Entity • Object that exists and that can be distinguished from other objects  • Can be person, place, event, object, concept in the real world  • Can be physical object or abstraction  • Entity instance is a particular person, place, etc.  • Entity type is a category of entities  • Entity set is a collection of entities of same type-must be well-defined  • In E-R diagram, rectangle represents entity set. Data Modeling Concepts: Entity:      Entity instance – a single occurrence of an entity. Data Modeling Concepts: Degree: A ssociative entity – an entity that inherits its primary key from more than one other entity (called parents). Each part of that concatenated key points to one and only one instance of each of the connecting entities. Attributes: • Defining properties or qualities of entity type. • Represented by oval on E-R diagram. • Domain – set of allowable values for attribute.         ...
Post a Comment
Read more