Assignment 2 Database Management Systems

Data objects can model relational data or advanced data types such as graphics, movies, and audio. Smalltalk, C++, Java, and others are objects used in object-oriented data. The object-relational is a combination of relational and object-oriented databases. Traditional and advanced data types can be used to construct database management systems. These systems can connect to a company’s website and update records as needed. Database Approach The main purpose of a database is data storage that can be stored and retrieved when needed. A popular common language called structured query language (SQL) is used to store and retrieve data in relational database. This language enables the systems to run a report or modify data or remove the data from the database. A database management system (DBMS) controls all aspects of a database, this is not limited to the creation, maintenance, and use of database. The DBMS ensures proper applications are able to access the database. An important purpose of a DBMS is to maintain the data definitions (data dictionary) for all the data elements in the database. It also enforces data integrity and security measures. Data Models Data models provide a contextual framework and graphical representation that aid in the definition of data elements. In a relational database, the data model lays the foundation for the database and identifies important entities,

* Instructors with administrative rights must sign an agreement and are responsible for their own support.

A Relational Database Management System (RDBMS) is a type of database management system that stores data in the form of related tables. The system does not require many assumptions about how data is related t or how it is to be extracted from the database. The database can be viewed in several forms.

DAO stands for Data Access Object. DAO provides data operations without exposing the details of database. The advantage of using DAO is it provides isolation between business logic and data persistence. Either the business logic or database can be changed without effecting the functionality of other. This mechanism is implemented using Hibernate. Hibernate is an object relational mapping framework which provides mapping between object oriented data model to relational database. Hibernate uses Annotations for mapping of object oriented data to relational

ADO.NET separates data access from data manipulation into different components that can be used separately at the same time. ADO.NET includes data providers for connecting to a database, executing commands, and retrieving results. These results can either be processed directly or placed in DataSet object that gets exposed to the user.

Provides UML modelling for database designs, with the ability to represent the integration of data and application requirements through logical and physical designs

A relational database management system is a type of database management system that stores the data in the form of related tables. The tables might be related to each other by common fields. It consists of a set of tables or files containing data that is fitted into predefined categories. These tables have data in the forms of rows and columns. Relational databases enable users to perform deletion, updating, reading and creating the data entries in the database tables. This is accomplished though structured query language, or SQL. SQL also provides users the facility to manipulate and query data in a relational database. It also provides the facility of multi user accessibility that can be controlled

Nowadays, data is being generated by multiple sources around us at an alarming rate, be

Structured Query Language, commonly referred to as SQL, is a programming language that is used to communicate with and handle databases. In order to maximize the outputs that they get from the huge amount of data collected, many companies and establishments employ IT professionals well-versed in SQL. SQL programs are adopted and used by companies in order to access and influence the data and information that is maintained in their databases, as well as for generating and modifying new tables.

The concept of data warehousing dates back to the late 1980s when IBM researchers Barry Devlin and Paul Murphy developed the “business data warehouse”. Data warehouse (DW) is an application which allowed you to execute ad-hoc queries; multi-dimensional analysis and query information by

Flexibility – This is obvious in the name, User-Defined Data Type, as it allows great flexibility when creating

Introduction: eXtensible Markup Language is used mainly in most of the organizations for e-commerce and online applications. Indeed, XML has become the standard for representing, exchanging the data among the various applications on the internet. Moreover, XML schema is used for representing the XML document structure where XML data is associated with the XML schema. Furthermore, data warehouse provides tools which business use the data for making the important decisions. Correspondingly, data is stored in the fact table and multidimensional tables. Mainly, the table association between them are generally represented with the three data warehouse schemas like a) star schema b) fact constellation schema c) snowflake schema. Simultaneously, the use of the internet is increasing day by day and by first integrating the data and secondly converting the data into XML schema from the schema graph to the various data schemas. At first, schema graph is taken as the model for the conversion of the data that is extracted from the XML schema and the data is transformed into the various schema. Consequently, the data warehouse schema is constructed with these fact tables, dimension tables and the relation existing between the graph and tables.

8. A(n) Data Definition Language (DDL) is a collection of instructions and commands used to define and describe data and relationships in a specific database.

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

Roger K. Doost, (2002) "The need for change in the way we teach accounting information systems", Managerial Auditing Journal, Vol. 17 Iss: 5, pp.277 – 282