Database 1

In: Computers and Technology

Submitted By psp1010
Words 406
Pages 2
Dylan Gehman
Chapter 1 review 1-13

1. System analysis and design techniques provide the analyst with a systematic procedure for analyzing data input, data flow, and information output; furthermore, the techniques can improve the functioning of business.

2. The three roles of a system analyst are:
A. Consultant--hired from outside an organization to address information systems issues within that organization.
B. Supporting Expert--serves as a resource for those who are managing a systems project.
C. Change Agent--an analyst who serves as a catalyst for change, develops a plan for change, and works with others in facilitating that change.

3. Personal qualities helpful to systems analysts include:
A. Problem-solving abilities
B. Communication skills
C. Computer experience
D. Self-discipline and self-motivation
E. Project management capabilities

I4. The seven phases of the SDLC are:
1. Identifying problems, opportunities, and objectives--recognizing problems and opportunities confronting the business and determining business objectives.
2. Determining information requirements--understanding what information users need to perform their jobs.
3. Analyzing system needs--structured analysis of information needs and decision making.
4. Designing the recommended system--logical design of the information system.
5. Developing and documenting software--structured development of software and documentation.
6. Testing and maintaining the system--testing and revising the system.
7. Implementing and evaluating the system--training users and reviewing system

5. CASE tools are the tools used while developing a software project.

6. The agile approach is based on values, principles and core practices, It values communication, simplicity, feedback and courage.

7. The planning game spells out rules that help formulate the agile development team…...

Similar Documents

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

T/F for Database Chapter 1

...9/21/2013 Database Unit 1 True/False Questions Indicate whether the following statements are true or false on the student answer sheet. 1 At its simplest, a database can be seen as a collection of related data. True 2 A delimited file is a file where the length of the file is limited. False 3 A delimited file is one in which the data is separated by a character such as a comma. True 4 All fixed length files are of the same length. False 5 In relational databases, logical design is kept separate from physical design. True 6 A hierarchical database is designed with a tree-like structure that resembles a file system. True 7 Codd defined the core principles of a relational database in 1970. True 8 Data redundancy improves the integrity of a database. True 9 In a diagram, crows feet notation conveys more information about the relationships. True 10 A primary key uniquely identifies each row in a database table. True 11 In a relational database, all data is kept in tables, even the information about the tables. True 12 SQL is the language used by relational databases to create objects and to manipulate and retrieve data. James Little 9/21/2013 Database False 13 An entity is someone who is interested in the database. True 14 In a statement of scope, a constraint is a limit on what the database will do. True 15 Oracle is a popular relational database management system. True 16 A relational database management......

Words: 336 - Pages: 2

Database Unit 1 Lab 1

...Lab 1 1. A collection of information accessible from a computer or server 2. DBMS is a Database Management System that organizes information internally. 3. Dbms stores information, spreadsheet runs formulas 4. Product | Use | Where it was used | Cost | DB2 | Open database environment | A small single-user application to a large multi-user system. | $598 + $99 additional user | Microsoft Access | Relational databases that have tables of data. | Software developers and data architects | $199 (Amazon) | Microsoft SQL Server | primary function is to store and retrieve data as requested by other software applications | workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users | Vary (Different Prices for different purposes) | Filemaker Pro | database engine with a GUI-based interface | ??? | $329.00 | Oracle | transfer any customer info from one location to any other in the world | larger organizations and small chain stores | ??? (Couldn’t find anything) | Mysql | database for use in web applications | Personal and commercial use | $2k-$10k/year | 5. “DBMS stands for database management system whereas RDBMS stands for relational database management system; these softwares are created to maintain and utilize large scale collection of data in an efficient manner.” http://www.differencebetween.info/difference-between-dbms-and-rdbms 6. 290 7. Peng J Wu 8. Footlocker:......

Words: 447 - Pages: 2

Database Theory Assignment 1

