If a student studies more than one major, the "Major" attribute in the "Student" entity is called: * Multi-valued None of the above Composite Single-valued The relationship between two use cases in the use case diagram can be: * 1 point A "includes" relationship A "extends" relationship 1 point O A "depends on" relationship O All the above

If a student studies more than one major, the "Major" attribute in the "Student" entity is called: * Multi-valued None of the above Composite Single-valued The relationship between two use cases in the use case diagram can be: * 1 point A "includes" relationship A "extends" relationship 1 point O A "depends on" relationship O All the above

Fundamentals of Information Systems

8th Edition

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter8: Systems Development

Section: Chapter Questions

Problem 8SAT: Data modelling is most often accomplished through the use of a(an) ________________. a....

See similar textbooks

Similar questions

Consider a system. Let this be a car rental system. For a car rental system create a Use case diagram for your requirement that contains at least 3 actor, 10 use case and use all relationship types. Express the relationships in writing on the figure.
Use ER Assistant to draw your diagram. Draw a self-referencing entity type for the Employee entity type for which an employee is supervised by a maximum of one other employee and doesn’t have to be supervised by any employee at all. Conversely, an employee can supervise zero or many other employees. The attributes of the Employee entity are as follows: EmpNo (primary key), EmpName, EmpAddress.
A relationship between entity supertype and entity subtype is known as _______. Partial participation relationship IS-A relationship M : N relationship Total participation relationship
Explain how functional dependencies can be used to indicate the following: • A one-to-one relationship set exists between entity sets student and instructor. • A many-to-one relationship set exists between entity setsstudent and instructor.
Attributes from the identifying entity set's main key may be added to a weak entity set to make it strong. Please describe the overlap that will develop as a result of our choice.
ER model relationships are represented using a.) relationship keys b.) primary keys c.) crows foot symbols d.) main keys What do the cardinalities in an ER model show, (please select all that apply)? a.) only a one to one relationship. b.) the minimum number of entities that can be involved in a relationship. c.) only a many to many relationship.
An instructor has several phone numbers. When reducing the ER diagram down to a schema this must be addressed. Which of the following statements are true? a. an instructors phone is what is known as a multi-valued attribute b. a multi-valued attribute of an entity is expressed as a separate schema with attributes including the primary key of the original entity and the multi-valued attribute c. the instructor should have a column for each type of phone number d. multi-valued attributes must be flatted out to a separate attribute for each component
In an entity-relationship model, which of the following is a kind of attribute that should have some value, thus cannot be left empty? Choose an answer A Multivalued attribute B Required attribute C Simple attribute D Optional attribute
Given the following relation that stores details of employees and their projects: If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. 1.ProjectID ➡ EmployeeName 2.ProjectID ➡ EmployeeSalary 3.ProjectID , EmployeeName ➡ EmployeeSalary 4.EmployeeName ➡ EmployeeSalary 5.EmployeeSalary ➡ ProjectID 6.EmployeeSalary ➡ EmployeeName , ProjectID
An entity that depends on an other entity to exist is called ________ entity. Derived Dependent Weak Fake
What is the attribute that could be obtained using other attributes in the Entity-Relationship Diagram? Select one: a.Multi-Valued Attribute b.Derived / Calculates Attribute c.Single-Valued Attribute d.Composite Attribute
Unified Modelling Language (UML) is often used as a notation when drawing Entity-RelationshipDiagrams (ERDs) since it is a notation that software developers are already familiar with. What is the difference between a binary relationship and a unary relationship?Provide an example of each as part of your answer. Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language(UML) notation according to the below business rules. Your design should be atthe logical level – include primary and foreign key fields and remember toremove any many-to-many relationships.Legal system – business rules:• In the legal system, a judge hears many cases throughout their career.• Each case can be heard by multiple judges in some circumstances.• A case has a date and title that needs to be recorded in the database.• The name and surname of each judge needs to be stored.• A judge can have multiple qualifications (with minimum of one), and eachqualification is related to only one specific judge.•…