StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

Database Design and Implementation - Assignment Example

Comments (0) Cite this document
Summary
Even though it does not have as much traffic as e-bay, it generates quite a number of sales. The fact that it does not charge listing fee puts it at a greater competitive edge over the similar online…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER96.4% of users find it useful
Database Design and Implementation
Read TextPreview

Extract of sample "Database Design and Implementation"

Download file to see previous pages A major downside of this site is that it is very slow. The seller is not required to pay any fee for posting an item for sale. The sites has strong measures and applications installed that ensures that it is fraud proof and the sellers can list as many items as they want as opposed to most online purchasing sites.
E-bay is one of the leading online shopping market place where buyers and sellers transact a wide variety of goods and services worldwide. It has become a multi-billion dollar company after it was founded back in 1995. It has included buy-it-now as a standard shopping, an expansion from its original auction format. A number of items, from cars to antiques, are listed by a seller who then chooses to only accept bids for the item thus enabling the buyer to purchase the item immediately. The first buyer eager to pay the sellers stated price gets the item on a buy-it-now option.
All the three sites have five major entities that is; the auction, product, payment, seller and the buyer. Of the four entities only three are actively involved at any given time, mostly, the auction, product and the buyer. The three entities have major common attributes across the three sites most of which were identified as the generic attributes. The product id, seller/.buyer id and the product id alongside other attributes formed the major attributes across the three sites.
The other attributes that were rejected were either irrelevant or less important and could be retrieved through the major attributes such as the auction, seller/buyer or product ids. Normalizing the possible tables consisting of the entities alongside their attributes led to the rejection or dropping off of some attributes to avoid data redundancy.
The product name, product description, product prices and product image from the auction table can be compressed into a different table named product with a primary key being product id. The auction table therefore will be normalized ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Database Design and Implementation Assignment Example | Topics and Well Written Essays - 5000 words”, n.d.)
Database Design and Implementation Assignment Example | Topics and Well Written Essays - 5000 words. Retrieved from https://studentshare.org/information-technology/1609904-database-design-and-implementation
(Database Design and Implementation Assignment Example | Topics and Well Written Essays - 5000 Words)
Database Design and Implementation Assignment Example | Topics and Well Written Essays - 5000 Words. https://studentshare.org/information-technology/1609904-database-design-and-implementation.
“Database Design and Implementation Assignment Example | Topics and Well Written Essays - 5000 Words”, n.d. https://studentshare.org/information-technology/1609904-database-design-and-implementation.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Database Design and Implementation

Database Design and Implementation

