...Description • Databases are used to store, manipulate, and retrieve data in nearly every type of organization. • Database technology is routinely used by – individuals on personal computers – workgroups accessing databases on network servers – enterprise-wide distributed applications. Course Description • Introduces the basic and fundamental concepts on databases and the management of databases in terms of the different applications. • Exposes the use of DBMS to create and maintain applications. – – – – table construction Forms queries and report generations Course Objectives • Trace the growth and importance of database application; • Identify the advantages and disadvantages of database systems; • Apply appropriate techniques and methodologies in building and maintaining database systems; and • Create database application for business processes. Value Aims • Values – Teamwork – Self-Esteem – Accuracy – Confidence – Patience • Skills – Analytical and Logical 1 11/11/2014 Course Requirements • • • • • • Lecture sessions Hands-on Activities Quizzes Assignments Periodic Examinations Individual projects COURSE ADMINISTRATION Grading Scheme (Prelim, Midterm and Endterm) • CLASS STANDING 40% – Assignments – Quizzes – Lab Activities Grading Scheme Percentile Distribution • Prelim 30% • Midterm 30% • Finals 40% • EXAMINATIONS • PROJECT 40% 20% PRELIM LECTURE • Basic Concepts and Definitions • Traditional File Processing System vs Database System • Components of the Database Environment...
Words: 2854 - Pages: 12
...Chapter 1 Databases and Database Users Review Questions 1.1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. Answer: Data: Facts that can be recorded and that have implicit meaning Database: Collection of related data DBMS: Collection of programs that enables users to create and maintain a database (Software) Database system: database and DBMS software together Database catalog: structure of data files is stored Program-data independence: property that properties that DBMS access programs do not require such changes in most cases. The structure of data files is stored in the DBMS catalog separately from the access programs. User view: DBA: assisted by a staff that carries out these functions End user: the people whose jobs require access to the database for querying, updating, and generating reports; the database primarily exists for their use Canned transaction: that have been carefully programmed and tested Deductive database system: database systems provide capabilities for defining deduction rules for inferencing new information from the stored database facts Persistent object: Meta-data: The information stored in the catalog Transaction-processing application: 1.2. What four main types of actions involve databases? Briefly discuss each. Answer:...
Words: 1273 - Pages: 6
...Questions: Chapter 1 1.1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. • Data – known facts that can be recorded and that have implicit meaning. • Database – a collection of related data with an implicit meaning. • DBMS – a collection of programs that enables users to create and maintain a database • Database system – not only contains the database itself bit also a complete definition or description of the database structure and constrains. • Database catalog – the information about the database structure is stored in the Database Catalog which contains the structure of each file, the type and storage format of each data item, and various constrains of the data. • Program-Data Independence – DBMS access programs do not require changes in all programs due to the change in the structure of a file because the structure of data files is stored in the DBMS catalog separately from the access programs. • User View – a database typically has many users, and each of whom may require a different perspective or view of the database. A view may be a subset of the database or it may contain virtual data the is derived from the database files but is not explicitly stored. • DBA – a database administrator (short form DBA) is a person responsible for...
Words: 2493 - Pages: 10
...1/22/2015 Database Systems: Design, Implementationa and Management; 01 Flashcards create, study and share online flash cards MyFlashcards FlashcardDB About Help Donate TellFriends! Home >> Flashcards >> Computer Science >> Database Systems: Design, Implementationa and Management; 01 Shared Flashcard Set Details Title Click here to study/print these flashcards. Database Systems: Design, Implementationa and Management; 01 Ch1 19 Computer Science 02/08/2010 Create your own flash cards! Sign up here. Description Total Cards Subject Created Additional Computer Science Flashcards Related Study Documents from www.coursehero.com (What's Course Hero?) Course Hero is an online platform providing educational resources to help students learn more effectively. Subscription required. ch03 ch03 Course: Course: Cards Term Definition ch1, q1: Define each of the following terms: raw facts i.e., telephone number, a birth date, a customer name, and a yeartodate (YTD) sales value. Data have little meaning unless they have been organized in some logical manner data Term Definition ch1, q1: http://www.flashcardmachine.com/databasesystemsdesignimplementationaandmanagement01.html 1/6 1/22/2015 Database Systems: Design, Implementationa and Management; 01 Flashcards Define each of the following terms: a character or group of characters can be alphabetic or numeric that has a specific...
Words: 1375 - Pages: 6
...Chapter 1 – Review Questions 1.1 What is the purpose of a database? - The purpose of a database is to help people keep track of things. 1.2 What is the most commonly used type of database? - The relational database is the most commonly used type of database. 1.7 Define the terms data and information. Explain how the two terms differ. - Data are facts and figures. Information is defined as knowledge derived from data, or as data presented in a meaningful context. Data is simply recorded in the database, but the data must be manipulated in some way to produce information. 1.12 What is the purpose of the largest databases used by e-commerce companies such as Amazon.com? - The largest databases used by e-commerce companies are Web-activity databases used to track customer behavior. 1.13 How do the e-commerce companies use these databases? - The e-commerce companies’ Web-activity databases are used to determine which Web page items are popular and successful, and to test if certain variations in Web page design will generate more orders. 1.14 How do digital dashboard and data mining applications differ from transaction processing applications? - Digital dashboard and data mining applications do not generate new data, but instead are used to summarize existing data to provide information to management. 1.15 Explain why a small database is not necessarily simpler than a large one. - While small databases vary from large databases in terms of the amount of data they...
Words: 1418 - Pages: 6
...Week One: Database Architecture | | Details | Due | Points | Objectives | 1.1 Explain database architectures. 1.2 Define database systems. 1.3 Define relational database architecture. | | | Reading | Read Ch. 1, “Database Systems,” of Database Systems: Design, Implementation, and Management. | 9/24 | | Reading | Read Ch. 2, “Data Models,” of Database Systems: Design, Implementation, and Management. | 9/24 | | Reading | Read Ch. 3, “The Relational Database Model,” of Database Systems: Design, Implementation, and Management. | 9/24 | | Reading | Reference Ch. 1, “Getting Started,” of Database Concepts as a supplemental reading. | 9/24 | | Reading | Read Ch. 1, “Introduction to Access,” of Exploring Microsoft® Office Access 2010 Comprehensive. | 9/24 | | Reading | Read this week’s Electronic Reserve Readings. | 9/24 | | Participation | Participate in class discussion. | All week | 2 | Nongraded Activities and Preparation SkillSoft® Registration | The first time you access SkillSoft®, you need to register.Do the following to register for SkillSoft®: Go to https://uopx.skillport.com Register by clicking on Register. The Register button is in the lower right corner, below the login boxes.Leave the Organization Code field blank.Use your phoenix.edu e-mail address.Use your student website login name as your user ID (the name before the @email.phoenix.edu).Click Submit. | 9/24 | ...
Words: 2242 - Pages: 9
...Event Coordinator What are the current problems that the Event Coordinator is having? (multiple choice, multi-select) ☑ System is disconnected from other departments. ☑ Too much manual intervention in the business process. ☑ Required information is not always available. ☑ Information retention is inefficient or non-existent. ☑ Poor use of available information technology resources. ☑ Insufficient use of database technology or tools. ☐ Poor communication. How could a proper database system and subsequent tools serve to improve the issues this department is having? (short answer) Have no database to keep track of clients. Only way of customer feedback is through cards and they do not reply. Database could do all that for them. They schedule staff by previous seasons. Database could give accurate occupancy. Database could advertise and rent rooms. Front Desk What are the current problems that the Front Desk is having? (multiple choice, multi-select) ☑ System is disconnected from other departments. ☑ Too much manual intervention in the business process. ☑ Required information is not always available. ☑ Information retention is inefficient or non-existent. ☑ Poor use of available information technology resources. ☑ Insufficient use of database technology or tools. ☐ Poor communication. How could a proper database system and subsequent tools serve to improve the issues this department is having? (short answer) Recepts should be logged into...
Words: 619 - Pages: 3
...proposed system, along with the uses of the Website and database system. Moreover, this chapter will also present the computer programming language,, and methodologies used in the development of the system. 2.1 Introduction The basis of the development of a completely computer-based information system is very important. Such features that are comprise hereto include the database system, it consist of the Database Management System (DBMS) which is designed to manage all databases. The database is the most important structure of an information system. In this chapter, the theories used in the development of the proposed system will be discussed. In line with this is the database system, which uses a normalized database to encapsulate the constructs of a data model, to eliminate data redundancy, organized data effectively and to trim down irregularities during data operations. Another is the used of the Third-Generation Programming Language, also known as 3GL Computer Language like Visual Basic 6, a further advanced language to enable a more user-friendly interface in the system. Correspondingly, with the incorporation used of Structured Query Language or SQL to create, modify, retrieve, and operate data. other nodes is also the Graphical User interface or GUI to utilize the graphical images and text to signifies information for the end users. Indeed, GUI will aid the user to have an ease in navigating modules of the proposed system. Generally, the Systems Development...
Words: 1475 - Pages: 6
...of data in the early file-based systems. In the early file based system their all data was in written form, due to the lake of education, due to the in-familiarity with new techniques, lake of computer knowledge so all the data required would be stored in a file or files owned by the programs. Discuss the disadvantages of this approach. Different programs could be written in different languages, and would not be able to access another program's files. This would be true even for those programs written in the same language, because a program needs to know the file structure before it can access it. 1.4 Describe the main characteristics of the database approach and contrast it with the file-based approach. Focus is now on the data first, and then the applications. The structure of the data is now kept separate from the programs that operate on the data. This is held in the system catalog or data dictionary. Programs can now share data, which is no longer fragmented. There is also a reduction in redundancy, and achievement of program-data independence. 1.5 Describe the five components of the DBMS environment and discuss how they relate to each other. (1) Hardware: The computer system(s) that the DBMS and the application programs run on. This can range from a single PC, to a single mainframe, to a network of computers. (2) Software: The DBMS software and the application programs, together with the operating system, including network software if the...
Words: 2796 - Pages: 12
...Chapter 1 Database Systems Discussion Focus How often have your students heard that “you have only one chance to make a good first impression?” That’s why it’s so important to sell the importance of databases and the desirability of good database design during the first class session. Start by showing your students that they interact with databases on a daily basis. For example, how many of them have bought anything using a credit card during the past day, week, month, or year? None of those transactions would be possible without a database. How many have shipped a document or a package via an overnight service or via certified or registered mail? How many have checked course catalogs and class schedules online? And surely all of your students registered for your class? Did anybody use a web search engine to look for – and find – information about almost anything? This point is easy to make: Databases are important because we depend on their existence to perform countless transactions and to provide information. If you are teaching in a classroom equipped with computers, give some “live” performances. For example, you can use the web to look up a few insurance quotes or compare car prices and models. Incidentally, this is a good place to make the very important distinction between data and information. In short, spend some time discussing the points made in Section 1.1, “Data vs. Information.” After demonstrating that modern daily life is almost inconceivable...
Words: 4647 - Pages: 19
...comments: _____________________________________________________________________ Marks obtained : ___________ out of ______________________ Content of Homework should start from this page only: | | INDEX | | |1 | Elaborate on the advantages of DBMS over file system. | | |2 | Explain in detail the architecture of DBMS. | | |3 |What are the various responsibilities of a DBA. | | |4 |Give a comparative study of the file processing system and DBMS with a real life example. | | |5 |Suppose you are a database administrator for an organization. What are various steps that you will take for | | | |the efficient database management of that organization? |...
Words: 1998 - Pages: 8
...Database Systems and How They are Used DBM/380 Week 1 Individual Assignment Craig Gruenbaum Instructor: Kevin Judge Database Systems and How They are used Database systems are utilized in basically every business every day. Businesses use data to perform a multitude of functions, such as sales transactions, customer queries, and the viewing of key performance indicators. Database systems are the management tool that aids in accessing this data. “In a sense, a database resembles a very well-organized electronic filing cabinet in which powerful software (the DBMS) helps manage the cabinet’s contents”(Rob, P., Coronel, C., & Morris, S, 2013). Database Architecture Database Architecture refers to the design of the database. For example, databases can be designed for a single site or multiple sites, have lots of generic data or data designed for a specific purpose, or be transactional or analytical. Take Oracle database architecture for example. “Oracle9i, Oracle8i, and Oracle8 databases are powerful, flexible, and scalable relational database management system (RDBMS) servers that run on a range of computer systems, from personal computers to largest mainframes. Oracle is designed to run effectively in a client/server environment and supports hundreds to thousands of users” (Oracle, "Migration Process", 1998). Summary Without database systems, companies would have no means by which to access the information stored in their databases. This information...
Words: 497 - Pages: 2
...Database Design and how it is used at Wal-Mart Benjamin Stites DBM/380 7/2/2012 University of Phoenix. What is a Database System? A database system consists of four components which are the users, the database application, the database management system, and the database itself. We will describe all four components briefly. Database: The database allows a business to store important data using a collection of related tables and other structures. Database Management System: A database management system is a computer program that is used to create, process, and administer the database. (Kroenke & Auer, 2010) Database Application: A database application is a set of one or more computer programs that serves as an intermediary between the user and the database. They read and or modify database data by sending SQL statements to the database. User: The user is the fourth component of the database system. The user employs database applications to keep track of things. They use forms to read, enter, and query data, and they also produce reports. These four components allow the database system to work properly. How does Wal-Mart use its Database System? Wal-Mart is the largest retail company in the world. It needs to keep track of employee data, sales data, inventory data, profit data, and many other types of data throughout each of its stores. In order to keep up with this information Wal-Mart has outsourced its database to NCR. This allows Wal-Mart...
Words: 616 - Pages: 3
...Web 407 Week 3 Database Paper In the business world, most people will find a need for a database software program to store or house data pertaining to their business. There are however, multiple things to consider before one makes their final choice on what software they will be using. A few things that should be addressed are the type of software desired, either open-source or propriety, and what characteristics of the database meets the company’s needs. There are two basic types of database programs people can choose from when deciding what they want for their small business, an open-source database or a propriety one. While both of these are similar, they still have their advantages and disadvantages. First, consider what an open-source program is. The term open-source means exactly what it sounds like; the source code for the software is completely open and free to the public. Some advantages that come with this are the fact there is no upfront costs when it comes to obtaining the database program. While this sounds great, one needs to consider the tools the business has at its disposal. If you do not have the people to manage the databases and run them, then more employees must be hired in order to support the system. This can lead to more cost in the long run. So the fact that it’s free can also be a disadvantage. Another advantage to open-source database systems is a lot of them have a huge following such as MYSQL. MYSQL is database that is designed to use Standard...
Words: 917 - Pages: 4
...1 Introduction to Databases LESSON 1 Database Learning Objectives: On completion of Lesson 1, you should have been able to: 1. Describe the role of a database system 2. Briefly describe the evolution of database systems and the limitations of conventional file processing systems 3. Describe the three schema architecture for database and explain the difference between conceptual , external and physical schemas 4. Define the functions of a database administrator Keywords and Phrases LEARNER Database Database System Entities Conceptual Model Logical Model Physical Model Constraints Metadata Database Management System File System Indexing Introduction This module introduces the reader to the different concepts of databases. It also tackles a brief history how automated databases came into existence. A number of advantages is discussed why the evolution of database management system is very much appreciated by system developers nowadays. 2 What is a Database ? Let us try to get the answers from the different Database Management System book authors. Answer from Pratt/Adamski: o A Database (DB) is structure that can store information about: 1. multiple types of entities, 2. the attributes that describe those entities; and 3. the relationships among the entities Answer from Elmasri/Navathe: o A Database (DB) is collection of related data - with the following properties: 1. A DB is logically coherent and has some relevant meaning 2. A DB is designed, built...
Words: 6349 - Pages: 26
