Premium Essay

Chapter 1 Test Database Concepts

In: Computers and Technology

Submitted By bakdus94
Words 666
Pages 3
Exam
Name___________________________________

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.

1)

A good definition for a database is:

1)

_______

A)

A text file with values delimited by commas

B)

A collection of related data

C)

A card catalogue

D)

A piece of software for managing databases

2)

Redundancy refers to what database condition?

2)

_______

A)

All data is stored in tables

B)

You have more than one database devoted to the same thing

C)

The same data is recorded in more than one place in the same database

D)

A primary key is repeated in another table as a foreign key

3)

Which best defines the function of a primary key?

3)

_______

A)

It uniquely identifies each record

B)

It is always a number

C)

It unlocks the data in a table

D)

It is the first field in a table

4)

What best describes the function of a foreign key?

4)

_______

A)

A foreign key is at the primary key of one table repeated in another table in order to create a relationship between the tables

B)

A foreign key is a field telling what language the data is in

C)

A foreign key is a key that doesn't belong in the table

D)

A foreign key is redundant data

5)

A database entity can best be described as:

5)

_______

A)

The person responsible for the database

B)

Something that describes a person or process

C)

Something the database is concerned with, for which data can be stored

D)

The database itself

6)

Which of the following is the best definition for a database attribute?

6)

_______

A)

A principle the database must follow

B)

Something that describes some part…...

Similar Documents

Free Essay

Pt250 Database Concepts Unit 1 Research Assignment

...Unit 1 Research Assignment The History Of SQL SQL was created in 1970 by Dr. E. F. Codd. There have been three revisions of the standard and they are SQL99, SQL2003 and SQL2008. The Query was the most recent edition of SQL. Microsoft SQL 2010 Express Features 1. Simplify Development Efforts Leverage Existing Skills Get started today developing on SQL Server with SQL Server Data Tools. Take advantage of existing Transact-SQL skills, and incorporate technologies, including the Microsoft ADO.NET Entity Framework and LINQ. Develop applications faster through deep integration with Visual Studio, Visual Web Developer, and SQL Server Management Studio. Improve Developer Productivity Increase developer productivity and simplify deployment through integration with Visual Studio and Visual Web Developer. Take advantage of advanced capabilities, including rich table and query designers, full integration with Server Explorer, and drag-and-drop IDE support for rapidly building data-bound applications. Tune the Design Process Manage SQL Server 2012 Express databases with SQL Server Management Studio Express. Connect to local SQL Server 2012 Express databases and manage objects with full Object Explorer integration. Write, execute, and test queries by using visual query plans that provide hints to tune queries and access management and maintenance options. 2. Develop Sophisticated Applications Rapid data exploration & visualization Discover...

Words: 751 - Pages: 4

Premium Essay

It250 Chapter 1 - Intro to Databases

...Databases Chapter 1 – Intro Lab 1.2 1. Nouns: doctors, patients, drugs, side effects. 2. Major Topics: doctor Records, patient medical records, side effects / symptoms, and screening records. Lab 1.3 1. Major Topics: faculty, software, and computers. 2. Draft statement of work that includes scope, objectives, and preliminary timeline: a. Scope – A database with the ability to track faculty and staff computers and software. b. Objectives – Faculty software, version, license agreement, record of computers with software, location of computer, user access to computer, software install / uninstall timestamps, status of the computer. i. Additional: ability to track software requests and software availability. c. Timeline ii. Gathering data – gather records of the school computers and its staff, a list of software purchased and in use, interview and questionnaire information understand the faculty needs. Time: 1.5 weeks. iii. Analyzing data – Understanding the data to create data model. Know the needs of the faculty members and type of software / computers in use to determine business rules. Time: 2 weeks. iv. Normalization – Data modeling; entities and relationships normalized. Time: 2 weeks. v. Building the physical database – Create RDBMS database. Time: 4 days. vi. Testing and security – Testing using sample data. Create user permission for different levels of faculty, block out...