...? Database Design and Implementation -For Assignment and Relocation Office [Pick the Contents Introduction: 3 Analysis and Design3 2.Physical Design 7 3.Queries 10 4.Critical Review 13 5.Security Issues 14 Conclusion: 16 Appendix A 18 Reference 26 Introduction: This Report presents a detailed overview of analysis, design and implementation of database for Assignment and Relocation Office (ARO) using SQL SERVER. The report starts with the detailed analysis of the requirement, suitable solution for the design and all the assumptions made while designing the model. The ER diagram which visualises the overall operation of ARO is also presented along with a detailed Data dictionary for all the entities defined in the model. Followed by the data...
13 Pages(3250 words)Coursework

Database Processing: Fundamentals, Design, and Implementation

... the possibilities of delivering erroneous information to the end-users. References Bruce, T. A., 1992, Designing Quality Databases With Idef1X Information Models, New York: Dorset House Publishing. Kroenke, D. M. 1997. Database Processing: Fundamentals, Design, and Implementation, New York: Prentice-Hall Ramez, E., Navathe, S. B. 2007. Fundamentals of Database Systems (5th edition Ed.). Boston: Pearson/Addison Wesley....
10 Pages(2500 words)Term Paper

Database implementation and querying

...?Table of Contents Table of Contents TASK Output of the Given Queries TASK 2: Design Queries 64 Task 3: Database Structure Critique 68 TASK Output of the Given Queries SQL*Plus: Release 11.2.0.2.0 Beta on Wed Aug 17 16:57:29 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. SQL> drop table a1_language 2 commit; SP2-0640: Not connected SQL> connect Enter user-name: system Enter password: Connected. SQL> drop table a1_language; drop table a1_language * ERROR at line 1: ORA-00942: table or view does not exist SQL> commit; Commit complete. SQL> create table a1_language ( language varchar2(15) constraint language primar y key); Table created. SQL> insert into a1_language values ('Romanian'); 1 row created. SQL> insert into a1_language...
8 Pages(2000 words)Essay

The Design and Implementation of a Database Managed Website

...Contents Executive Summary 2 Introduction 3 Aims and Objectives of Dissertation 3 Dissertation Structure 4 Literature Review 5 Content Management System 5 Cascade Style Sheets (CSS) 6 PHP Programming 6 MySQL Database 7 Apache Web Server 7 Developing a Database Managed Website 7 Business Case Analysis 9 Introduction to the Company 9 Problems with the Current Website 9 Business Requirements For the New Software System (Website) 10 Software / Website Design 12 Hardware and Software Requirements for Design and Development Work 12 Database Design 13 Screens Design and Layouts 19 Implementation 23 Future Enhancements 27 Conclusion 29 References 30 Executive Summary Development of modern technology, especially internet has affected all areas...
20 Pages(5000 words)Assignment

Database Design

... on a day-to-day basis for the quantity of gas being transported every day. Logical Design: The logical design is implemented using the Entity Relationship diagrams as follows Entities: The entities identified in the logical design of the application include 1. Customer 2. Validation 3. Meter 4. Supplier 5. Billing and Reconciliation Among the aforementioned the first four are the primary entities in the database with the Billing and Reconciliation forming the transaction in the system. This makes it clear that any trigger implemented with regards to the finance processing will reflect upon the transactions on billing and reconciliation entity only. The relationships between the entities identified are discussed below followed...
14 Pages(3500 words)Essay

Relational Database Design

...Relational Database Design The Design of a Relational Database by This paper describes the process of creating a relational database. Itincludes the SQL code (MySQL) for creating the tables, the joins to create the necessary relationships and the results of those SQL runs. It describes the specifications of the proposed system, the logic of that system, the table definitions and contents, a live transaction which inserts data and one that deletes it and finally a non-trivial query which demonstrates multiple joins, group functions, qualifiers and correlation variables. Relational Database Design The hallmark of the relational database is that when one table changes in the database all other tables are updated and are current. 1...
6 Pages(1500 words)Assignment

Database Design & Development

... unless COMMIT statement is executed. This ensures consistency and integrity of data. SQL Server ensures that all the changes that are brought about in the data are ACID-compliant, therefore all operations are either allowed to complete successfully or be undone if unsuccessful. SQL Server implements this mechanism by a write-ahead log. Any required changes to a page will perform two tasks- update the in-memory cache of the page and state the operation in a log with the respective Transaction ID. Each entry in the log is unique due to a Log Sequence Number. This log enables the system to ensure the integrity of the data incase of a failure of the system (Delaney 2005). SQL Server allows simultaneous multi-user access to the same database...
4 Pages(1000 words)Essay

Database Implementation

Database Manipulation Task Database Manipulation Introduction Normalization is the process by which one breaks down the files into tables in order to create the database. There are three to four steps which are followed when normalizing a table. The first step is the First Normal Form (1NF), the second type of normalization is the Second Normal Form (2NF), the third form is Third Normal Form (3NF), lastly is the Boyce-Codd Normal Form (BCNF). There are other forms of normalization although, they are rarely used. This paper tries to analyze how one can break down the files into the table for the sake of creating a database (Churche, 2007). Database is said to be normalized if only it is in 3NF.
First Normal Form (1NF)
The f...
2 Pages(500 words)Essay

Database systems analysis & design

... was to define the EA Model. Based on the system requirements drafted previously, all the entities with their associated attributes are shown in Figure 2. In order to design a valid EA model, each entity is ensured to have a primary key attribute (PK). Figure 2 EA Model for University System 1.3. Entity-Relationship-Attribute Diagram (ERA Diagram) In the last phase, the two models (ER Model and EA Model) are combined and revised to form the final ERA Model. A. Revision of the ER Model In the ER Model, a many-to-many relationship “grades” existed between the Section and Student. This could pose an issue during the actual database implementation as either of the involved entities can be a parent or child. So, an associative entity...
12 Pages(3000 words)Assignment

Database design

...Database design: The database design is a very critical unit for any individual who has interest in the computer technology field. A database system is a worthy asset of any business organization. As such its administration should be effective. For one to ensure effective database management and administration, one need to fully understand the database design. The unit has enabled me gain substantial knowledge on design and management of database. The course gives a detailed introduction of database design. The introduction to database design gave me in-depth understanding of how the idea of database originated from. From the introduction, I learned that the idea of database management system arose as a result of the unending...
2 Pages(500 words)Essay

Lean Design ERP Solution in Management

It is proposed that the company should implement a Lean Design and for this, it should select for suitable Enterprise Resource Planning (ERP) software from an experienced vendor.

The Project Management Teas has recommended Lean Design because it offers scope for reducing inventories and introducing ways and means to improve productivity by planning the optimal use of resources. By elimination of all activities that do not add value and/or are safety nets, maximum use of scarce resources like capacity, manpower and capital becomes achievable. It also results in value addition for the customer, improved bottom line and enhanced productivity of employees.

This is the ultimate objective of Lean Design. This is a...
10 Pages(2500 words)Term Paper

Cross-cultural Design Issues

This section aims to address the specific aspects and elements, which are needed when analysing websites; in order to be able to understand to what extent the designs exhibit variations that relate to cultural differences.
In the second part, a framework of Hofstedes analysis is applied to Astra Company. It aims to analyse the cultural content of the web sites at perceptual and behavioural levels. This framework introduces different dimensions of culture, and the affects these may have in user- interface designs.
Astra Web Design Company was establish by an extremely motivated group of marketing managers, software designers in addition to developers in 2001. The company is situated in the USA by means of other offices mutu...
11 Pages(2750 words)Essay

The Importance of Good Leadership in the Implementation of a Successful Organizational Change

Since the year 2000, globalization has led many large business organizations to implement a long list of necessary changes in order to keep their business competitive within the global market. These changes may be influenced by both internal and external factors. (Burke, 2002)  Internal factors could be the introduction of a newly appointed general manager that came from a different company and cultural background or a change in organizational policy.  On the other hand, external factors may include new customers’ preferences in terms of products and services, a new direction with regards to where the market is heading, constantly changing the educational level of the potential manpower or the technological changes...
12 Pages(3000 words)Research Paper

The Implementation of ICT in Primary Education

To add to the same discussion, we see that the E-governments encompass a number of different models including the Government to Citizen, also known as the Government to Customer, Government to Business and lastly Government to Government. There is a general point of view that large projects like ICT and similar ones must be avoided because ICT projects somehow or the other fail and the money and efforts thus spent on the same go down the drain at the end. ICT projects undoubtedly raise the bar as there are few instances where ICT projects have failed to materialize. These include the police force IT project which could not kick off in the first place and be abandoned mid-way during its implementation since the costs that were expe...
10 Pages(2500 words)Term Paper

Future Digital Design Process

As we shape up the interface between the designer and the virtual environment we are naturally going to produce a greater and far better outcome.
It will enable the end-user to be more creative and experimental and explore possibilities that were previously tedious or impossible. The design possibilities of virtuality will enhance the outlook of environments.
Now we can also term it according to the duration it can last. For any new thing, the duration is 10-30 years. If it lasts for 10 it would be popular as a tool another 10 and it would very well be a theory and if it survives all 30 years it will soon be defined as a revolution.
It was the end of the 20th century and the beginning of the 21st century that saw th...
21 Pages(5250 words)Assignment

A Hydrograph of River Cynon and Design of an Open Channel

...Storm Drainage Design Project: A Hydrograph Analysis of River Cynon and Design of an Open Channel 0 Introduction River Cynon is geographically located in South Wales and stretches from Hirwaun to Abercynon as a major tributary of the River Taf. The river has a catchment area of 160 square kilometers. Rainfall and river stage is monitored at Station 57004 at Abercynon operated by the Environment Agency in Wales. The station is a Flat V weir, which serves as a velocity-area station for high flows. Gauging history revealed that this station is over-topped by extreme floods and receives effluent discharges from industrial areas within the catchment. The station is located at elevation 81.2 m (Centre for Ecology and Hydrology [CEH], 2005...
9 Pages(2250 words)Report

Syllabus Design for Learners of English as a Second Language

The translation and transmutation of syllabuses into the teaching procedures are generally recognized by the established conceptions of the second language learning methodologies, predominant amongst them are the Grammar Translation Method and Audiolingual Method. These notions in addition to the emergent concepts aiding to the structuring of the syllabus and curriculum for English as the Second Language are critically discussed in detail in this literary essay.

English being globally considered and established as the ‘lingua franca’ whether in terms of international communications or technological interrelations, hence English as the second language is extensively popularized and most sought after language...
7 Pages(1750 words)Research Paper

User-Friendly Website Design and Programming

The ability to have the correct design and program as well as the options for user-friendly sites will not only affect the use of the site but will also make a difference in how the company or individual site is represented. Examining the different components of the designing and programming will make a difference in how the users are able to work with different sites.

The common use of websites to find information and businesses has also led to preferences that users have for web sites. Programmers need to keep the idea of what users recommend with websites first. This will make a difference in their desire to navigate through a site and to move through the various pages that send the required information about a busin...
9 Pages(2250 words)Lab Report

Modern Database Managment

As stated more technically, two conditions that indicate when a designer should consider while using supertype/subtype relationships are a- there are attributes that apply to some (however not the entire) of the instances of an entity type, b- the entity instances of a subtype participate in the relationship unique to that subtype (Date, 1995).

Attribute inheritance is about a supertype and subtype relationship. Attribute inheritance is the main characteristic of subtype entities that involve the inherited values of the entire attributes of the supertype. Attribute inheritance property for supertype and subtype relationships is significant because it makes it unnecessary to include supertype attributes redundantly with...
8 Pages(2000 words)Assignment

Urban Planning and Design

The urban fabric is constructed with very many different parts like the building design, services, utilities, streets, parks, drainage ways, natural areas and parking lots. The good urban design promotes how buildings are scaled and oriented towards the street. Walkways are landscaped to buffer between pedestrians and vehicular circulation.
Urban design can be defined as the discipline through which planning and architecture can create and renew a sense of local pride and identity. Urban design is concerned with the arrangement, functionality, and appearance of towns, with a particular interest in the shape and use of urban public space according to Mcgill (2010). Traditionally it has been regarded as a subset of urban planni...
7 Pages(1750 words)Coursework
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 Design and Implementation for FREE!

Contact Us