A television production company wants to start a Web site to sell items and replicas of items from its popular shows. Items on the site are generally sorted by show. People choose the items and add them to the shopping cart. At that point, they enter standard credit card data to check out. The server adds additional data such as the IP address of the user. Customers can also create accounts with a username and password. Create the class diagram and the list of the normalized tables (in a table notation form), for this TV Production company based on their business rules. As we discussed in class especially in this level there is not just one answer. You have to justify the decisions you made for the classes and the relationships. Show all the steps followed to reach the final tables and class diagram. Make sure to include the As-is, 1NF, 2NF, and 3NF normalizations when you submit (50 points)
Sale Date Shipping Address City, State, ZIP
Last name, First name
Billing Address
City, State, ZIP Code Credit Card Number Expiration Date
IP Address
Username/password
USD TV Show Description Quantity Sale Price Value
Total Tax Shipping
Total Amount

If a firm plans to issue new stock, flotation costs (investment bankers' fees) should not be ignored. there are two approaches to use to account for flotation costs. the first approach is to add the sum of flotation costs for the debt, preferred, and common stock and add them to the initial investment cost. because the investment cost is increased, the project's expected return is reduced so it may not meet the firm's hurdle rate for acceptance of the project. the second approach involves adjusting the cost of common equity as follows: . the difference between the flotation-adjusted cost of equity and the cost of equity calculated without the flotation adjustment represents the flotation cost adjustment. quantitative problem: barton industries expects next year's annual dividend, d1, to be $1.90 and it expects dividends to grow at a constant rate g = 4.3%. the firm's current common stock price, p0, is $22.00. if it needs to issue new common stock, the firm will encounter a 6% flotation cost, f. assume that the cost of equity calculated without the flotation adjustment is 12% and the cost of old common equity is 11.5%. what is the flotation cost adjustment that must be added to its cost of retaine

Sally is buying a home and the closing date is set for april 20th. the annual property taxes are $1,234.00 and have not been paid yet. using actual days, how much will the buyer be credited and the seller be debited

Clooney corp. establishes a petty cash fund for $225 and issues a credit card to its office manager. by the end of the month, employees made one expenditure from the petty cash fund (entertainment, $20) and three expenditures with the credit card (postage, $59; delivery, $84; supplies expense, $49).record all employee expenditures, and record the entry to replenish the petty cash fund. the credit card balance will be paid later. (if no entry is required for a transaction/event, select "no journal entry required" in the first account record expenditures from credit card and the petty cash fund.