...Curtis Fowlkes CIS111 July 14, 2016 Assignment 1: Business Rules and Data Models The purpose of a database is to collect, store and organize data. A database can be abruptly described as a repository for data. This explains that building databases is really an extension of a human activity that has lasted since writing began and it can be applied to the result of any bookkeeping or recording activity that happened long before the arrival of the computer era. The creation of a database is required by the operation of an enterprise. The college keeps records of its students, its instructors, the courses that are taught by the college, the grades the students receive, and the assignments of advisors to students, as well as other aspects of the activity of the institution. Most online databases are measured relational databases and are shaped using controlled query language generally referred to as SQL. This type of database uses multiple tables of data that are related and ties them together with keys; a common identifying code. In database language, the white pages contain a table in which each subscriber is represented by a record and each subscriber record includes three fields: name, address, and phone number. The records are arranged alphabetically by the name field, which is called the key field. Entities are the things in the real world that we will store information about in the database. A student would be one entity and the class would be another...
Words: 647 - Pages: 3
...Running head: ACCESSING ORACLE Accessing Oracle Intro to Relational Database Management Systems CIS111 Professor Rachelle Howard October 21, 2012 Accessing Oracle Accessing Strayer University UNIX server is an information technology tool that assists the completion of curricula activities and student lab assignments designed to expand the knowledge base in relational database management systems. For the first assignment, the following steps were taken to accomplish access to Oracle: 1. The first step to get to the Oracle server, Click on Start-> Programs -> Putty, was simple and easy. 2. After typing in the host name, UNIX-online.strayer.edu, I ensured the port was set to 22 and that the radio button was set for SSH. After entering Student Unix Server in the Saved Sessions box I selected “open” instead of going to the next step of selecting Category, which caused me to have to start over. 3. In the Category area on the left I selected Window. In the Columns and Rows boxes I entered 120 and 60 respectively to set the initial window size when opening the terminal window. Under Lines of scrollback, I enter 20000 and verified the remaining boxes. 4. I experienced dificulty with setting the colours. Under the Categories\Window to select Colours I selected ANSI Blue and typed in the values in the illustration before I selected Modify. I changed the colour to yellow and selected OK. This caused me to start the initial setup from step 1. I repeated this...
Words: 471 - Pages: 2
...LOGICIAL DESIGN PART 1 Jon Jones Professor Segura CIS111 Intro to Database Mgt Systems April 20, 2013 The ACME Global consulting will provide software development solutions, offer advice and support and structure within a company. From short to long term project as well as small to large sized businesses and corporations. The main components that apply to this are having a set of domains and sets that represents data structure, Integrity of rules that ensures data protection and operations that will carry on data. The company needs to have an understanding of data and functional needs of the company. The relational model can be used with both databases and the management systems. The relational model would allow the designer to develop the logical structure and specify what needs to be done and provide options for the design. The advantages of the relational model would be simplicity of the concept, implementation design and Ad hoc capability of query implementations. The purpose of E-R model for the ACME global consulting is to inform clients of a powerful database design that the relational model can show. The E-R model consists of components like entities, attributes and relationships for example. The model helps provide a visual representation of the data needs. The relational model can apply to databases and the management systems. By seeing the visual diagrams Acme global consulting would be able to see clearly and understand the data requirements of the...
Words: 641 - Pages: 3
...Database Design: Relational Database Management Systems Marvin E. Eubanks CIS111: Introduction to Relational Database Management Systems Strayer University Professor: Emelda Ntinglet-Davis November 22, 2011 Introduction Regardless of the size of a company or business, the employees are usually considered the most important asset. However, data should rank equally important as the employees do. It is very vital that a company’s data is stored and maintained as accurately and as quickly as possible. Having a Database Management System allows a business to do just this. Database Management System (DBMS) Webopedia (2011), states it simply: “A DBMS is simply the software program on a computer that is used to store and manipulate data.” Manipulation of data consists of adding new data such as adding personal information about an employee; deleting unwanted data such as deleting the personal information of an employee who has quit or been terminated; or changing existing data such as changing the pay rate of an employee who has been promoted. Advantages to having a DBMS are it aides in data security, data integrity, data sharing, data concurrence, data independence, and data recovery to name a few. Database management systems are important because it allows businesses to manage data more efficient and effective; query language allows quick responses to ad hoc queries; improves access to more data; and reduces the chance that data will be inconsistent. Features...
Words: 899 - Pages: 4
...Entities, Attributes, Business Rules and Database Models CIS111 Deontae Gaskins Ali Rahat-Zafar Strayer University April 13, 2016 Entities, Attributes, Business Rules and Database Models A database is defined as a grouped and organized set of data held in a computer system. A college database, therefore, can be defined as a small repository for its operational data. A college can use a database to access, manage and update its functional data. Additionally, it can use the database to track the information regarding its instructors; students, courses taught, and students' grades. A college needs an effective data management system. Such a system should be a collection of software, data, hardware, and users that are necessary to help the college manage its operational data. The major function of any database management system is to provide reliable and efficient methods of retrieving data to users. Therefore, a college database management system needs to be designed in a way that will allow several users to access several data items simultaneously or a similar data item frequently. Entities and attributes STUDENTS STUDENTS GRADES GRADES INSTRUCTORS INSTRUCTORS COURSES COURSES Diagram 1: A simple entity-relationship model. The above entity-relationship model is essential in designing a college database. Such entity-relationship model must use the concepts of the entity, attribute and relationship intuitively. Entities are key objects in the college...
Words: 799 - Pages: 4
...Running head: PROGRAMMING METHODS 1 College Databases Kenny Johnson Prof. Mark Cook CIS111: Introduction to Relational Database Management Systems April 20, 2014 Databases are used to store data and retrieve them quickly for processing. All businesses use a database to help them keep their information organized and available when needed. The data in the database is organized in a database management system. A database management system is a collection of programs that manages the database structure and controls access to the data stored in the database (Coronel, Morris & Rob). A business organization that uses a database is a college or university. Currently, at the time the student is admitted to the college all of the information is done manually by ink and paper. This is very time consuming and requires a lot of effort and time. Therefore, it is required to design a database system to make the work more efficient and speed up the process. The database management system will be fast and convenient, easy to operate and easy to edit and delete student information. The purpose of the database will store the records of students, teachers and courses. The database will keep track of students and the courses that they have taken. The database will also keep track of the instructors teaching each of the courses, Some of the entities that will be used in the college database management system are Student, Teacher, Course and Fees....
Words: 951 - Pages: 4
...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
...Free eChapters (FALL 2012) eChapters offer students immediate access to the first few chapters of their textbooks while they are waiting for the print book to arrive. eChapters help students to keep up with required reading and assignments until they receive their course material, without having to pay expedited shipping costs. eChapters that are available from the publisher are attainable free of charge. How do students gain access to free eChapters? Not all courses or textbooks have eChapters available. For all courses where eChapters are available, the files are located in the student’s Blackboard course shell under the Student Center. Below is a list of courses with eChapters loaded into the course shells, giving students free access as of the first day of classes. * = eChapters are forthcoming Course ID ACC100 ACC206 ACC303 ACC304 ACC305 ACC306 Text Title Accounting Principles – 9th edition Accounting Principles – 9th edition Intermediate Accounting 14e Intermediate Accounting 14e Intermediate Accounting 14e Microcomputer Applications for Accounting Excel 2010 Microsoft® Excel 2010: A Case Approach, Complete, 1st Edition, copyright 2011 SOUTH WESTERN FEDERAL TAXATION 2012: COMPREHENSIVE, 36th ed. South-Western Federal Taxation 2013: Corporations, Partnerships, Estates and Trusts, 36th Edition Cost Accounting 13th 09 ed. Advanced Accounting 4th 10th ed. Auditing & Assurance Services 13th 10 ed. Core Concepts of Government and Not for Profit Accounting 2nd ed., 2011 ed ACC...
Words: 3676 - Pages: 15
