Implement the data modelling for a database

Assignment Help Science
Reference no: EM13937904

Implement the data modelling for a database that is based on the following application scenario. The application scenario The online sale company Best Deal needs to implement a database to manage its business data. The company has delegated this task to an IT service company.

As an officer of the IT service company, you are delegated to be the designer and developer for the database. To accomplish this task, you will divide the design and development tasks into two assignments.

In this assignment (assignment- 1), you will do the data modelling.

In assignment-2, you will design and implement the database and relevant SQL queries. Consequently, a successful data modelling of this assignment is also important for assignment-2. The Best Deal sells smart phones or services in two ways.

1. The brand new phones are only for sale. The sale is in auction style. A new phone can be listed with a starting price and available numbers etc for a few days (e.g. 3 days). During this period, a buyer can put a bid with an offered price for a listing.

At the end of the period, the listing can have a number of bids. Based on the bids of a listing, sale transactions may happen between the sellers and buyers. 2. The used phones are only for rent. A buyer is to submit an application for renting a phone. As a result, rent transactions may happen between sellers and buyers. 3. As described above the customers of Best Deal are either sellers (selling or leasing phones) or buyers (buying new phones or renting the used phones).

A seller must have a registered payment method (e.g. PayPal) for the income from selling and a registered payment method (e.g. PayPal) for paying management fees to the Best Deal. A buyer could have a registered payment method (e.g. PayPal) for paying any purchased items or just paying by credit card directly when buying. However either a seller or a buyer must have at least a phone or a mobile or an email contact.

The above application scenario was not given in very detail for the entities or relations because one of your tasks for this assignment is to analyse and make some assumptions on the business data of the Best Deal. You may need to do some research about the online sale data management, so browsing sale items on eBay (https://www.ebay.com.au/) is useful to understand and model the business data of such an online sale database.

The assignment specification You are to develop an ER model for the data management of the Best Deal. You will provide the ER model in terms of: 1.

The assumptions and business rules that you have made for the entities, relationships and cardinalities that involve in the Best Deal data management. Justify your assumptions if necessary. You need to make sure that the assumptions and the identified entities and the relationships cover the given application scenario. 2 2. An ER diagram. You need to use the standard notations (as given in the textbook) to present the ER diagram, clearly representing entities and relationships, cardinalities and primary keys and using super types and sub types if necessary. Note: use of a formal modelling tool such as Microsoft Visio is not required for the ER modelling. 3. Entity and relationship and cardinality definition.

In textual description, you need to briefly define entities in terms of attributes and relationships between them and describe the cardinality of relationships. Note: supertype, subtype and associative entities are necessary and must be used for this data modelling. For example, the common attributes (brand, model, colour etc) of a smart phone can be modelled into a supertype entity and the special attributes (connectivity, warranty etc) of new phones or those (data, call rates, weekly rent etc) of used phones can be modelled into 2 separate subtype entities

Reference no: EM13937904

Questions Cloud

Show how each transaction affects the accounting equation : Show how each transaction affects the accounting equation. Prepare the four basic financial statements for the month of April. (Balance Sheet at April 30, 2009)
Most protection from prepayment risk : What are the promised coupon payments to each of the classes during the first quarter? What is the total interest payment due? If the trustee received a payment of $4,834,796, how would the payment be applied? Assume that for the first year the trust..
Definition of the member functions to implement class : Write the definition of the member functions to implement the operations for this class. Also, write a program to test various operations on this class.
What are the total assets of the company at end of november : What are the total assets of the company at the end of November 2008? Prepare a statement of cash flows for November 2008. What was net income for November 2008?
Implement the data modelling for a database : Implement the data modelling for a database that is based on the following application scenario. The application scenario The online sale company Best Deal needs to implement a database to manage its business data. The company has delegated this t..
Benefits and challenges of integrating the operations : Apply a systems perspective to discuss why it is important to align the supply chain strategy with the design of the electronic business platform, and the benefits and challenges of integrating the operations of the two.
Compare two definitions of advanced practice nursing : Compare and contrast the two definitions of advanced practice nursing as defined by the American Association of Colleges of Nursing (AACN) DNP Essentials, the APRN consensus model, and as defined in your textbook.
Home equity line of credit : A home equity line of credit (HELOC) is, loosely speaking, like a credit card for your home. You can borrow money by drawing down on the line of credit. But, because the borrowed money is for the purpose of your home, the interest is tax-deductible m..
What is your annual after-tax return : If you earn 10% per year on your investments, but pay 35% in taxes on all of your investment returns, then what is your annual after-tax return?

Reviews

Write a Review

Science Questions & Answers

  Importance of water for life on earth to survive.

Explain what role women played in the Scientific Revolution of the 18th Century? What role do women in science play today?

  Explore the many different political views held by philosoph

Explore the many different political views held by philosophers, such as Thomas Hobbes, John Locke, and Jean-Jacques Rousseau. Explore the relevance of social political philosophy to contemporary social and political issues.

  Composition of earth atmosphere

Summarize the scienti?c data that indicate global warming is occurring as a result of human activity. What is the composition of Earth's atmosphere, and how has life a?ected the atmosphere during the past several billion years?

  Who drops out? what is a profile of a drop-out

Who drops out? What is a profile of a drop-out? What percent are males? What percent females? What is the racial distribution? Is there a class correlate? Are there more drop-outs in urban areas?

  What are the advantages and limitations of nuclear medicine?

What are the advantages and limitations of nuclear medicine?

  There are several factors that affect the value of a

there are several factors that affect the value of a security. these include the default risk marketability and

  Express a great deal of anxiety over

Express a great deal of anxiety over our willingness to break laws. This is certainly a legitimate concern. Since we so diligently urge people to obey the Supreme Court's decision of 1954 outlawing segregation in the public schools, it is rathe..

  What effect will this have on planet earth

The red shift seen in all distant galaxies, whose size is proportional to its distance from us, what effect will this have on planet Earth?

  Issue with protecting privacy rights of individual employees

What is your view of this issue with protecting privacy rights of individual employees?

  What is mutant bacteriophage

What is Mutant bacteriophage

  Challenges associated with lower forms of biometrics

What are some of the challenges associated with lower forms of biometrics, such as facial recognition, and acceptance as evidence in court?

  Which philosopher formulated laws of learning

At the end of 19th century, which philosopher formulated laws of learning as a result of his experiments with animals? Hill Gard Watson Edward Thorndike John Dewey

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd