Draw an ER diagram using MS Visio and upload the file in D2L. There is a shoe manufacturing company. The company has many customers. Customers have a unique customer ID and name and phone number. The company also offers many products. A product has a product ID, price and description. Customers can place orders but there are new customers who are yet to place orders. An order can be placed for one and only one product, by one and only one customer. But one product can appear in many orders. Orders have Order number, order date.

Please! can you help me doing Conceptual Analysis for this scenario. I have attached another screenshot to followup with data

Consider a model of an airport with planes, models of planes, a test of planes, and technicians. Draw an ER diagram to represent these entities and the following attributes.Planes have a unique registration number. Airplane Models are each identified by a model number (e.g. DC-80), and each has a capacity and a weight. A number of technicians work at the airport. You need to store for each the name, phone number, address, and salary. The airport has a number of tests that are used regularly to ensure that airplanes aresafe. Each test has a unique FAA number, a name, and a maximum possible score.Extend your ER diagram with relationships to represent the following information.(a) Each airplane is of one specific model.(b) Each technician is an expert on one or more plane models. His or her expertise may overlap with that of other technicians. (c) Transport Canada requires the airport to keep track of each time a given airplane is tested using a given test. For each testing event, the…

Question 1 Draw an activity Diagram in draw.io and screenshot it for me.   Scenario (please alert is in Draw.io)   Each semester the student will need to register the subjects that they need to take. The student needs to login to the system by inputting their student ID and password. The system uses that student ID to retrieve the intake of the student and based on their study plan, the system will display a list of subjects the student can register. The student can now click on the subject they wish to register. When the student is satisfied with the subjects chosen, the student will click the register button. The student may register more than 1 subject but the total credit hours for the subjects cannot exceed 20 credit hours. If it exceeds, the student has to choose all over again the subjects to register. If successfully registered, the student’s status in the system becomes “Active – Registered”. If the student does not register any subject for the semester, the status is…

Imagine that a piece of a primary key is also a potential secondary key. Can you tell me what your reaction would be?

Given the following UML diagram: Student - studentID: String + getStudentID(): String + toString(): String Person - lastName: String - firstName: String - dateOfBirth: Date - address: Address + getName(): String + getDOB(): Date + getAddress(): Address + toString(): String Professor - employeeID: String +getEmployelD(): String +toString(): String Write an implementation for the class Professor. DO NOT include or implement any constructor for this class. There are no abstract methods/classes in this example. toString method will return any simple String that contains firstName and employeelD only; no less, no more!! Assume firstName was defined as protected in class Person. You are not allowed to add implementation for any class or methods other than what is listed in the question statement.

3. Consider the following tables and then provide a pipe diagram for the requested output. ID Age ID Gender ID Name ID Friend_ID 15 3 M Bob 6. 3 31 F 6. Maria Sally George Maria 8 45 F 8 8 11 11 33 11 F 2 11 8 19 2 11 8 ... ... ... ... ... ... a. The average age of users b. The name of the user with the most friends. c. The pairs of user ID for those that follow one another (e.g., if 3 is a friend of 6 and 6 is a friend of 3 then (3, 6) would be listed as one of the pairs). d. The 10 most common names for users under the age of 20. 4. As discussed in class, what are some advantages of functional programming? 5. Explain how parallel programing can be accomplished using Streams and functional programming in Java 8. 6. What aspects of functional programming align well parallel programming?

Imagine that a piece of a primary key is also a potential secondary key. Can you tell me what your reaction would be?

You are asked to do some modelling development of a Bank accounts management system using the methods in lectures. The description of the system is as follows: This system provides the basic services to manage bank accounts at a bank called LUBank. LUBank has many branches, each of which has an address and branch number. A client opens accounts at a branch. Each account is uniquely identified by an account number; it has a balance and a credit or overdraft limit. There are many types of accounts, including: a mortgage account (which has a property as collateral), a checking account, and a credit card account (which has an expiry date and can have secondary cards attached to it). It is possible to have a joint account (e.g., for a husband and wife). Each type of account has a particular interest rate, a monthly fee, and a specific set of privileges (e.g. ability to write checks, insurance for purchases, etc.). LUBank is divided into divisions and subdivisions (such as Planning,…

Despite their importance, selection structures cannot complete the job on their own. All of us have to deal with the circumstance of having to repeat a succession of statements for various customers or transactions, or for online clients, at some point. To what extent do these jobs need certain types of frameworks? In what way are they different?