Draw an erd for initial entity list

Assignment Help Software Engineering
Reference no: EM1371827

Busicorp is an online provider of software business objects. Authors create the objects and submit them to Busicorp for consideration. Customers purchase business objects by credit card or electronic payment service and then download the objects locally. The database does not contain object code, but does store the physical path tot he object and its documentation. authors are paid quarterly on a royalty basis.

Note: Royalty statements normally include an item breakdown. For the purpose of this project, you are concerned about quarterly royalty payments only, not item details.

The database should be documented through entity relationship diagrams. The database must be normalized to the third normal form. entity integrity must be enforced on all tables. XML deliverables must be well-formed XML documents.

Deliverables, Requirements and Timeline:

1) Basic database requirements. Prepare a list of possible entities for the database. Include a list of values that must be tracked for each entity. Identify any tables that would have related values.
2) Create an ERD for the initial entity list. Identify a primary key for each entity and establish relationships as appropriate. The entity list for this purpose is as follows:

Entity: Author
Attributes: Name, Address, AuthorID, Royalty payments.

Entity: Customer
Attributes: Name, Address, CustomerID

Reference no: EM1371827

Questions Cloud

Draw and implement abstract base class : Draw and implement the abstract base class ArithmeticExpression which represent any binary (having two arguments) arithmetic expression.
Determine the optimal package price : The American Baker's Association reports that yearly sales of bakery goods last year rose 15%, driven by a 50% increase in the demand for bran muffins
Determining fixed-marginal and average costs : Consider a firm with total short-run cost function C=a+b.Q. New legislation means that it should pay an environmental tax which is the fixed sum, independent of whether it produces any output.
Calculate time weighted rate of return : A portfolio manager is being evaluated based on the time-weighted average rate of return. If the manager had achieved annual returns for the past three years of 2.5 percent, 14.5 percent and 9 percent on one initial investment of $500,000,
Draw an erd for initial entity list : Draw an ERD for initial entity list. Recognize a primary key for each entity and establish relationships as appropriate. Entity list for this purpose is as follows.
Explain you are expected to convey complex ideas : Explain You are expected to convey complex ideas in a clear, concise and organized fashion using the required and recommended readings from the course for analytical support.
Colleges and universities professor salaries : At several universities and colleges, business professors receive higher salaries than professors in others fields. Why might this be the case?
Which expressions run in concurrent processing environment : Rewrite each of the given expressions for concurrent processing and then code each one. Use terms COBEGIN and COEND to delimit the sections of concurrent code.
Find the holding company beta : ABC corporation is a holding company with three subsidiaries. The following information pertains to these subsidiaries:

Reviews

Write a Review

Software Engineering Questions & Answers

  Research report on software design

Write a Research Report on software design and answer diffrent type of questions related to design. Report contain diffrent basic questions related to software design.

  A case study in c to java conversion and extensibility

A Case Study in C to Java Conversion and Extensibility

  Create a structural model

Structural modeling is a different view of the same system that you analyzed from a functional perspective. This model shows how data is organized within the system.

  Write an report on a significant software security

Write an report on a significant software security

  Development of a small software system

Analysis, design and development of a small software system.

  Systems analysis and design requirements

Systems Analysis and Design requirements

  Create a complete limited entry decision table

Create a complete limited entry decision table

  Explain flow boundaries map

Explain flow boundaries map the dfd into a software architecture using transform mapping.

  Frame diagrams

Prepare a frame diagram for the software systems.

  Identified systems and elements of the sap system

Identify computing devices, which could be used to support Your Improved Process

  Design a wireframe prototype

Design a wireframe prototype to meet the needs of the personas and requirements.

  Explain the characteristics of visual studio 2005

Explain the characteristics of Visual Studio 2005.

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