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

  Identify the principal for viewpoint hierarchy diagram

Identify the principal viewpoints which might be taken into account in the specification of this system and organize these using a viewpoint hierarchy diagram.

  Describe the role of the soap

Describe the three entities and three operations that represent the Web Services model defined by SOA. (Support your answer with a diagram) Describe the role of the following three core Web Service standards- i SOAP ii WSDL iii UDDI

  Factors significant effects on initial cocomo estimate

Suggest four factors that might have significant effects on the initial COCOMO estimate and propose possible values for these factors.

  Identified systems and elements of the sap system

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

  Draw flowchart-write pseudocode to represent logic

Draw a flowchart or write pseudocode to represent the logic of a program that allows the user to enter three values.

  How to draw flow chart to read employee master file

How to draw a flow chart to read the employee master file and to output the number of employees in each department who have a basic degree

  Create and annotate class hierarchy for types of faculty

Create and annotate a class hierarchy to represent various types of faculty at a university. Show what characteristics would be represented in various classes of hierarchy.

  Modularity can have negative as well as positive effect

Modularity can have a negative as well as a positive effect. A program that is overmodularized performs its operations in very small modules, so a reader has trouble acquiring an overall perspective

  Give three network addresses

Subnet 2 is to support up to 95 interfaces, and Subnet 3 is to support up to 16 interfaces. Give three network addresses (of the form a.b.c .dJx) which fulfill these constraints.

  Describing arrow points to object in communication diagram

Why would you design a communication diagram instead of sequence diagram? Describe what the arrow which points to the object in a communication diagram signifies.

  Draw e-r diagram when doctor prescribe drugs for patients

Draw the E/R diagram for following situation: Doctors prescribe drugs for patients. A given doctor can prescribe many drugs for a certain patient.

  Design entity relationship diagram for catered accommodation

Design an entity relationship diagram for the case, explaining any suppositions you deem essential for atered or non-catered accommodation at the centre.

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