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
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:
|