Create an ERD of the given scenarios and ANSWER the questions. The loan office in a bank receives from various party’s requests to investigate the credit status of a customer. Each credit request is identified by a Request ID and is described by a Request Date and Requesting Party Name. The loan office also received results of credit checks. A credit check is identified by a Credit Check ID and is described by the Credit Check Date and the Credit Rating. The loan office matches credit requests with credit check results. A credit request may be recorded before its result arrives; a particular credit result may be used in support of several credit requests. Draw an ERD for this situation. Now, assume that credit results may not be reused for multiple credit requests. Redraw the ERD for this new situation using two entity types, and then redraw it again using one entity type. Which of these two versions do you prefer, and why?

Create an ERD of the given scenarios and ANSWER the questions. The loan office in a bank receives from various party’s requests to investigate the credit status of a customer. Each credit request is identified by a Request ID and is described by a Request Date and Requesting Party Name. The loan office also received results of credit checks. A credit check is identified by a Credit Check ID and is described by the Credit Check Date and the Credit Rating. The loan office matches credit requests with credit check results. A credit request may be recorded before its result arrives; a particular credit result may be used in support of several credit requests. Draw an ERD for this situation. Now, assume that credit results may not be reused for multiple credit requests. Redraw the ERD for this new situation using two entity types, and then redraw it again using one entity type. Which of these two versions do you prefer, and why?

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts

Section: Chapter Questions

Problem 3.11CP

See similar textbooks

Similar questions

A college course may have one or more scheduled sections or may not have a scheduled section. Attributes of COURSE include Course ID, Course Name, and Units. Attributes of SECTION include Section Number and Semester ID. Semester ID is composed of two parts: Semester and Year. Section Number is an integer (such as 1 or 2) that distinguishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION?
Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher publishes one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or more authors; an author writes one or more books, potentially for different publishers. Each author is uniquely described by an author ID, and we know each author’s name and address. Each author is paid a certain royalty rate on each book he or she authors, which potentially varies for each book and for each author. An author receives a separate royalty check for each book he or she writes. Each check is identified by its check number, and we also keep track of the date and amount of each check. As you develop the ERD for this problem, follow good data naming guidelines.
Look up the average evaluation score earned by instructor Egan for the Emergency Care course: In cell E14, begin to enter a formula using the XLOOKUP Use the instructor name in cell E12 as the value to look up. Use a structured reference to the header row of the Evaluations table as the table to search. Return the value in the range E4:I4. I need help with the sttructured reference refered in #3
A parameter comes from where while a statistic comes from where?
Draw Use case diagram for customer order for retailer shop. The order payment can be done be cash, credit, or cheque. The order contains order details with its associated items. The rejected or damaged goods are returned.
Create an ER model for a restaurant. The specifications are as follows: The customer has an id, name, address and telephone number. The customer can reserve a table before arrival. Each reservation has a unique key and includes the date and time of reservation and the number of seats. Upon arrival, the customer places an order. Each order has a unique order number and includes one or more food items. Each food item is distinguished by an id and has name and price. We also keep track of the cashier who settle the payment with the customer before he leaves the restaurant. The cashier has an id and name.
Each department runs a number of courses. The university provides a set of modules used in different courses. Each course uses a number of modules but not every module is used. A course is assigned a unique course code and a module is identified by a unique module code. A module can be used in one course only, but can be studied by many students. In addition to the module code each module unique title, start date, end date, texts (books), and assessment scheme (i.e., coursework and exam marks percentages) are also stored. Each course is managed by a member of academic staff, and each module is coordinated by a member of academic staff also. The database should also store each course unique title, and duration (in years). A student can enroll in one course at a time. Once enrolled a student is assigned a unique matriculation number. To complete a course, each student must undertake and pass all the required modules in his/her course. This requires that the database store the…
Draw a level 2 data flow diagram (DFD) for the case described below. Blood Bank Testing Unit System The Blood Bank Testing Unit. This is one unit within the College Street Red Cross Blood Donor Centre. On the day following a blood donation, the Blood Bank unit tests all blood for blood type and potential viral agents. They send the results of these tests to the Processing Office (another unit of the Centre). For each tested blood unit, they fill out a form which lists the blood unit number, the blood type, the date and the results of the test. If the tests indicate that the blood may be contaminated with a viral agent, the blood unit is destroyed. This is indicated on the test form. Blood units have a limited shelf life. The Blood Bank receives a list every day of those units which have exceeded their shelf life. These are discarded and the list sent back to the Processing Office with a signed indication of the disposal of the units. The Blood Bank also…
Design the database in an MS Excel spreadsheet as a single relation called Movie. It should contain an ID, Title, Year Released, Genre (e.g., sci-fi, comedy, thriller, etc.), Rating (e.g., G, PG, R, etc.), Format (e.g., VHS, DVD, MP3, etc.), a free-form Comments field, plus the main cast and crew members. Add the following entry plus at least two of your own: Title: Star Trek Year: 2009 Genre: Sci-Fi Rating: PG Format: DVD Director: J. J. Abrams Starring: Chris Pine (Capt. Kirk), Zachary Quinto (Mr. Spock) Zoe Saldana (Uhura), Karl Urban (Bones McCoy) What normal form is this design? Why? What should be done to correct the design?
Purposes for the validation set and solve it through what problem.
Study the following. A customer can place one or more orders, but an order belongs to only one customer. A customer is described by its name, delivery address, and contact number. While an order is described by order number, order status, and order date. Only one payment is made for an order. An order can be paid for through one of two options. A payment is either cash or debit. A payment has an amount attribute. Cash payment is described by cash tendered, while debit payment is described by number, type, and expiry date 6.1 Use the scenario to draw a UML class diagram.
Question 3 Draw a detailed activity Diagram in draw.io and screenshot it for me. ( **Please take note is a detailed activity diagram) Scenario The exam unit uses the system after the subject registration period has closed. The system will display a list of subjects that have registered students. Using this list, the exam unit will plan out examination week. Examination week lasts 6 days, from Monday to Saturday. For each day, the exam unit will assign a subject to that day. Each day can have a total of 6 examination hours with subjects having 2- hour or 3-hour examinations. For example, if the subjects are 2-hour examinations, then 3 of them can be scheduled for the day and if the subjects are 3-hour examinations, then only 2 of them can be scheduled for the day. There can also be a mixture of 2-hour and 3-hour examinations. If the exam unit schedules too many examination hours for that day then the day resets and the exam unit needs to reschedule again. This process stops when…