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

  Describe how it applies to the realm of data communication

Write one to two paragraphs on each topic below, and describe how it applies to the realm of data communication. Also discuss what type of damage these computer infections can do to data in a computer.

  How would you advise people to eat healthy on a budget

How would you advise people to eat healthy on a budget? How would you respond to patients whose financial restraints limit their access to food

  Public policy and discuss how americans fare on key measure

Define public policy and discuss how Americans fare on key measures of childhood health and well-being and policies for the elderly. Then explain how both affluence and poverty can negatively affect development. Explain in 500 words

  Data presentation and analysis

Research topic Use of English. The end result should be a research report approximately 2,500- 3,000 words in length and structured like the report plan The distribution of maximum marks is as follows:

  The health risks associated with obesity

Identify and describe three new fitness habits that you could reasonably incorporate into your lifestyle. How could these new habits improve your health.

  The portrayal of science in media influence

How is science portrayed in fictional media (television shows, movies, music, books, etc.)? Is it seen as a positive, negative, or neutral force in the world?

  Describe the essential principles of phrenology

Describe the essential principles of phrenology and explain why it eventually failed as a science. Be sure to consider the research of Flourens in your answer. references 300 words in length and must pass through turn it in.

  Explain somatic and germline gene therapy

Explain Somatic and Germline Gene Therapy and categorized the sectionsand  Explain Germ line gene therapy and its vectors

  Initiative versus guilt captures the emotional

Erik Erikson's theory of initiative versus guilt captures the emotional and social changes of early childhood. A healthy sense of initiative depends on exploring the social world through play, forming a conscience through identification with t..

  Adequate to control machine guarding hazards

Discuss some of the problems that might be encountered when implementing OSHA's machine guarding standards in the workplace. Do you feel that the standards are adequate to control machine guarding hazards in general industry? Why, or why not?

  Listing in order of importance

Listing in order of importance, what do you think are the three biggest concerns about the health care system in the United States? Examples include health care costs, access to coverage, or government reforms.

  Laws for boolean algebras to convert

Given that there are 100 elements in A1, 1000 in A2, and 10, 000 in A3, find the number of elements in A1 ∪ A2 ∪ A3 in each of the cases below.

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