... | | |College of Information Systems & Technology | | |DBM/380 Version 9 | | |Database Concepts | | |July 16, 2012 to August 13, 2012 | | |Group KM11BIT13 | Copyright © 2012, 2010, 2008, 2007, 2006, 2005, 2003 by University of Phoenix. All rights reserved. Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • University policies: You must be logged into the student website to view this document. • Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be...
Words: 3236 - Pages: 13
...Assignment 2: Logical Design, Part 1 Due Week 2 and worth 50 points You have been hired by ACME Global Consulting to procure requirements for a large database. In developing database management systems, E-R models are used to graphically depict complex relationships between entities. In this assignment, you are to convince a set of clients of the benefits of using an E-R model in developing a database. Write a two to three (2-3) page paper in which you: 1. List the advantages of a relational model specific to ACME Global Consulting. 2. Summarize in your own words the purpose of an E-R model specific to ACME Global Consulting. 3. List and describe essential components of the model such as entities, attributes, keys, relationships, roles, and dependencies specific to ACME Global Consulting. 4. Describe the need for the enhanced E-R model and how we can create sophisticated models to help us in complex environments. 5. Outline and describe the advantage of using the relational model. 6. Create an E-R diagram using graphical depicting software that could theoretically be used in a restaurant application. Note: The graphically depicted solution is not included in the required page length. Acceptable software used to depict the solution includes any drawing tool, such as Microsoft Visio, Microsoft Paint, open source alternatives or similar drawing tools. You are free to formulate constraints, entities, attributes, etc. Potential entities may include but are not limited to customers...
Words: 449 - Pages: 2
...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
...Assignment # extended definition Term: Database management. Tejaswy. Polasani 901767790 ENG 160-104 DT: 09-26-2014 Data is a vital part in any organization. It has to be stored, organized, manipulated and protected. Database management system stores the data in such a way that inputting, outputting, storing, retrieving and managing information becomes easier .It is a software that provides interface between users and databases and responsible for maintaining the integrity and security of stored data, and for recovering information if the system fails. The four components of dbms are: Users, Database, Database application and Database Management Systems. Users: they use forms to read, enter, delete and query data. The users include administrators, end users and designers. Administrators: They look after the maintenance of the database which include system license and other things related to maintenance. End users: They are the business analysts. Designers: They design the database. Database systems: create and process forms, queries, control data base applications. Database: It is used to create, monitor and access the database. Dbms performs the following functions....
Words: 504 - Pages: 3
...Assignment 1: Business Rules and Data Models A database is an incorporated PC structure that stores end-user information and metadata (Leake, A.). Data is the raw format of information, which when structured properly, it can produce accurate, relevant, and timely information that is the key to making a good database management system. The true purpose of a database is to provide computer-based systems a way in which to store, manage, and retrieve data quickly. A local college has tasked me to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants me to make the database keep track of the instructors teaching each of the courses. The local college database, will be to store the data of enrolled students, the courses offered and class schedule, and the information of the instructors. The database will provide course matches for each student based off previous courses taken and pre-requisites obtained, as well as keep track of the instructors that are teaching the class. The database will provide the data a student needs to insure they are taking the correct courses and provide the college and the faculty general student information, such as student ID. Entities (Tables) are defined as a person, place, thing, or event in which data is collected and stored. Each entity is a unique object that may be a physical or abstract object within real life (for example:...
Words: 780 - Pages: 4
...Assignment 1: Business rules and Data Models Darryl W Anderson CIS 111: Introduction to Relational Database Management Systems Kean University requested that I develop a database for their college. The purpose of the database will be to track the students and the courses. They also want a place in the system to track the instructors teaching each course. There are many things that need to be considered in developing this database. This paper will outline the entities, attributes for each entity, the type of relationship, constraints, some business rules, and the conceptual and physical models. There will be three main entities in the system; the students, the instructors and the courses. First, the students’ attributes will include; last name, first name, social security number, phone number, date of birth, address, student ID, level of education, enrollment date, GPA, any standardized test scored, all accepted credits, and their class schedule. Next the courses attributes will include the course name and specific class code. Finally, the attributes for the instructors will include the last name, first name, teacher ID, salary, address, telephone numbers, certifications, degrees, and the course and class code they are teaching. This will make the system easier to keep track of instead of having it spelled out next to either the instructors' or the student's name. The relationship of this database would be a many-to-many relationship. This would be because each class can...
Words: 619 - Pages: 3
...Assignment 1: Business rules and Data Models CIS 111: Introduction to Relational Database Management Systems Purpose of Database Spellman University had requested that I develop a database for their college. The purpose of the database will be to track the students and the courses. There also will be a place in the system to track the instructors teaching each course. There are many things to be considered in composing this database. This paper will outline the entities, attributes for each entity, the type of relationship, constraints, some business rules, and the conceptual and physical models. Entities and Attributes of Database There will be three main entities in the system; the students, the instructors and the courses. The students’ attributes would be last name, first name, social security number, and phone number, date of birth, address, student ID, level of education, enrollment date, GPA, any standardized test scored, all accepted credits, and their class schedule. The attributes for the instructors would be last name, first name, teacher ID, salary, address, telephone numbers (and or extensions), certifications, degrees, and the course code that they will be teaching. The courses attributes would be a specific course code. Along with the course code each individual class would have to have a code as well. This would make the system easier to keep track of instead of having it spelled out next to either the instructors' or the student's name. The relationship...
Words: 691 - Pages: 3
...Benefits of a Database and Information-Gathering Techniques CIS111 July 27, 2013 I am being interviewed by ACME Global Consulting services as a potential new employee to its growing work force of world-class systems analysts and requirements engineering group. Through a tip, I found out that they will be asking several questions relating to planning for a new database for one of their national restaurant chains. I found out that one of the executives at the restaurant chain only believes in using Microsoft Excel for running reports. For this assignment I will be focusing on 3 main topics. First, I will describe the benefits of using a database management system and how it supports this restaurant chain. Second, I will propose how I would address the issues with flat file systems, such as Excel and Text files, for storing data. Lastly, I will list and describe three tools, techniques, or methodologies for eliciting and documenting requirements related to the development of a new database. So, as you see, you have your plenty of things to get ready for. A Database Management System (DBMS) is the software system that allows users to define, create and maintain a database and provides controlled access to the data provided by your database administrator(s). DBMS is an intermediate layer between programs and the data. Programs access the DBMS, which then accesses the data. There are different types of DBMS ranging from small systems that run on personal computers, corporation...
Words: 941 - Pages: 4
...Week 1 Assignment: Databases Maurice Eugene Northam III DBM/380 January 12, 2015 Bill Enloe Databases Database Management Systems (DBMS) are mind boggling, mission-discriminating programming systems. Today's DBMS’s epitomize many years of scholastic of a, what's more, mechanical examination and exceptional corporate programming advancement. Database Management Systems were among the soonest broadly conveyed online server systems and, accordingly, have spearheaded configuration arrangements crossing not just information administration, additional system applications, working systems, and organized administrations. The early DBMS’s are among the most powerful programming systems in software engineering, and the thoughts and execution issues spearheaded for DBMS’s are broadly duplicated and reexamined. For various reasons, the least of database systems building design are not as extensively known as they ought to be. First and foremost, the connected database systems group is genuinely little. Since business compels just help a couple of contenders at the top of the line, just a modest bunch of fruitful DBMS’s usage exist. The group of individuals included in outlining and actualizing database systems is tight: numerous went to the same schools, took a shot at the same compelling exploration ventures, and worked together on the same business items. Second, scholastic treatment of database systems frequently disregards building issues. Course reading presentations of database...
Words: 955 - Pages: 4
...IS 380 Assignment 1 Chapter 1 1. A database stores: a. End-user data: raw facts of interest to end user b. Metadata: data about data, which the end-user data are integrated and managed) 2. A collection of programs that manages the database structure and controls access to the data stored in the database: Database management system (DBMS) 3. This is when you can change the file structure without affecting the application’s ability to access the data: structural independence 4. This occurs when not all of the required changes in the redundant data are made successfully: data anomaly 5. These are the functions of a DBMS: c. Intermediary between user and database d. Enables data to be shared e. Presents the end user with an integrated view of the data f. Receives & translates application requests into operations required to fulfill requests. g. Hides database’s internal complexity from the application programs and users 6. This is the de facto query language and data access standard supported by the majority of DBMS vendors: structured query language (SQL) 7. People naturally have an integrated view of the data in their environment. This leads to a new problem that has evolved with the use of spreadsheets and desktop databases. This problem is users lack proper data-modeling and database design skills. Chapter 2 8. This type of data model was developed in the 1960’s to manage...
Words: 738 - Pages: 3
...:BSCS-4B DBMS ASSIGNMENT NO.1 Q1: In the new industrial era how the databases made the information management easier as compared to the manual systems ? Ans : In Industrial Era the database made the information management easier as compare to the manual systems following way : DATA BASE MANAGEMENT SYSTEM(DBMS): Dbms is a collection of programs that manages the database structure and controls access to the data stored in the database. In a sense, a database resembles a very well-organized electronic filing cabinet in which powerful software, known as a database management system, helps manage the cabinet’s contents. IMPROVED DATA SHARING : The DBMS helps create an environment in which end users...
Words: 1129 - Pages: 5
...University Introduction to Relational Database Management System CIS111019VA016-1132-001 Jean-Robert Bokino January 11, 2013 Logical Design, Part I In this assignment, I will write a two to three page paper titled “Logical Design, Part 1” whereas I am a recently hired consultant for ACME Global Consulting to procure requirements for a large database. In this scenario, “Logical Design, Part 1”, I will develop a database management systems to convince a set of clients of the benefits of using the Entity–Relationship model (E-R) in developing a database. In addition, my management would like the following points addressed in my design: (1). List the advantages of a relational model specific to ACME Global Consulting. (2). Summarize the purpose of an Entity–Relationship Model (E-R) specific to ACME Global Consulting. (3). List and describe essential components of the model such as entities, attributes, keys, relationships, roles, and dependencies specific to ACME Global Consulting. (4). Describe the need for the enhanced E-R model and how we can create sophisticated models to help us in complex environments. (5). Outline and describe the advantage of using the relational model. (6). Create an E-R diagram using graphical depicting software that could theoretically be used in a restaurant application. Now that you know the purpose of this assignment, I will define three key terms that will be discussed in this assignment. The first term is Database (DB), which is a collection of information...
Words: 1493 - Pages: 6
...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
... Page 19 Conclusion Page 20 Bibliography Page 21 Introduction In the following assignment I will present an introduction to databases which will demonstrate my knowledge through creating reports, defining key terms and there advantages and disadvantages, as well as designing an entity model. These will support my knowledge. TASK 1 Diagram 1: Marks & Spencer’s three-layer relational database architecture related to their online activities. Internal Schema (Server) Conceptual Schema (Programmer) External (Customer) External (Supplier) External (Business partners) External (Departments) As shown in diagram 1, a 3-layer Relational database separates the physical database from the user applications. The following schemas are defined at each of the following levels: * Internal * Conceptual * External “The DBMS is responsible for mapping between these...
Words: 2877 - 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