Words: 369 - Pages: 2

Free Essay

Database Concepts

...Mary Easterling Database Concepts Paper (Ch. 30 Web Technologies and DBMS) The internet or web was created in 1989, the internet grew into the powerful information exchange service that it is today. It has expanded the world at a pace that has astounded many experts in this new field. This new technology brought forth many new ideas for better, faster, easier ways to communication between the different computer formats, so the experts had get together and create a universal language that would be accepted with all computer hardware systems. Most web pages today are written in HTML, XML, JAVA, JavaScript are just a few examples. Websites now and in the past use the uniform resource locations (URL’s) to communicate inside the different browsers with the information or resources on a specific server. Without these locations, the information cannot be found or accessed, for example, to access Google.com, the browser needs to break down the information into an address to continue, and if the address is incorrect or cannot be located it will return a page not found error. Hypertext markup language (HTML) is the most common language that spans across the different platforms. This language is pretty easy to learn using the free basic instructions available on the internet, and now most high schools teach HTML to their students so they can create their own webpage. Most personal webpages today are a great example of what is called a static web page. “An HTML document that......

Words: 517 - Pages: 3

Premium Essay

Database Concept

...CASE STUDY: VIGNETTE REVISITED Q1: Develop the first few steps of the project plan. Step 1: Project Goals The project is considered successful when the needs of the stakeholders have been fulfilled. Stakeholders are individuals who directly or indirectly be involved or affected by the project. Step 2: Project Planning Using information obtained from the first step, list the things that need to be done to ensure the project goals. Step 3: Project Schedule Task list should be made to ensure that the planning of this project can be made as planned. of which is the timeliness or schedule plan. Step 4: Supporting Plans The final steps to consider are a plan that has been made in the planning process. Related matters are human resource planning, communications planning and risk management. Q2: Discuss the potential political necessities outlined in this section as they related to this type of implementation. Q3: Think about and create a list of step that make sense for your organization. List step that should be taken when we want to plan for organization are:- 1. Review and revise project objectives by examining reports and project documents. At the start of any project, there will be a variety of ideas and opinions about the purpose and scope of the project, what the final product of the project will be, and how the project will be carried out. The Project Initiation Stage is concerned with taking these ideas and intentions and developing them into a formal...

Words: 809 - Pages: 4

Premium Essay

Database Concepts Unit 1

...1. A recent trend for major commercial database developers is to offer free “Express” versions of their databases. Microsoft has SQL Express, Oracle has Oracle Express, and DB2 has DB2 Express. Go to the company websites, and look up these Express editions. What features does each one have? What limits do they have? How do they compare to each other? The features are: SQL Server Express supports most of the features and functionality of SQL Server. The following table lists some of the major features and components that are supported. Stored Procedures SQL Server Configuration Manager Views Replication (as a subscriber only) Triggers Advanced Query Optimizer Cursors SMO/RMO sqlcmd and osql utilities Integration with Visual Studio 2005 Snapshot Isolation Levels Service Broker (as a client only)¹ Native XML support, including XQuery and XML Schemas SQL CLR Transact-SQL language support Multiple Active Result Sets (MARS) Dedicated Administrator Connection² Import/Export Wizard The limits are: The following table lists the additional SQL Server database features that are not supported in this version of SQL Server Express. It also lists database features from previous versions of SQL Server that are not supported. SQL Server features not supported in SQL Server Express SQL Server features from previous versions not supported in SQL Server Express Database mirroring SQL Mail Online restore Fail-over clustering Database snapshot Distributed partitioned......

Words: 376 - Pages: 2

Free Essay

Database Management Chapter 1

