Sustainability taskforce: You have signed on as a member of Sustainability Taskforce, which sponsors ecologically oriented community projects of various kinds (such as building and distributing composters or constructing energy‐efficient low‐income housing). You have volunteered to start building a relational database to replace the hodgepodge of spreadsheets currently being used to track membership and projects. Assume … Read more
Company ownership and boards: A government regulatory agency is trying to track the relationships between a large number of companies and individuals. For the purposes of this exercise, assume that the agency is interested only in the present state of these relationships, and not in how they may have changed over time. For each individual, … Read more
Products, features, and substitute products: Your firm manufactures a variety of specialized data networking equipment. Each product has a unique model number, a description, and a date introduced. For each product, you also want to the database to keep a pricing history: a set of list prices for the product, each with the date that … Read more
SQL queries with a unary relationship: Download the sample database emp‐self.accdb database from the book website. Write and run SQL code for each of the queries specified below. Make sure all your queries would still work correctly if two different employees can have the same first and last names. A. All cases in which an … Read more
Movie catalog: To make the Sickle and Evert movie guide easier to maintain, your firm is trying to create a database from which future editions of the guide will be generated. For each movie, you want to store its title, date of first release, critics’ rating (between 0 and 5 stars), motion picture rating (G, … Read more
Pet ownership and genealogy: You maintain ownership and genealogy records for the national basset hound thoroughbred dog registry, keeping information on people and dogs. Each person has an ID number, first name, middle name, last name, address, city, state, and zip code. Each dog is owned by a single person and has a name and … Read more
Alfie Lockyer decides to start up a business as a sole trader on 1 July 2020. Alfie’s Rugby League Memorabilia and Framing Services will sell a range of different memorabilia items including framed jerseys, signed footballs and signed photos of famous rugby league players both online and from a retail shop in Caloundra, Queensland. The … Read more
At the end of 2020, Ace Company had the following portfolio of investments in common stock, which it expected to hold for more than one year: 12/31/20 Security Cost Fair Value A $20,000 $25,000 B 30,000 29,000 Totals $50,000 $54,000 During 2021, the following transactions occurred: May 1 Purchased C common stock … Read more
Q1. A compulsory winding up in insolvency order was issued by the court in respect of Rock Bottom Ltd. The company had a capital of 65 000 fully paid ordinary shares of $1 each. The liquidator took possession of the company’s assets which raised $873 145 on sale. Included in the sale proceeds was $221 … Read more
As a financial analysist, you required to: 1) Obtain recent financial reports for The National Australia Bank (NAB) and any other bank operates in Australia for a minimum of 2 consecutive years. Summarize the net profit achieved for years selected and evaluate the profitability, financial liquidity and capital structure for both years (and both banks) … Read more
