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 on
* Instructors with administrative rights must sign an agreement and are responsible for their own support.
# 6: Given a physical database containing tables and relationships and business requirements, create the necessary queries.
1) Correct the Economic Order Quantity (EOQ) and Reorder point (ROP) quantities for each of the five items mentioned in the case.
Lately, Mr. Milligan has become concerned with his inventory management methods. he now wants to better manage his inventory. As a starting point, he wants to examine his costs, sales, markup percentages, gross profits, and inventory levels. He asks you to review his inventory and make suggestions for improvement. He provides you with the data and asks you to prepare an Inventory Analysis worksheet.
Tasks: What should Alison do? o Develop plans to improve the inventory management o Develop time-based supply strategies to bring competitive advantages to the organization Identify the functions and forms of inventory What are alternatives for inventory management? o ABC classification o Supplier-managed inventories (SMI) o Just-on-time or Just-in-time (JIT) o Enhance the forecasting system (factor correlated with inventory variation) Provide training programs for current and new hiring employees 1
1. Use E-R model to get a high-level graphical view of essential components of enterprise and how they are related
At the U.S. Census Bureau, hundreds, perhaps more than a thousand heterogeneous databases are currently operating. Some divisions have standardized the database technology on Oracle, while others are using a combination of Sybase, MySQL, SQL Server, etc. These Relational Database Management Systems (RDBMSs), supporting many databases and applications and each hosted on dedicated servers, are often under-utilizing the server resources available to them. Such a database infrastructure, therefore, is not cost-, or resource-effective from a maintenance or administrative standpoint. Consequently, the best solution to mitigate these issues involves the implementation of database consolidation technology. Database consolidation is the process of centralizing database resources, so that they are shareable among several databases and instances. In other words, it is the process of consolidating databases from multiple servers onto one or fewer servers. For example, Multitenant Architecture of Oracle 12c moves the database management principle to a completely new level with database consolidation. Consequently, for the U.S. Census Bureau, consolidation initiatives such as the following are beneficial:
Under those circumstances on what really the definition of repository is and what it contains, the report entitled Digital Repositories Review conducted by JISC (2005) emphasizes the definition of repository as follows:
NoSQL is generally interpreted as “Not only SQL” [1]. It is a class of database management systems that are used for non-relational database. Typically NoSQL database does not use two-dimensional table to store data. The four generally categories of NoSQL database are key-values database, column databases, document databases, and graph databases [2]. NoSQL database is an indispensable part of big data. Most company choose NoSQL database because it yields better performance when compared to relation database. Many relational databases have been existing for more than 20 years, while most NoSQL databases have a history of less than 5 years. Because NoSQL databases are so young, they exposes lots of security issues. Many NoSQL databases are still focusing on adding features and improving performance, while strength security mechanism is still a low priority task. There were already two data breaches happened in companies that are using NoSQL databases (MongoHQ in 2013 and LinkedIn in 2012 [3]).
In Nowadays, there are two major of database management systems which are use to deal with data, the first one called Relational Database Management System (RDBMS) which is the traditional relational databases, it deals with structured data and have been popular since decades since 1970, while the second one called Not only Structure Query Language databases (NoSQL), they are dealing with semi-structured and unstructured data; the NoSQL types are gaining their popularity with the development of the internet and the social media since April 2009. NoSQL are intending to override the cons of RDBMs, such as fixed schemas, JOIN operations and handling the scalability problems. In this paper we will review one of the graph database (Neo4j), which the graph database is part of the emerging technology that is called NoSQL and compared it with one of the traditional relational database (MySQL). MySQL, it is being another name for Relational Databases and it has been used for a long period time until now. However, with the emergence of Big Data there was clearly a need for more flexible databases. Facebook 's Graph Search using Neo4j, a graph database, is an application which clearly displays how relationships need to be modeled in a more efficient and sophisticated manner than using conventional relational models. In this paper, we will make a compare between MySQL and Neo4j based on the features like ACID, replication, availability and the language that is used in both of
Performance measurement is the process of collecting, analyzing and/or reporting of key defined metrics regarding the performance of database management components and the overall database management system.
What is database management system? Database Management System is a database program. The DBMS manage incoming data, organize it, and provided ways for the data to be modified or extract by users or other programs. This cause, most database software comes with an Open Database Connectivity (ODBC) driver that allows the database to integrate with other databases. For example, common SQL statements such as SELECT and INSERT are translated from a program's proprietary syntax into a syntax other databases can understand. Some DBMS examples include PostgreSQL, MySQL, SQL Server, Microsoft Access, Oracle, FileMaker, RDBMS, dBASE, Clipper, and FoxPro. It is a software system that uses a standard method of retrieving, and running queries on data.
The present tendency for developing an ontology-based data management system (DMS) is to take advantage of on attempts made to design a preceding well-established DMS (a reference system). The method aggregates to bring out from the mention of DMS a section of schema applicable to the new application requirements – a module –perhaps personalizing it with additional-conditions w.r.t. the application under building, and then directing a dataset using the resulting schema. In this project, we expand the current denotations of modules and we inaugurate novel effects of robustness that furnish means for examine easily that a robust module-based DMS develops safely w.r.t. both the
The terms data and Internet are connected with one device and its call “Computer”. Now a day’s people are taking more interest regarding data and related terms. In general database means a collection of information that is organized so that it can easily be managed, access and update. In General, databases can be classified according to types of content: bibliographic, full-text, numeric, and pictures. Whereas, Internet play an important role in today’s world. The meaning of INTERNET means an electronic communications network that connects computer networks and organizational computer facilities around the world. Internet is connected with two different part called intra and net. Moreover, it includes business, instructive, administrative, and other networks, all of which utilize the same arrangement of interchanges conventions.
Abstract- The multidimensional growth in computing systems and technologies have resulted in advanced scalable, portable and large scale integrated systems and technologies. Datacenters, virtualization, cloud and WEB2 technologies are the frontiers of such growth. [1] Cloud computing represents an important step towards realizing McCarthy’s dream that all aspects of computation may someday be organized as a public utility service. Both public and private cloud platforms are looking to deliver the benefits of cloud computing to their customers. The database is a critical part of this platform. Therefore cloud database need to be compatible with cloud computing. [5] Though cloud computing offers huge opportunities to the IT industry, there are many issues still to be addressed in the current scenario.[6]