Information Systems homework help

Information Systems homework help. Midterm Exam IT 507
 
Please Note: Please DO NOT RETURN the entire exam. Only Submit a word document of your answers only. DO not repeat the questions please.
 
 For T/F please do not repeat the questions. Only write the question number and the correct answer for example:  1) T,  2) F…..
 
For Multiple choices only write the question number and the answer for example:    1) A    2) B   
 
Total Points for this exam is: 100 points.
T/F  (15 questions, 2 points each, total points 30)
 

  1. Redundancy wastes space because you are storing different types of data in the same place.

 

  1. A database will not only hold information about multiple types of entities, but also information about

the relationships among these multiple entities.
 

  1. A relational database handles entities, attributes, and relationships by storing each entity in its own

table.
 

  1. A query is a question represented in a way that the DBMS can recognize and process.

 

  1. In an AND criterion, the overall criterion is true if either of the individual criteria is true.

 

  1. The concept of grouping means that statistics will be calculated for individual records.

 

  1. In many cases, you will need to create queries to select data from more than one table. To do so, it is

necessary to join the tables based on matching fields in corresponding columns.
 

  1. Matrix algebra is a theoretical way of manipulating a database.

 

  1. The union of tables A and B is a table containing all rows that are in either table A or table B or in

both table A and table B.
 

  1. The intersection of two tables A and B is the set of all rows that are in table A but that are not in table B.

 

  1. The product of two tables is the table created by combining every row in the first table with every row in the second table.

 

  1. The join operation is the core operation of relational algebra because it is the command that allows

you to extract data from more than one table.
 

  1. The SELECT command will allow you to write a query in SQL.

 

  1. Removal of repeating groups is the starting point in the quest to create tables that are as free of problems as possible.

 

  1. Relational Algebra is the foundation of relational Database.

 
 
Multiple Choice questions 
(20 questions, 3 points each, total points 60)
 

  1. is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.
    1. Data integrity Data anomaly
    2. Data ubiquity d. Data quality

 

  1. A desktop database is a
    1. single-user multiuser
    2. workgroup d. distributed

 

  1. Data warehouse contains historical data obtained from the .
    1. operational databases desktop database
    2. enterprise databases d. workgroup databases

 

  1. Data is said to be verifiable if:
    1. the data always yields consistent results. the data cannot be changed or manipulated.
    2. the data is obtained from trusted sources. d. the data is stored in different places within the database.

 

  1. provide a description of the data characteristics and the set of relationships that link the data found within the
    1. Queries End-user data
    2. Metadata d. Schemas

 
 

  1.          serve as the intermediary between the user and the database.
    1. DBMSs Metadata
    2. End-user data d. Programming languages

 

  1. From a database point of view, the collection of data becomes meaningful only when it reflects properly defined_____.
    1. business rules
    2. business norms
    3. business goals
    4. business plans

 

  1. is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.
    1. Data integrity Data anomaly
    2. Data ubiquity d. Data quality

 

  1. A desktop database is a
    1. single-user multiuser
    2. workgroup d. distributed

 

  1. Data warehouse contains historical data obtained from the .
    1. operational databases desktop database
    2. enterprise databases d. workgroup databases

 

  1. Data is said to be verifiable if:
    1. the data always yields consistent results. the data cannot be changed or manipulated.
    2. the data is obtained from trusted sources. d. the data is stored in different places within the database.

 

  1. data exist in the format in which they were collected.
    1. Structured Semistructured
    2. Unstructured d. Historical

 

  1. data exist in a format that does not lend itself to processing that yields information.
    1. Structured Semistructured
    2. Unstructured d. Historical

 

  1. Which of the following is true of business rules?
    1. They allow the designer to set company policies with regard to data.
    2. They allow the designer to develop business processes.
    3. They can serve as a communication tool between the users and designers.
    4. They provide a framework for the company’s self-actualization.

 

  1. A noun in a business rule translates to a(n) in the data model.
    1. entity attribute
    2. relationship d. constraint

 
 

  1. A verb associating two nouns in a business rule translates to a(n) in the data model.
    1. entity attribute
    2. relationship d. constraint

 

  1. Oracle 11g is an example of the .
    1. hierarchical model file system data model
    2. relational data model d. XML/Hybrid data model

 

  1. MySQL is an example of the .
    1. hierarchical model file system data model
    2. relational data model d. XML data model

 

  1. A(n) is anything about which data are to be collected and stored.
    1. attribute entity
    2. relationship d. constraint

 

  1. logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false.
    1. Predicate Database
    2. Relational d. Index

 
Short Essay (10 points)
 

  • Explain multivalued attributes with the help of examples.

 
 
Good Luck
 
 
 
 
ANSWER:  Multivalued attributes are attributes that can have many values. For instance, a person may have several college degrees, and a household may have several different phones, each with its own number.
Similarly, a car’s color may be subdivided into many colors for the roof, body, and trim. In the Chen Entity Relationship model, multivalued attributes are shown by a double line connecting the attribute to the entity.
 
are the result of formatting disorganized

Information Systems homework help

Solution:

15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.