...Principles of Database Management Systems Homework 1 Ying Li 4861521 Homework 1 Exercise 1.4 Explain the difference between external, internal, and conceptual schemas. How are these different schema layers related to the concepts of logical and physical data independence? Answer: External schemas, which usually are also in terms of the data model of the DBMS, allow data access to be customized (and authorized) at the level of individual users or groups of users. Internal (physical) schemas summarize how the relations described in the conceptual schema are actually stored on secondary storage devices such as disks and tapes. Conceptual (logical) schema describes the stored data in terms of the data model of the DBMS. In a relational DBMS, the conceptual schema describes all relations that are stored in the database. Any given database has exactly one conceptual schema and one internal schema because it has just one set of stored relations, but it may have several external schemas, each tailored to a particular group of users. External schemas provide logical data independence, while conceptual schemas offer physical data independence. Exercise 1.6 Scrooge McNugget wants to store information (names, addresses, descriptions of embarrassing moments, etc.) about the many ducks on his payroll. Not surprisingly, the volume of data compels him to buy a database system. To save money, he wants to buy one with the fewest possible features, and he......

Words: 859 - Pages: 4

Premium Essay

Database Systems Cornel/Morris Chapter 1 Summary

...Chapter 1 Database Systems Why Databases? * At the heart of all of these systems are the collection, storage, aggregation, manipulation, dissemination, and management of data * Databases are specialized structures that allow computer-based systems to store, manage, and to retrieve data very quickly Data vs. Information * Data – raw facts * Raw indicates that the facts have not yet been processed to reveal their meaning * You transform the raw data into a data summary * Information – the result of processing raw data to reveal its meaning * Data processing can be as simple as organizing data to reveal patters or as complex as making forecasts or drawing inferences using statistical modeling * To reveal meaning, information requires context * Raw data must be properly formatted for storage, processing, and processing * Ex: dates must be stored in Julian calendar formats and yes/no responses must be converted to Y/N or 0/1 * Data are the foundation of information which is bed rocked of knowledge * Knowledge – body of information and facts about a specific subject * Knowledge implies familiarity, awareness, and understanding of information as it applies to the environment * A key characteristic of knowledge is that “new: knowledge can be derived from “old” knowledge * Key Points: * Data constitute the building blocks of information * Information is produced by......

Words: 2824 - Pages: 12

Premium Essay

Database Management Chapter 1 & 2