...1) How many records does the file contain? How many fields are there per record? There are 7 records (21-5Z through 31-7P) and each record contains 5 fields (PROJECT_CODE through PROJECT_BID_PRICE). 2) What problem would you encounter if you wanted to produce a listing by city? How could you solve this problem by altering the file structure? There is not a field for city, only manager’s address. In order to get a listing by city, you would have to break up the address into address, city, state, zip, file format. You can do an internal string search, but it is difficult to write and takes longer to execute. 3) If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure? I would have the fields set up as first name (MGR¬_FIRST), middle initital (MGR_INITIAL), last name (MGR_LAST), area code (MGR_AREACODE), phone (MGR_PHONE), street (MGR_STREET), city (MGR_CITY), state (MGR_STATE), and zip code(MGR_ZIP). 4) What data redundancies do you detect? How could those redundancies lead to anomalies? Holly B Parker appears 3 times and George F Dorts appears twice. If either move and/or change their phone number, these changes must be made more than once and they must be done correctly. If any occurrence is missed or there is a mistake when entering in the information on one, the data are different for the same person creating anomalies. 5) Identify and discuss the serious data......

Words: 703 - Pages: 3

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

Database Theory Exam 1

...CHAPTER 1 1 The word ________ indicates that the facts have not yet been processed to reveal their meaning. a. data b. dictionary c. raw d. information correct: c 2 Processed data, or ________, can be used as the foundation for decision making. a. information b. DP c. raw data d. queries correct: a 3 Raw data must be properly ________ for storage, processing, and presentation. a. sorted b. grouped c. formatted d. arranged correct: c 4 What is a key characteristic of knowledge? a. "new" Knowledge can be derived from "old" knowledge. b. It is assembled from raw data. c. It cannot be duplicated. d. It exists in a vacuum. correct: a 5 Accurate, relevant, and timely ________ is the key to good decision making. a. relationships b. data c. processing d. information correct: d 6 What is the name for data about data? a. unique data b. superdata c. metadata d. raw data correct: c 7 Data management is a discipline that focuses on ________. a. the proper generation, storage, and retrieval of data b. the help items to be used by end users c. the management of end users d. the proper generation, storage, and retrieval of information correct: a 8 What is a benefit of using a DBMS? a. It provides seamless Internet access to database data. b. It creates automatic backups. c. It helps create an environment for end users to have access to more data. d. It provides full security to data using private/public key encryption. correct: c 9 The ________ manages interaction between the end...

Words: 8796 - Pages: 36

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

Database Itt Tech Unit 1 True or False

...Nick Eubanks Unit 1 True/False Questions Indicate whether the following statements are true or false on the student answer sheet. 1) At its simplest, a database can be seen as a collection of related data. TRUE 2) A delimited file is a file where the length of the file is limited. FALSE 3) A delimited file is one in which the data is separated by a character such as a comma. TRUE 4) All fixed length files are of the same length. TRUE 5) In relational databases, logical design is kept separate from physical design. FALSE 6) A hierarchical database is designed with a tree-like structure that resembles a file system. TRUE 7) Codd defined the core principles of a relational database in 1970. TRUE 8) Data redundancy improves the integrity of a database. FALSE 9) In a diagram, crows feet notation conveys more information about the relationships. TRUE 10) A primary key uniquely identifies each row in a database table. TRUE 11) In a relational database, all data is kept in tables, even the information about the tables. TRUE 12) SQL is the language used by relational databases to create objects and to manipulate and retrieve data. TRUE 13) An entity is someone who is interested in the database. TRUE 14) In a statement of scope, a constraint is a limit on what the database will do. TRUE 15) Oracle...

Words: 326 - Pages: 2

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

Chapter 1 Test Database Concepts

...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......

Words: 666 - Pages: 3

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

Database 1

