A warehouse is where the company stores its products and the storage bins in the warehouse are specified identified to their aisle, location in the aisle, and its shelf. There are a total of 40 aisles, 64 horizontal locations in each aisle, and 6 shelves. What is the least number of products the company can have so that at least two products must be stored in the same bin?

The worksheet shown in the figure below contains two years of sales that will be used to create a PivotChart. The goal is to create a column chart that shows the total sales dollars by year for each month. Given this goal, what would be the best chart area to place the Year field? 1 2 3 4 3 6 7 . 9 10 11 12 13 14 15 Year Month 2017 April 2018 April 2017 August 2018 August 2017 December 2018 December 2017 February 2018 February 2017 January 2018 January 2017 July 2018 July 2017 June 2018 June VALUES O LEGEND AXIS FILTERS Total Sales Dollars $ 50,970.00 $ 48,400.00 $ 52,470.00 $ 50,700.00 $112,425.00 $120,000.00 $ 56,205.00 $ 56,850.00 $ 59,940,00 $ 62,950.00 $19.980.00 $ 18,500.00 $ 22.485.00 $ 21,000.00

A Company operates many factories. Each factory is located in a region. Each region can be “home” to many of the factories. Each factory employs many employees, but each of those employees is employed by only one factory.”

A bank requires a database designed to keep track of its customers accounts. Each customer may have a number of accounts. Each of these accounts may be in the name of one or more customers. Each account is located in a particular branch of a bank. In addition, each customer may have zero or more loans with the bank. Each loan must be with one or more customers. Each loan is also located in a particular branch. The database must record the following information: The name of the bank, its address and its main telephone number The address and the sort code for each branch The name of each customer, the customers address and the customers telephone number For each bank account: the account number, its balance and the type of the account For each loan: the loan account number, the outstanding balance and the interest rate The database must also record the various relations between the different entities in the database   Draw an entity relationship diagram for the database. In your diagram,…

When is it appropriate to use a graph database for storing and querying data?

Draw the EER diagrams for the following problems using UML notation, Crow’s Foot notation and Chen notation: A large organization has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors. Each parking lot has parking spaces, which are uniquely identified using a space number.  Members of staff can request the use of a parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle registration number. The majority parking spaces are under cover and can be allocated for use by a member of staff for a monthly rate.  Parking spaces that are not under cover are free to use when available. Up to twenty covered parking spaces are available for use by visitors to the company. However, only members of staff are able to book out a space for the day of the visit. There is no charge for this type of booking, but the member of staff must provide the visitor’s vehicle license number.

Let R₁ and R₂ be the relations on X={a,b,c}, R₁={ (b,a), (c,b), (a,c) } R₂={ (a,c), (b,c)} R₁-¹= R₂ ° R₁=

Data description language is a notation that is used to describe the structure and organization of data. This language is also used to specify how the data is to be kept and retrieved.

A university offers a number of courses and each semester, it offers zero or more sections of every course. The relationship between entity sets course and the sections offered by the course in a given semester is Question 3 options:             a) One-to-many from course to section     b) Many-to-one from course to section     c) One-to-one from course to section     d) Many-to-many from course to section

Question#05 b part Please provide detailed solution with explanation and justification asap to get a upvote for B part