INFO 1620: Assignment 1

Introduction to Database Design

This assignment will address the following course objectives:

1. Distinguish between data and information.
2. Define the terms 'database', 'database management system' and distinguish between such systems and their predecessors.
3. Define the characteristics and benefits of the relational database model.
4. Describe the database development process, and explain how it fits into the broader context of systems analysis, design, and implementation.

Grading:

The assignment is worth 20 points which breakdown as follows:

Task 1: 9 points

Task 2: 5 points

Task 3: 6 points

Task 1

(objectives 1 & 2)

Match the letter of the term in the list below, to the appropriate term definition of associated phrase. If a definition or phrase does not match a term on the list, enter J to indicate you found no match. Your answers will appear in red, which is to help your instructor when grading.

NOTE: Definitions may not be word-for-word from your textbook or from other course materials. Read the definition carefully and determine the best term match for the definition based on all sources available to you.

1. Entity-
2. Attribute
3. Relationship-
4. Spreadsheet -
5. Relational Database-
6. Database Management System (DBMS)
7. Software stack-
8. Data-
9. Information-
10. No Match

Letter	Definition or Phrase
	Meaningfully processed facts
	A person, place, event, item, or other transaction for which you want to store and process data
	Typically stores data as one large table; a flat file
	A characteristic or property of an entity, and is also called a field or column in many databases
	program through which users interact with the data stored in a database
	An association between entities, for example a one-to-many relationship
	Raw, unorganized facts
	Stores information about multiple entities in multiple tables and identifies the relationships
	Groups several software components including programming language(s), framework(s) and DBMS

Task 2

(objective 3)

List 5 advantages of a well-designed relational database.

1.Improved Data sharing

2.Improved data consistency

3.Improved data quality

4.Reduced Program maintenance

5.Improved decision support

Task 3

(objective 4)

List the number(s) of the systems development lifecycle phase from the diagram with the database development process that would be worked on during that phase. Some processes may match multiple phases and some phases may match multiple processes. Your answers will appear in red, which is to help your instructor when grading.

	Enterprise Modeling
	Conceptual Data Modeling
	Logical Database Design
	Physical Database Design
	Database Implementation
	Database Maintenance

Phases: Planning, Analysis, Design, Implementation, Maintenance