Nobody downloaded yet

Database 2 - Assignment Example

Comments (0) Cite this document
Summary
Introduction This study is a discussion of the design and architecture of the global data model of a large or a medium size organization. It involves three different applications, which are of great interest to the organization. It therefore leads to the design and development of three Entity Relationship Diagrams for the different applications after which it develops the global data model…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER91.7% of users find it useful
Database assignment 2
Read TextPreview

Extract of sample "Database 2"

Download file to see previous pages It is a car rental company based in the USA. As a car hire organization, Budget Car Hire Company requires various systems to manage its operations. The company has branches all over the world and booking can be made directly via branched or online through the company’s website and agent websites. Three Proposed Applications In this report, three proposed applications that fulfill the companies’ needs will be discussed. Specifically, the three applications are to facilitate transactions and operations. The applications are: Direct Renting from braches. Online booking system. Car purchasing system. The systems will have to be integrated into a single database and network for the purpose of data access and processing. This is the function of the data modeling process. Brief overview of the Applications Direct renting from braches This application describes the transaction where the client goes directly to the companies’ branches and asks for a car to rent. Depending on the availability of car, the customer has to provide staff with his licenses, bank card number and personal information such as name, age and address. A customer must also buy an insurance package only then, a member of staff will enter the information n the system and give back an invoice along with the car keys. Online booking system The online booking system is an application that will enable customers to do car reservation online through Budget website. The online booking should be able to process the booking and produce the corresponding confirmation message or travel vouchers to the applicant. The customer must fill a form on Budgets website that provides the company with his/her information like name, age, address and other personal and paying information. Most importantly, the type of car, pick up and return time and date, location. The website calculates the price for the selected vehicle for the specified period. After that, customers receive an email confirmation. Car purchasing system The third application is for car purchasing, where employees in the logistics department Budget gets to interact with different car vendors. The Budget employee has to select the car type, color, model, price and quantity. After that the application generates the name of the buyer (Budget), seller (vendor), purchasing date and time and the total price of the transaction including the cars specifications, quantity and date of manufacture. Key Data Required for Each Application The systems require various data items because they all manage different data and processes. Each database will have various datasets. Of course, some of the data sets will have common data fields shared between themselves (Heath and Bizer 36). The databases for each application will have local model with entity relationships specifically between the entities in them. Overall, the local models will be linked into a larger model, the global data model. The global data model will link the three databases in such a way that the three applications have relationships with each other through the relationships in their entities. Direct renting from braches Direct renting from braches application will have the following data entities: Entity Attribute RENTAL RENTAL_NO Primary Key (PK), CUST_ID foreign key (FK), RENTAL_TIME, RENTAL_DATE, PICKUP_DATE, RETURN_DATE, PICKUP_TIME, RETURN_TIME, CAR_ID (FK), PRICE_PAID, ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Database assignment 2 Example | Topics and Well Written Essays - 2500 words”, n.d.)
Database assignment 2 Example | Topics and Well Written Essays - 2500 words. Retrieved from https://studentshare.org/information-technology/1494069-database-assignment
(Database Assignment 2 Example | Topics and Well Written Essays - 2500 Words)
Database Assignment 2 Example | Topics and Well Written Essays - 2500 Words. https://studentshare.org/information-technology/1494069-database-assignment.
“Database Assignment 2 Example | Topics and Well Written Essays - 2500 Words”, n.d. https://studentshare.org/information-technology/1494069-database-assignment.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Database assignment 2

Relational Database Assignment

...?Relational Database Importance of Relationships in Database Design Relationships play an extremely important role in the design of a database. In order to come up with the most appropriate design, it is imperative that one knows which relationship needs to be used. The four prime factors that control the integrity of a database include relationship-level integrity, attribute-level integrity, business rules, and entity-level integrity (Lathem, 2008). Using these relationships, one can divide the data in separate tables. This assists the user in matching the data with the help of common characteristics contained in the data set including the relation or tables....
3 Pages(750 words)Assignment

Database assignment

...? Database assignment affiliation: Lecturer: CA Erwin Data Modeler versus Oracle SQL Data Modeler Introduction Data modeling involves documentation and formalization of pre-existing events and processes that are generally applicable during the overall development and design of an application. The concerned techniques used for data modeling and the accompanying tools allows for input, translation and conversion of various system designs (both complex and simple) into processes and data flow representations which are easily read and understood . This whole function has brought a breakthrough in the fields of re-engineering, modeling and construction. Considering a data model, it is a flowchart or diagram that brings out the specific... tools....
10 Pages(2500 words)Assignment

Database Management System Assignment

