Database Management Systems - 4660 Words

Database Management System Basith Shaik Southern New Hampshire University September 7, 2015 Abstract The intent of this paper is to design and propose a database management system solution to Grandfield College for tracking software installed. I have analyzed the organizational issues and needs and developed conceptual, logical, and physical designs of DBMS solution. In order to implement the solution, substantial research had been done on best practices in design, available products, and the legal and ethical standards to which we must adhere during design. This paper includes Business rules, Conceptual, Logical, and Physical database designs, Recommendations on best DBMS required for Grandfield College, Data model, Legal†¦show more content†¦* Track requests of new software. Issues with current system * Some of the information is recorded in notebooks and not entered in spreadsheets * Reliable database is not available * People work in shifts to collect and preserve the data * There is no security provided for the records to protect against threats Highlights of Information provided * Installations are not entered until they have completed successfully. * Some installations can be done from network drives. * Some installation require media. * Instructors with administrative rights can check out software and do their own installations. * Instructors with administrative rights must sign an agreement and are responsible for their own support. Solution Looking at the requirements of Grandfield College, I have planned a solution with following steps are Step 1. Data Gathering: This task consists of the gathering of spreadsheets currently used by the software management team which includes the list of software, licensing of software, and all faculty and staff computers and what software is installed on each. Also included is a list of software requests. Step 2. Data Analysis: The data will be analyzed to determine database modeling. Step 3. Database normalization: Fields andShow MoreRelatedDatabase Management Systems953 Words   |  4 Pagesprescribed book Chapters 1 - 3: Chapter 5: Chapter 6: Chapter 7: Chapter 12: Chapter 14: Chapter 16: Revise as for Assignment 01 Entity relationship modelling Advanced data modelling Normalisation of databas e tables Transaction management and concurrency control Distributed database management systems Database connectivity and web development Question 1 What is a composite entity, and when is it used? [4 marks] [8 marks] Question 2 Briefly, but precisely, explain the difference between single-valuedRead MoreDatabase Analysis : Database Management System1137 Words   |  5 Pages Summary: Database Management System in easy terms we can say that set of data organized in a relative way. It allows data for various entries, storage and retrieval of large quantity of information and provides ways to manage how the information is stored. There is big number of database providers and each different database has its own strength so while choosing a particular database we need to understand what the business requirement is and match them with what DBMS can provide us to make ourRead MoreDatabase Management Systems802 Words   |  3 PagesQuestion 1: Differentiate between database management system and information retrieval system by focusing on their functionalities. Database management system (DBMS) is an application which interacts with the database at some point in its execution. While, the Information Retrieval System (IR) is the activity of gathering information resources which related to information need from a collection of information resources. Usually, we use metadata or full-text indexing in order to make a search onRead MoreDatabase Analysis : Database Management System Essay767 Words   |  4 PagesDatabase Security Databases are used to store different types of information, from data on an e-mail account to important data of government agencies. The security of the database inherits the same difficulties of security facing the information, which is to ensure the integrity, availability and confidentiality. Database management system must provide mechanisms that will assist in this task. SQL databases implement mechanisms that restrict or enable access to data according to profiles orRead MoreDatabase Analysis : Database Management System1114 Words   |  5 Pageson database environment and development process. Database is an organized collection of logically related data. It consists of tables, queries, views and other objects. Database management system is a software system used for creating and managing databases. It is a collection of programs used to store, modify and extract information from database. It helps users and programmers for creating updating and managing the data in a s ystematic way. There are many types of database management system rangingRead MoreDatabase Analysis : Database Management System Essay1337 Words   |  6 PagesDatabases are fundamentally containers for data. When data for any organization needs to be stored, databases can be used. For example, let’s say a public library stores books, we could say that the library is a database of books. But specifically, databases are computer structures that save, organize, safeguard and produce and/or deliver data. A database platform is essentially a database management system (DBMS) which is a computer software application that interacts with the user, other applicationsRead MoreDatabase Management Systems And Databases2603 Words   |  11 PagesAbstract: NoSQL Databases also referred as Not only SQL databases. These NoSQL database have these days gained much attention and reputation because of their performance and high scalability. The advantage of NoSQL database is to store efficiently unstructured data. These days use of e-commerce websites, social networking sites etc. has been increased. These usage made to create the need to store the large data. Some companies have adopted NoSQL databases, as their data is growing. Dynamo, BigRead MoreDescription Of A Database Management System999 Words   |  4 Pages A database is a collection of information sequenced and organized in such a way that the computer may be able to source and access it on demand by the operator. Like any other management system, a database management system is a collection of programs and protocols that enable the user to enter, sequence, organize, retrieve and select data on demand. Thus, a database management system (abbreviated as DBMS) can be defined as the cumulated system that helps the user to access and make effective useRead MoreDatabase Management System ( Dbms )1391 Words   |  6 Pages A database management system or DBMS is a certain type of system software, which is used for the creation, and management of databases. A DBMS serves for multiple purposes but is mainly used to provide users and programmers with a systematic way to retrieve, create, manage, and update data. A DBMS serves as an interface between data and its end user, making sure that data is consistently organized and remains easily acces sible to users. DBMS’s are vital to several aspects of our technological worldRead MoreThe Evolution Of Database Management System1099 Words   |  5 PagesThe Evolution of DBMS A database management system, also known as DBMS, is a type of software that is used in order to create and manage a multitude of databases. Data is the power that runs most modern businesses. This specific program provides a technique for people to use a â€Å"systematic† way to create, retrieve, update, and manage many diverse types of data. DBMS is used to manage three important things, which is data, database engine, and database schema. These different elements help to provide