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

  Sketch flowchart to print average for student

Sketch a flowchart to print average for each student in class.Input. Input consists of student records each containing student's name(STUDENT-NAME), score for first test(TEST), score for second test(TEST2), and score for third test(TEST3).

  As it project manager take systems view of project

As an IT project manager, you may take a systems view of a project. What does it mean to take a systems view of a project?

  Draw erd to show attributes of student

Draw and ERD for this situation. What attribute or attributes did you designate as the identifier for the STUDENT entity? Why?

  Use e-r approach to model operations of local library

Use the E-R approach to model the operations of your local community library. The library has books, CDs, tapes, and so forth, which are lent to library patrons.

  Draw entity relationship model for project management system

A consultant is not necessarily a project leader, but they can only be project leader for one project. Draw an entity relationship model for the project management System.

  Create a complete limited entry decision table

Create a complete limited entry decision table

  Risk management in tellers in four-digit numeric password

Tellers at each branch use a four-digit numeric password, and each teller's computer is transaction-coded to accept only its authorized transactions. Carry out a risk assessment.

  Determine order that breadth first search will expand nodes

Determine the order that breadth first search will expand the nodes? S,A,B,D,C,E,G. What is the order that depth first search will expand nodes? S,B,E,F,D,G

  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

  Concepts of software engineering

Explain the software measurement process and state how to implement the software measurement?  List the challenges and difficulties of applying the software metrics?

  Explain clark-wilson model is implemented on computer system

Assume that the Clark-Wilson model is implemented on a computer system. Could a computer virus that scrambled constrained data items be introduced into the system?

  Internal events by creatinguml one state diagram

Which event driven modeling can be used to illustrate how system responds to external and/or internal events by creating a UML ONE State Diagram.

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