Test my Merit My Results Create Exam

Higher Study | DBMS | Introduction and ER Model

Given the basic ER and relational models, which of the following is INCORRECT?
Consider the results of a medical experiment that aims to predict whether someone is going to develop myopia based on some physical measurements and heredity. In this case, the input dataset consists of the person’s medical characteristics and the target variable is binary: 1 for those who are likely to develop myopia and 0 for those who aren’t. This can be best classified as
Which of the following is/are true with reference to ‘view’ in DBMS? (a) A ‘view’ is a special stored procedure executed when certain event occurs. (b) A ‘view’ is a virtual table, which occurs after executing a pre-compiled query. 
Let E1 and E2 be two entities in an E/R diagram with simple single-valued attributes. R1 and R2 are two relationships between E1 and E2, where R1 is one-to-many and R2 is many-to-many. R1 and R2 do not have any attributes of their own. What is the minimum number of tables required to represent this situation in the relational model?
In ER-diagram, total participation of an entity into a relationship is shown using:
Consider the "Supply" relationship relating the entities "Supplier" and "Product". Under default assumption. what will be the cardinality of the "Supply" relationship?
Which of the following components is not a part of Entity Relationship Diagrams?
Which of the following statements is/are TRUE? (i) Weak entity has always total participation in the identifying relationship. (ii) Every relation schema must have at least one weak entity.
Which of the following defines the process of organizing data by relevant categories, so that it can be used and protected more efficiently?
Which of the following is an effect of the database system of managing customer database ?
An aggregation association is drawn using which symbol?
Consider the following Entity Relationship Diagram (ERD)  Which of the following possible relations will not hold if the above ERD is mapped into a relation model ?
Conceptual level, internal level and External level are three components of the three-level RDBMS architecture. which of the following is not of the conceptual level? 
Which one is not a database management software?
Consider the following statements regarding database normal forms: 1. Any relation with two attributes is BCNF. 2. Lossless, dependency - preserving decomposition into BCNF is always possible. 3. Lossless, dependency - preserving decomposition into 3NF is always possible. 4. BCNF is stricter than 3NF. Which of the above statements are correct?
Ads