...Chapter 1: (10 points each) 1. Give an example of two related tables other than one in the textbook. Use the STUDENT and GRADE tables in Figure 1-1 of the textbook as an example pattern for your tables. Name the tables and columns using the conventions in the textbook. * I used MysqL workbench to create 2 tables 1- Customers that has customers with some of their information(primary key is “Customer ID”) * CREATE TABLE IF NOT EXISTS `mydb`.`Customer` ( * `CustomerID` INT NOT NULL, * `Name` VARCHAR(45) NULL, * `Email` VARCHAR(45) NULL, * PRIMARY KEY (`CustomerID`), * UNIQUE INDEX `Email_UNIQUE` (`Email` ASC)) * ENGINE = InnoDB 2- Purchases that has number of purchases that has been done by the customers(Pkey is PurchaseID, and foreign key is “CustomerID” from Customer table. * CREATE TABLE IF NOT EXISTS `mydb`.`Purchases` ( * `PurchasesID` INT NOT NULL, * `productID` INT NULL, * `PricePaid` INT NULL, * PRIMARY KEY (`PurchasesID`)) * ENGINE = InnoDB * * *note I made the customerID as the foreign key and the relationship is (1 to many) * * * Figure1 the Customer and Purchases tables’ relationship. * 2. For the tables you created in Question 1, what are the primary keys of each table? Do you think that any of these primary keys could be surrogate keys? * In Customer table the Primary key is CustomerID * In the Purchases table the primary key is......

Words: 1949 - Pages: 8

Premium Essay

Database Design Chapter 1 Review Questions

...1. a. Data – Raw facts b. Field – An alphabetic or numeric character or group of characters that defines a characteristic of a person, place, or thing. c. Record – A collection of related fields. d. File – A named collection of related records 2. Data redundancy occurs when the same data are stored in multiple places unnecessarily. Have more than one incorrect copies of information can cause it. 3. Data independence exists when you can change the data storage characteristics without impeding the program's ability to access the data. It is lacking because of how it has to tell the computer what to do, and how to do it. Causing the program to have much more lines of code than should be needed. 4. It is a software tool that makes it possible to organize data in a database. Its functions are data dictionary management, data storage management, data transformation and presentation. 5. Structural independence exists when you can change the file structure without affecting the application's ability to access the data. If it did not exist, any change to a files structure would require several extra steps for every single record in the file. 6. Data is raw facts that have not been processed. Information is data that has been processed and given context. Databases help to organize the manipulation of data to create information by providing an organizational structure that makes relationships and connections between data explicit. 7. The DBMS serves as the......

Words: 480 - Pages: 2

Premium Essay

Fins1613 Chapter 1 Test Bank

...Test Bank True/false questions Multiple choice questions Problems to accompany Multinational Finance by Kirt C. Butler Third Edition PART I Overview and Background Chapter 1 An Introduction to Multinational Finance True/False 1. MNCs have investment or financial operations in more than one country. ANS: True. 2. Because of globalization in the world’s markets, a multinational financial manager is more likely than a domestic financial manager to specialize in finance to the exclusion of other fields of business. ANS: False. The multinational financial manager must be well versed in each of the business disciplines in which the MNC is involved. 3. The domestic financial manager must be knowledgeable in several areas within finance, whereas the multinational financial manager usually specializes in a single area, such as corporate finance, investments, or financial markets. ANS: False. The multinational financial manager is likely to require knowledge of several fields within finance. 4. The investment opportunity set is the set of investments available to the corporation; that is, the set from which the company must select. ANS: True. 5. Types of market efficiency used to describe the performance of financial markets are allocational, operational, and transactional efficiency. ANS: False. Three types of market efficiency are allocational, operational, and informational. 6. An informationally efficient......

Words: 1437 - Pages: 6

Premium Essay

Acc561 Chapter 1 Self Test

...CHAPTER 1 SELF TEST 1.   | (SO 1)Which is not one of the three forms of business organization? a. Sole proprietorship. b. Creditorship. c. Partnership. d. Corporation. |   | | 2.   | (SO 1)Which is an advantage of corporations relative to partnerships and sole proprietorships? a. Lower taxes. b. Harder to transfer ownership. c. Reduced legal liability for investors. d. Most common form of organization. |   | | 3.   | (SO 2)Which statement about users of accounting information is incorrect? a. Management is considered an internal user. b. Taxing authorities are considered external users. c. Present creditors are considered external users. d. Regulatory authorities are considered internal users. |   | | 4.   | (SO 2)Which of the following did not result from the Sarbanes-Oxley Act? a. Top management must now certify the accuracy of financial information. b. Penalties for fraudulent activity increased. c. Independence of auditors increased. d. Tax rates on corporations increased. |   | | 5.   | (SO 3)Which is not one of the three primary business activities? a. Financing. b. Operating. c. Advertising. d. Investing. |   | | 6.   | (SO 3)Which of the following is an example of a financing activity? a. Issuing shares of common stock. b. Selling goods on account. c. Buying delivery equipment. d. Buying inventory. |   | | 7.   | (SO 4)Net income will result during a time period when: a.......

Words: 529 - Pages: 3

Premium Essay

Database Concepts

...Database Concepts David Emersion DBM380 6/29/2015 Wade Fergus Database Concepts In an age when information is power, each business in the market place must make use of every tool at its disposal. Efficiency is the hallmark of any successful business. For a business to be efficient it must be the master of managing its own information. Time is money, and using an ineffective information management system is simply money down the drain. Quick access to accurate information is crucial to an organization’s success. Fortunately, businesses have a powerful weapon at their disposal – databases. Database Systems Every organization from small non-profit teams up to huge corporations supporting millions of customers must keep records of different types of data. These data can vary from inventory prices, to payroll, to medical records, and everything in between. The common challenges that these organizations face is keeping the data accurate, relatively easy to use, and secure. The solution to this problem is to use a database that fits the needs of the organization. A database is a system that houses data and metadata. Metadata is the information about the data and includes “information such as the name of each data element, the type of values (numeric, dates, or text) stored on each data element, and whether the data element can be left empty” (Coronel, Morris, & Rob, 2013, p. 7). A database system......

Words: 578 - Pages: 3

Premium Essay

Database Concepts

...Database Systems DBM/380 July 13, 2015 James Cervi Database Systems When it is necessary to store and manage data, a database is used. A database is a collection of data organized in such a way that it can be easily stored, managed, and manipulated. “You can think of a database as an electronic filing system” (QuinStreet Inc, 2015). It is safe to assume that a large percentage of organizations use databases for managing the wide array of data within their company. Databases can keep track of data such as: employee records, consumer demographic and contact information, and company files. A database management system (DBMS) is the software that controls the movement of data in and out of the database, as well as within the database. While a database management system refers to the software used to control the data, the database refers to the body of data being stored. Types of databases can be classified in numerous ways. They can be classified by the user, such as: desktop database meant for a single user, or a work-group database meant for multi-users. There is also an enterprise database which is used by an entire organization. Databases can be categorized by location. A centralized database manages data at a single site, whereas a distributed database manages data in multiple locations. Another way of categorizing databases is by the type of data that is being stored. “General-purpose databases contain a wide variety of data used in multiple disciplines” (Coronel,...

Words: 913 - Pages: 4

Premium Essay

Database Managment - Chapter 1 Assigment

...CHAPTER 1 ASSIGNMENT 1. Part A a. Automatic information processing was introduced by James Power whose company later became known as IBM b. The emergence of reusable data opened up the horizons for database management systems. c. Data provides a competitive advantage for businesses of all shapes and sizes. Part B a. Backup and recovery technology allows database managers to sleep in peace knowing their data is safe. b. Data Security protects consumers from data theft. c. Data privacy is very important. Hospital employees, for example, are only allowed access to certain parts of the EMR system which holds patient data. 2. 1986 – When my world began… IBM becomes the first company to use a one megabit chip in the IBM 3090 1991 – The first web site was built at CERN labs and put online August 6th 1992 – Microsoft Access was released 1995 – MySQL’s initial release 1998 – Google began 2004 – Emergence of Web 2.0 2007 – Amazon releases the Kindle fostering a huge database of electronic books 2013 – MySQL is the second most widely used database management system 2015 – I take Database Management class with Mr. Ted Lee! 3. Here at the Show Me The Money Bank of Tennessee, our database systems allows us to send birthday greetings, send Congratulations to new graduates and newlyweds, reward long time clients, and off the most competitive interest rates on cars, houses, boats, etc. 4. Early data management was very time consuming. The examples of the seven years it took...

Words: 341 - Pages: 2

Free Essay

Database Concepts

...Huffman Trucking needs a better way to track the maintenance on their fleet of tractors, trailer and the roll-on/roll-offs. The fleet has to undergo periodic maintenance. Plan Putting the equipment's maintenance history, the parts used and vendor information into one database will save Huffman Trucking time and money. The database can include parts inventory information, parts catalogue information, the vendors used and their associated information, and parts purchasing history. The database will include all the maintenance history on each piece of equipment, such as the maintenance of the equipment itself, tire maintenance, the type of maintenance and the maintenance work orders. Conclusion Building a database saves money on maintenance by reducing redundant information and improving record keeping. Both the service and accounting departments will be able to utilize this database to keep track of parts purchases and costs. Having all the information in one central database would allow the diverse facilities to use the database. This type of centralization would bring more accuracy in Huffman Trucking's record keeping and would save money, time and manpower. Huffman Trucking Fleet Maintenance Database Solution Introduction Huffman Trucking is a privately held national transportation company with just under 1,400 employees and facilities across the United States. Huffman Trucking has benefited from a relationship with US Government that started in the late......

Words: 1795 - Pages: 8