business information systems?

Question

multiple choice questions

10. It is important to be able to uniquely identify entities in the ____ of the entity type .
a. objects c. entity set
b. classes d. attributes


11. _________ database model contains: entity, attribute, unique identifier, and relationship type.
a. Hierarchical model c. relational ER model
b. Network model d. Object-oriented model


12. The concept of a(n) ____ is the most fundamental concept of the ER modeling.
a. type c. domain
b. class d. entity


13. An entity is created then identified with some ____(s) .
a. Domain c. object type
b. data set d. attributes


14. A relationship between the two entity types, SALESPERSON and VEHICLE, may possess a(n) ____ cardinality constraint, meaning that (a) each salesperson entity can be related to many vehicle entities (up to n), and (b) each vehicle entity is related to at most one salesperson entity.
a. 0:0 c. 1:*
b. 1:1 d. *:*



15. A weak entity type can have its parent entity ____ as part of its primary key
a. All attributes c. Non primary
b. Any Attribute d. Primary Key



16. A(n) ____ is shown by the name written without an underline.
a. A constraint c. Primary key
b. A relationship d. An attribute


17. In an analysis approach, the modeler first assembles a list of ____.
a. entities c. relationships
b. attributes d. data types




18. From the following excerpt, what is the entity?
The name of an employee ... consists of the first name, middle initial, last name, and a nametag. While the address, gender, ... and date hired ... must be recorded, salary information is optional....
a. gender c. employee
b. name d. salary


19. If data requirements explicitly specify that “Some plants do not undertake any projects at all,” one can infer that a plant may or may not undertake/control a project, therefore a ___ marker would be placed in the diagram by the “project” entity side.
a. bar c. circle
b. asterisk d. nothing


20. A business rules states: “Since a dependent cannot exist independently of an employee, the dependent name and relationship to the employee, in conjunction with either the employee name or the employee number, is used to identify the dependents of an employee.”
Accordingly, a dependent should be modeled as a ____.
a. weak entity c. relationship type
b. total entity d. weak relationship


21. A business rule states “...an unique identifier of an employee of Bearcat Incorporated consists of the location name, department name, cubicle name and a number tag.” This identifier could be modeled as a _______.
a. Composite primary c. Only number tag is the key
b. Only location is the key d. Nothing can be the key


22. A primary key is ____ in the ER diagram.
a. italicized c. underlined with a dotted line
b. underlined with a solid line d. bolded


23. In the context of every relationship type in an ER model, the deletion of an entity from the parent entity type requires deletion action from the child entity set in order to maintain ____ of the relationships in the database.
a. Referential integrity c. Relational duplication
b. Referential redundancy d. Deletion completion


24. The business rule, “if a project is deleted, all assignments of employees to that project must be deleted” implies a ____ rule.
a. cascade c. set null
b. restrict d. set default


25. In a relational data model, a(n) ____ resembles a two-dimensional table of values presented as rows and columns.
a. object c. set
b. block d. relation


26. In a relational data model, a column is formally referred to as a(n) ____.
a. attribute c. schema
b. tuple d. heading


27. The ____ property means that two rows of a relation cannot have identical values for the primary key.
a. irreducibility c. equality
b. integrity d. uniqueness


28. A ____ serves the role of uniquely identifying rows of a relation.
a. non-key attribute c. foreign key
b. primary key d. schema key



29. A primary key is a candidate key with one additional property. This additional property is.
a. None uniqueness c. Maximum
b. Model convenience d. Minimum


30. A(n) ____ constraint stipulates that a row in child relation, that refers to parent relation with an existed row.
a. key c. referential integrity
b. entity integrity d. primary key



31. A(n) ____ establishes an explicit association between the two relations, and maintains the integrity of such an association.
a. primary key c. entity integrity
b. candidate key d. foreign key

Answer 1

well 10 / 10 for copying that lot into the question. Maybe your time would have been better spent researching the answer!

Answer 2

Dude.



I would love to hep you but this doesn't look like you have a problem solving this questions looks like you just paste your homework here and expected people to fill in for you.



Peace of advice, research the information you need and fill in as much as you can. then if you get stuck then you can come to yahoo answers and post the question that's troubling you.



Good Luck

Answer 3

ok, 2 kinds of tips equipment there. the 1st one is an tips equipment in the truest unique style, something designed to do a activity easier, alongside with sage for doing all your bills. The 2nd ourght truly to be referred to as a administration tips equipment as its no longer function specific yet helps the collation of all records mandatory to help managmeent attain judgements.

Answer 4

this looks somebody ICT homework, how are you going to learn if you dont do your own resarch/homework etc..