The figure below shows the DFD model for a customer purchasing an electronic article from an online repository as received from a stakeholder. The articleID is a string that uniquely identifies an article. The payment amount and customer name are the data details that are included on the receipt that is emailed to the customer. The payment completer status is a flag that indicates if the payment has been received in full. Your task as the business analyst is to identify and comment on the issues (if any) within the DFD. Be sure to state any necessary assumptions. Receipt data Customer Searches catalog for articleID "Article" Accept Payment 0 00 Payment amount Customer Name Generate Receipt. Payment complete status Send Customer Atricle Database Thank You message Article Payment complete status Email Article to Customer

The figure below shows the DFD model for a customer purchasing an electronic article from an online repository as received from a stakeholder. The articleID is a string that uniquely identifies an article. The payment amount and customer name are the data details that are included on the receipt that is emailed to the customer. The payment completer status is a flag that indicates if the payment has been received in full. Your task as the business analyst is to identify and comment on the issues (if any) within the DFD. Be sure to state any necessary assumptions. Receipt data Customer Searches catalog for articleID "Article" Accept Payment 0 00 Payment amount Customer Name Generate Receipt. Payment complete status Send Customer Atricle Database Thank You message Article Payment complete status Email Article to Customer

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Task 6: The StayWell marketing team wants to send mail to all residents. You need to return the first name and surname of all the residents combined as NAME, with their addresses named ADDRESS. However, the address should be retrieved from the PROPERTY table for residents. Task Retrieve the mailing address (first name, surname, and address) for each resident. Task 7: The development team wants to add new residents and new service requests to StayWell without checking the latest IDs and manually incrementing it. Therefore, you need to alter the RESIDENTS table and change the RESIDENT_ID field to an auto-incremented field of type SMALLINT. Alter the RESIDENTS table and change the ID field to an auto-incremented field. Task 8: The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table. Task Add Yigit…
A social recreation club has a system to keep track of club members, committees and activities. Each club has a registration number and a title. Several members form committee. Members are male and females. Each committee has a name, a unique number and a date, which the committee has formed. The system stores the members' unique identification number, name, address, gender, birth date and club joining date. The club forms committees for different activities. A committee controls and organizes a number of activities, each of which has a unique name, a unique number and description of the event. An event has event ID and description of the event. An activity may consist of several events. Committee publishes many online advertisements about the activities. Advertisement details are ID and a title. Draw the ER diagram to represent the above scenario
Using the following entity information, the primary key of the student who lives in Eastpoint, FL is, O Start Page A MOTerm Exam L Relaional, 1 Untited 1 CIS25SOISTUDENT VARCHARZ S EYTED VARCHARZ 130 BYTE VARDAA2 (3 BYTD SLAST SIRST SMI SADORESS S CITY SSTATE CB2550LFACULTY NUMEER I VARCHARZ 0 YTE VARCHARZ GO BYTE CHARYT CHAR LEYTE VARDARZ 125 YTD VARCHARZ 20 BYTE FAST EARST MI FPHONE VARCHARZ 10 BYTE RANK FUPER CHAR 2YTE VARCHARZ 0 YTD VARCHAR2 (10 BYTE CHAR 2 BYTE DATE NUMSER 4 NUMBER INTERVAL YEAR TO MONTH VARCHARZ OBYT NUMBER NUMBER FACULTYFJD JD SPHONE SCLASS 5.006 SUPN FACULTYFJDFK FJD TIME DROLLID STUDENTSID RD STUDENT F ID K F D STUDENT SID PK 6JD Seriat Outut Query Result SOL I AlI Ros Fetched: 5in 0.74 seconds rDrLASTLIRST M HONE LRANK rSUPERFMIN 1 Marx 2 Zhulin Mark 3 Lang ley ColinA 4 Broun JonnelD 5 Sealy Janes L Teresa 4075921695 Associate 6338 4073875682 Full (null) 1121 4075928719 Assistant 9871 4 4078101155 Full (null) 8297 4079817153 Associate 1 Script Output Query…
An Art Museum needs to keep track of its artwork and exhibitions. The museum has a collection of artwork. Each piece of art has a unique id [ArtID], an artist, year and title. Artwork is categorized by type. There are two types, paintings and sculptures. Paintings have a paintType and style. Sculptures have a material, height and weight. Artwork is frequently shown in exhibitions. Each exhibition has a unique name, startDate, endDate. A listing of the artwork displayed at an exhibition is also retained. Below is an E-R diagram for a database to help the Art Museum. Provide appropriate names for entities E1, E2, E3, E4 identifiers 11, 12, 13, 14 missing attributes and relationship cardinality RC1 and relationship type RT1. Start_date End_date E1 E1 11 RC1 PaintType Style E3 13 A1 Title Year A/ A A/ A/ A/ A/ A/ A/ A A/ A/ E2 12 A/ E2 E3 E4 11 12 13 14 A1 A2 RC1 RT1 RT1 A2 Height Weight E4 14 Activate Go to Settin
Look up student MAJOR and ROOM information based on the student NAME. Enter formula into B2. 1 NAME MAJOR ROOM 2 58 3 4 NAME MAJOR ROOM 5 $1 CIS DBH 6 S2 7 3 A/F DBH A/F DBH 8 $4 мом SCI 9 S5 мом DBH 10 56 CIS SCI 11 S7 CIS DBH 12 S8 A/F 13 S9 мом 14 S10 CIS Size Color Price Item T. 15 Size L T M 16 Color R. 17 Price 28 H. 29 30 XL R. 18
Question 8 The ERD below is the initial design to track events and the dates on which they are scheduled. Using the ERD, what can you determine about the statement "There were 5 events on July 4, 2012." EVENT DATE Has Scheduled on O This statement could NOT be true based on the ERD. O This statement could be true based on the ERD.
THIS IS A UML QUESTION Use case 5: Equipment Scrapping Equipment scrapping refers to the scrapping of equipment that cannot meet the use requirements and meet the scrapping conditions. 1. The owner fills in the scrap application form. 2. The equipment administrator confirms the scrap application form. 3. The equipment department review the scrap application form. 3.1 If the equipment department disapprove of the application, they send the message to tell the applicant the reason. The use case terminates. 4. If the price of equipment exceeds ￥50,000 4.1 If the school leader disapprove of the scrap application, the applicant will be informed the reason and the use case terminates. 5. The equipment department recycles the equipment and eliminate the accounts related to the equipment.
File Home Insert Draw Page Layout Formulas Data Review View Help A Share P Comments 14 fe A E G H J K L M Q R 1 Semeste Course NumbelCoure NameCredit Hours Letter Grad Grade Points Directions Create a spreadsheet that correctly calculates your GPA - must use formulas for GPA = full credit. You need to inlcude grades for two semesters. If you do not already have two semesters worth of grades assume this semesters grades and one future semester worth of grades. 2 3 4 To calculate GPA dividing the total amount 5 of grade points earned by the total amount of credit hours attempted. Your grade point 6 7 8 average may range from 0.0 to a 4.0. 9 Grade Points - multiply credit hours of course by the number associated with the 3 letter grade you earned. • A = 4 B = 3 C = 2 5 -7 D = 1 F = 0 1 Wine Sales Cinderella's Grades Your GPA + + 95%
To specify the value to be assigned to an attribute with domain DATE, you should give: a string in 'mm/dd/yy' format the keyword DATE followed by a string in 'yyyy-mm-dd' format a tuple containing numerical values for day, month, and year
Create 3 separate detailed flowcharts for a burger restaurant. 1st flowchart: Ordering process based on pre- selected burgers: Choose which burger the customer wants to order based on the available options. Burgers may be named however you'd want. 2. Create-your-own burger: Customer will be prompted to choose what meat, toppings, sauces, and bun they would like to create their own burger. Choose whatever price you like 3. Receipt printing process: Print a receipt with order details, including total, price of menu items purchased, company name, address, contact, date, etc. Add 6% tax at the end and display total.
Complete questions 2-7 Note: Complete questions 2-7 in part B of the Garden Glory Project on p.129 and 130 of the textbook (8th edition). There may be more than one service performed at a property on a given date. Use this information when you answer questions. Comment on each question whether a given design is good and provide reasons for that. For example, the answer for Q1 is “This design is not appropriate because the designated Primary Key (PK) (PropertyName) in the table cannot determine some other attributes of the same table (e.g., ServiceDate, Description, Amount); in other words, the designated PK is not unique”. Your answers need to be specific and should clearly pinpoint the design problem with references to the relevant attributes in the table and the reason of violation. Any vague answer like “This design is bad because the PK is not good”, are wrong. Note that the foreign keys are italicized instead of dashed underlined. Clearly label answers for each question.…
Calculate a bonus depending on job id using a case expression. Display the employee id, last name, job id, department id, salary, and the bonus amount • If job id is AD_VP, the bonus amount will be Salary * .1555 • If job id is IT_PROG, the bonus amount will be Salary * .1050 • For all other job roles, the bonus amount will be 50.00 dollars. Name the column bonus amount and round the values to a whole number (0 decimal places).