...1. What are the main differences between a file-processing system and a database management system? Ans: A database management system coordinates both the physical and the logical access to the data, whereas a file-processing system coordinates only the physical access. 2. What are the major advantages of a database system? What are the major Disadvantages of a database system? Ans:- Advantages a) Controlling Data redundancy b) Data Consistency c) Data Sharing d)Data security Disadvantages:- a) Cost of hardware and software b) Cost of data sharing c) Database Failures d) Complexity 3. Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2.? Ans: The database has shown the student information for smith and brown. It also represents the course details. Then it shows the intake of the subject and instructor. In grade report section its display the grade result of smith and brown. Also it illustrates the prerequisite for the major subject. From this Database we can get the information of student, course details, course instructor, prerequisite for the major subject and grade report of the student. 4. Discuss the capabilities that should be provided by a DBMS? Ans:- i) Restricting Unauthorised access ii) Providing multiple user interface iii) Controlling redundancy iv) Providing backup and recovery v) Providing persistence storage for programs object......

Words: 521 - Pages: 3

Database Unit 1 Homework

...1. List the components included in a Relational Database Management System (RDBMS) in general. Client and server, tools for backup and restore, tools for creation and maintenance of the DB, tools for securing access, administrative and reporting tools and often tools for data analysis. 2. What is the language used to interact with most modern relational database? SQL 3. List the three (3) properties of a primary key. Unique Not Null Can not be changed 4. Why is it required that every table in a modern relational database has a primary key defined? The primary key in a given table is the only unique identifier for a row or record 5. Explain what “data integrity” means in the context of a modern relational database. Data integrity means the data is consistent and factual, the data can be “trusted” 6. Explain why data redundancy is generally a “bad” thing in a modern relational database. Storing the same exact information in multiple places leads to problems on update and delete and drastically increases the chance of data becoming inconsistent. 7. What is a “foreign key” in the context of a modern relational database. What is the role of a foreign key? A foreign key is a primary key that has been imported from another table. The foreign key reinforces the “relationship” between two tables. 8. What is the relationship between a foreign key and a primary key? A foreign key is a primary key that has been imported from another table. 9. What is......

Words: 286 - Pages: 2

Database Theory Tutorial 1

...DCS5078 DATABASE SYSTEMS TUTORIAL 1 CHAPTER 1 1. Discuss each of the following terms: a. Data b. Field c. Record d. File 2. What is data redundancy, and which characteristics of the file system can lead to it? 3. What is a DBMS, and what are its functions? 4. What is a business rule, and what is its purpose in data modeling? Given the file structure shown in Figure T1.1, answer Problems 5 - 8. FIGURE T1.1 The File Structure for Problems 5-8 5. How many records does the file contain, and how many fields are there per record? 6. What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure? 7. If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure? 8. What data redundancies do you detect, and how could these redundancies lead to anomalies? FIGURE T1.5 The File Structure for Problems 9-11 9. Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure T1.5. CDP OCT 2014/2015 1 DCS5078 DATABASE SYSTEMS TUTORIAL 1 10. Identify the different data sources in the file you examined in Problem 9. 11. Given your answer to Problem 10, what new files should you create to help eliminate the data redundancies found in the file shown in Figure T1.5? Use the contents of Figure T1.11 to work problems 12. FIGURE T1.11 Linking......

Words: 355 - Pages: 2

Week 3 Determining Databases Scenario 1 and 2

...Determining Databases and Data Communications Tasha Carson BIS/320 3/14/2016 Professor Rita Solomon-Moore Determining Databases and Data Communications Scenario 1: The methodology of managing a trade show booth is to keep certain things in mind about the components, equipment and each and every item that is to be transported back to the head office, when you are closing the booth. We are in charge of setting up a consumer electronics trade shown which mainly consists of products like dry batteries, cell phones, laptops, computer accessories, phone accessories and monitor LCDs. We need to make sure that these products are safely returned when the trade show is over. There can be a number of ways in which we to categorize these products into their respective fields so we can keep track of them when shipping them to the main office, because we are liable to the security of these materials. By classifying smaller goods, like dry batteries, we can categorize them into one shipment package that can be transported safely back. Other products like cell phones and their accessories, we can pack them together so we have a safety for the products to remain in one carton. Likewise, keeping computer accessories with laptops and keeping LCDs separate, we can ensure that the products do not get damaged during transportation. Data base system is not that compulsory for managing this equipment, although it is a good thing to have it but it gets costly, when we can easily......

Words: 1125 - Pages: 5