Wait a second!
More handpicked essays just for you.
More handpicked essays just for you.
Relational database models research
DATABASE SYSTEM CONCEPTS(2nd
DATABASE SYSTEM CONCEPTS(2nd
Don’t take our word for it - see why 10 million students trust us with their essay needs.
Recommended: Relational database models research
In this paper I will be discussing the differences and similarities of the three database models we have talked about in class the Entity-Relationship, Object model, and the UML modeling. First let’s look at the definition of the three models.
The Entity- Relationship Model is used to visually represent data objects and is used for database design. It is easy to understand which makes it easier to communicate the design to the end user. The form used in the ER model can easily be transformed into relational tables. (Information Technology Services [ITS], 2004)
Another database model we went over in class is the Object Model. There are three concepts to understanding the Object Models one of them being the Data Abstraction which is the process of condensing data down to its essentials. Another one is the Inheritance in the object model is the means of defining one class in terms of another. The third concept in the object model is the Encapsulation which is the concept of including processing or behavior with the object instances defined by the class. Encapsulation allows code and data to be packaged together.
The third database model would be the UML model that stands for Unified Modeling Language used for writing software blue prints. The UML can be used to visualize, specify, construct, and document the artifacts of a software-intensive system. (Safari Tech Books Online, 2002, chap. 2)
Some of the similarities in the database model are that all three can be used in the database design process in some way. In our previous class DBM 380 we used the ER model for our projects even from our preceding projects we can create the database model in an Object or UML model. Of the three database models I find that the Entity Relationship model was the easiest to create and explain to an end user it also transforms effortlessly into relationship tables which worked well in Access. The Object model and UML model seem to be more of a language model than the ER model seems to be more for just databases although the Object model addresses both programming and databases. The UML model is more for intense software programming such as Java programming it would allow you to visualize and document your programming steps before starting the code.
The next project deliverable is a robust, modernized database and data warehouse design. The company collects large amounts of website data and uses this data to analyze it for the company’s customers. This document will provide an overview of the new data warehouse along with the type of database design that has been selected for the data warehouse. Included in the appendix of this document is a graphical depiction of the logical design of the
Now click the “ENTER” key on your keyboard, on your computer is operating in ‘Safe Mode’.
A subclass is needed in data modeling, because it is the easiest way to explain the inheritance relationship between two classes. A subclass is a class that was originated from a new class.
A database management system, or DBMS, gives the user access to their data and helps them transform the data into information. Such database management systems include dBase, Paradox, IMS, and Oracle. These systems allow users to create, update, and extract information from their databases. Compared to a manual filing system, the biggest advantages to a computerized database system are speed, accuracy, and accessibility.
In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system. The original project on the relational database system was for the government (Central Intelligence Agency) and was dubbed ‘Oracle.’ They thought this would be appropriate because the meaning of Oracle is source of wisdom.
[7] Elmasri & Navathe. Fundamentals of database systems, 4th edition. Addison-Wesley, Redwood City, CA. 2004.
A database management system (DBMS) is computer software designed for the purpose of managing databases. Typical examples of DBMSs include Oracle, IBM's DB2, Microsoft Access, Microsoft SQL Server, MySQL, 4th Dimension and FileMaker. DBMSs are typically used by Database administrators in the creation of Database systems.
Satzinger, Jackson & Burd (2010, pp. 488) further states that DBMS “provide designers, programmers and end users with sophisticated capabilities to store, retrieve and manage data”. Sharing and managing the vast amount of data needed by a modern organisation simply would not be possible without a database management system.
The Unified Modeling Language is a standard language for specifying, visualizing, constructing, and documenting the artifacts of software systems, as well as for business modeling and other non-software systems. The key is to organize the design process in a way that clients, analysts, programmers and other involved in system development can understand and agree on. The UML provides the organization. The UML was released in 1997 as a method to diagram software design, by some of the best minds in object oriented analysis and design. It is by far the most exciting thin to happen to the software industry in recent years. Every other engineering discipline has a standard method of documentation. Electronic engineers have schematic diagrams; architects and mechanical engineers have blueprints and mechanical diagrams. The software industry now has UML.
A data dictionary is a place where the DBMS stores definitions of the data elements and their metadata. All programs that access the data in the database will work through the DBMS. It uses the data dictionary to look up the required data component structures and relationships, thus the users do not have to code such complex relationships in each program. In addition, any changes made in database structure will be automatically recorded in the data dictionary, thereby freeing the users from having to modify all the programs that access the changed structure.
Database Systems has a practical, hands-on approach that makes it uniquely suited to providing a strong foundation in good database design practice. Database design is more art than science. While it's true that a properly designed database should follow the normal forms and the relational model, you still have to come up with a design that reflects the business you are trying to model. This paper shows describes design process of database project.
Databases are becoming as common in the workplace as the stapler. Businesses use databases to keep track of payroll, vacations, inventory, and a multitude of other taske of which are to vast to mention here. Basically businesses use databases anytime a large amount of data must be stored in such a manor that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user. Databases are used extensively where I work. In fact, since Hyperion Solutions is a database and financial intelligence software developing company we produce one. To keep the material within scope I shall narrow the use of databases down to what we use just in the Orlando office of Hyperion Solutions alone.
The database application design can be improved in a number of ways as described below:
The Database Management System (DBMS) is software that enables the users to define, create, maintain and control the access to the database. It is a software that interact with the user’s applications programs and it database. Meanwhile, information retrieval system is a system that involved the activity that the systems obtain the information. The obtaining information action need the information from it resources.
In our world, people rely heavily on the power of technology every day. Kids are learning how to operate an iPad before they can even say their first word. School assignments have become virtual, making it possible to do anywhere in the world. We can receive information from across the world in less than a second with the touch of a button. Technology is a big part of our lives, and without it life just becomes a lot harder. Just like our phones have such an importance to us in our daily lives, database management systems are the same for businesses. Without this important software, it would be almost impossible for companies to complete simple daily tasks with such ease.