...development. Deciding which database system, operating system, or hardware configuration is best suited for the application is now feasible. Existing benchmarks do not provide any analysis of storing BLOBs within the database and are generally completed by the database or hardware vendor rather than the consumer. CHAPTER 1 INTRODUCTION With the passage of the Utah Digital Signature Act of 1995 [1] and the Federal Electronic Signature Act of 2000 [2], more and more paper documents are being stored electronically. These digitized documents have "electronic signatures" attached to them that serve not only as unique identifiers but make them legally binding and enforceable...
19 Pages(4750 words)Assignment

Distributed database development assignment

...@inventory.au.clear_waters.com; could be used to access data from the orders table in the MGT1 schema of the remote inventory database. Similarly, a remote update statement or query could be used to modify data in one or more tables, where all the tables are located at the same remote node. For example, the query: Update MGT1.orders@customer.au.clear_waters.com Set o_methpmt=’check’ Where c_id=2; A subquery, that retrieves data from more than one remote nodes, could also be included in an update statement, but since the update query is executed at only a single remote node, it is classified as a remote update. Distributed SQL Statements As opposed to the Remote SQL Statement, the Distributed SQL...
10 Pages(2500 words)Essay

Television and Internet

...Television, internet, radio, it. These persona and characters reign. First off: Hannah Montana. No kidding, who does not know her? She’s the girl who has the best of both worlds! This series that airs in Disney Channel is about Hannah, the girl who is living every teenage girl’s fantasy: rocking it out as a pop singer while enjoying the comfort of normalcy. I can’t help but think how similar those little girls’ adoration to Hannah with the days when a certain blond girl sang “Hit me baby one more time!”. Disney certainly knows how to market their star. Because of the very large fan base the hit teen sitcom went to have top grossing concerts and movies. It catapulted the lead star, Miley Cyrus, to up roaring fame. Still the success...
1 Pages(250 words)Assignment

Information Systems (Database Assignment)

...or higher processing speed Motherboard: Compatible with CPU Hard Disk: 40GB or more Ram: 1 GB or more Standard Keyboard and mouse Laser Printer Software Requirements: Windows XP/Vista/Seven MS Access 2003 / 2007 Operating Instructions Starting the system: In order to run the system, the user will need to open the program Ms Access and in that the file library_db. Once the database file opens, the user will have different options Entering Data: There are three forms where data can be entered. These are: 1. Books 2. Members 3. Loans In order to insert a new record, click on the button at the bottom this says ‘add new record’. Data can also be added directly through database tables Viewing...
5 Pages(1250 words)Essay

Modern Database Managment Assignment Three

...Database Management Question and Answers Describe a relational DBMS (RDBMS), its underlying data model, its data storage structures, and how data relationships are established. Chapter 7 Review question #5, page 348. Relational DBMS or RDBMS is a database that is structured into a series of tables also called relations that are simply reorganized to access data in different ways. At the present, relational model is broadly utilized. Additionally, the databases which are based upon the relational model are acknowledged as relational databases. The relational model employs a set of tables/relations to demonstrate both data as well as the associations between those data. In...
3 Pages(750 words)Essay

Mordern database Managment assignment Four

...article or web site article that pertains to data warehousing or data mining. It can be a testimonial or case study from a company that has set up either one as well. This needs to-be a 2-3 page paper on how their experience relates to the material from the text. In the paper, explain why organizations use data warehousing, data mining and why it is so popular and often necessary for organizational information. Presently there have been extensive growth in the use and development in the database technology. Additionally, this new and advanced technology of the database is used to manage large volumes of organizational and business data. In addition, the utilization of...
5 Pages(1250 words)Essay

Week 7 Hand-In Assignment

...independence? Explain your answer. Answer: A database management which helps to isolate the softwares or programs from the data used by the program is known as data independence. This kind of data independence can be achieved by restricting the applications to redefine or reorganize the data. By such restriction the data will remain consistent or in other words it will be independent of the programs using it. The concept of data independence helps to improve the maintenance and management of database in single user environment (Wisegeek, 2011). #2. Identify two benefits of separating application software from the database management system. End users, usually those who...
3 Pages(750 words)Assignment

Database Administration -2

...://www.cwjobs.co.uk/careers-advice/profiles/it-database-administrator> [Accessed 17 Nov. 2012] Rouse, M., 2006. Database. [online] Available at: database> [Accessed 18 Nov. 2012] Rushinek, A., Rushinek, S. F., 1985. Database Administration in Accounting Information System. University of Miami, Coral Gables, NY, USA Loremate, n.d. Database Management System. [online] Available at: 2> [Accessed 18 Nov. 2012] PennState, 2008. Characteristics of Database. [online] Available at:...
4 Pages(1000 words)Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Assignment on topic Database assignment 2 for FREE!

Contact Us