Reference no: EM131765163
Assignment: Fundamentals of Databases
Question One
Normalize the following schema, with given constraints, to BCNF.
books(accessionno, isbn, title, author, publisher)
users(userid, name, deptid, deptname)
accessionno isbn
isbn → title
isbn → publisher
isbn → author
userid → name
userid → deptid
deptid → deptname
Question Two
1. Write SQL DDL corresponding to the following schema. Make any reasonable assumptions about data types, and be sure to declare primary and foreign keys.
2. Find the number of accidents in which the cars belonging to "John Smith" were involved.
3. Update the damage amount for the car with license number "AABB2000" in the accident with report number "AR2197" to $3000.
person (driver_id, name, address)
car (license, model, year)
accident (report_number, date, location)
owns (driver_id, license)
participated (report_number, license, driver id, damage amount).
|
Environmental factors to assess operational risk
: Can we look at environmental factors to assess operational risk? need some feedback to explain the pros and cons associated with this question.
|
|
Calculate the amount of the asset and liability
: Timothy Company signs a lease agreement dated January 1, 2016 with Jasper Company for equipment. The lease terms, provisions, and related events are as follows.
|
|
Decision to post the coffee-break notice
: List the pros and cons of Mr. Jackson’s decision to post the coffee-break notice. List the pros and cons of Mr. Jackson’s decision to post the coffee-break noti
|
|
Forecast next year cost of goods sold
: You forecast sales to increase to $110,000 next year. Using the percent of sales method, forecast next year's cost of goods sold.
|
|
Write sql ddl corresponding to the given schema
: Write SQL DDL corresponding to the following schema. Make any reasonable assumptions about data types, and be sure to declare primary and foreign keys.
|
|
Prepare and incremental analysis for the special order
: Gruner and Company produces golf disks which it normally sells to retailers for 7 dollars each. Prepare and incremental analysis for the special order
|
|
What are the robin prime costs
: Robin Company has the following balances for the current month: Direct materials used $14,500 Direct Labor $23,750 Sales salaries $13,600.
|
|
Preferred stock issued for company
: What is the cost of equity for Company DD, if there's no preferred stock issued for this company?
|
|
Compute current net income for nichols company
: Nichols Company makes three models of phases. Compute current net income for Nichols Company
|