Database Management Systems - 953 Words

Assignment 02 Due date: 1 August 2012 NB: Make sure you select the correct unique number for your module from those indicated below. Unique number 759546 Tutorial matter covered in the prescribed 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 database 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-valued attributes and simple attributes. Give an†¦show more content†¦Each time a new product is created, it must be added to the product inventory, using the PROD_QOH in a table named PRODUCT. And each time the product ABC is created, the parts inventory, using PART_QOH in a table named PART, must be reduced by one each of parts A, B, and C. The sample database contents are shown in table 2. Table 2: The database for question 7 Table name: PRODUCT PROD_CODE ABC PROD_QOH 1,205 Table name: PART PART_CODE PART_QOH A 567 B 498 C 549 On the basis of the above information, answer questions 7.1 to 7.3. 7.1 How many database requests can you identify for an inventory update for both PRODUCT and PART? (2) 7.2 Using SQL, write each database request you identified in question 7.1. 7.3 Write the complete transaction(s). (2) (20) 9 EXAMINATIONS Use your my Studies @ Unisa brochure for general examination guidelines and examination preparation guidelines. 10 None OTHER ASSESSMENT METHODS 11 FREQUENTLY ASKED QUESTIONS Here are some of the questions (with their answers) that students repeatedly ask. Where can I get hold of a copy of the textbook? Rob, Coronel and Crocket (2008) is a popular database textbook that many students from different universities use. You are therefore advised to purchase the book as soon as possible. If the University bookstore does not have the book in stock, ask them to put your name onShow MoreRelatedDatabase 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 Management Systems4660 Words   |  19 PagesDatabase 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, andRead 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