QmB3300CBE

Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 211348 211349 PROD NUM SALE_DATE PROD LABEL VEND_CODE VEND NAME AA-E3422QW QD-300932X 15-Jan-2018 15-Jan-2018 Rotary sander 211 QUANT_SOLD PROD PRICE $49.95 1 NeverFail, Inc. NeverFail, Inc. BeGood, Inc. RU-995748G 15-Jan-2018 0.25-in. drill Band saw 211 309 8 $3.45 1 $39.99 AA-E3422QW 15-Jan-2018 Rotary sander 211 Power drill 157 NeverFail, Inc. ToughGo, Inc. 2 GH-778345P 16-Jan-2018 $49.95 1 $87.75 b) Remove all partial dependencies, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created.

INVOICE VEND_ QUANT_ PROD_ INV_NUM PROD_NUM SALE_DATE PROD_LABEL VEND_NAME CODE SOLD PRICE 211347 AA-E3422QW 15-JAN-2016 Rotary sander 211 Neverfail, Inc. 1 $49.95 211347 QD-300932X 15-JAN-2016 0.25-in. drill bit 211 Neverfail, Inc. 8 $3.45 211347 RU-995748G 15-JAN-2016 Band saw 309 BeGood, Inc. 1 $39.99 211348 AA-E3422QW 15-JAN-2016 Rotary sander 211 Neverfail, Inc. $49.95 211349 GH-778345P 16-JAN-2016 Power drill 157 ToughGo, Inc. 1 $87.75

Q_5

PET ID PET NAME PET TYPE PET AGE OWNER VISIT DATE PROCEDURE 246 ROVER DOG 12 SAM COOK JAN 13/2002MAR 27/2002APR 02/2002 01 - RABIES VACCINATION10 - EXAMINE and TREAT WOUND05 - HEART WORM TEST 298 SPOT DOG 2 TERRY KIM JAN 21/2002MAR 10/2002 08 - TETANUS VACCINATION05 - HEART WORM TEST 341 MORRIS CAT 4 SAM COOK JAN 23/2001JAN 13/2002 01 - RABIES VACCINATION01 - RABIES VACCINATION 519 TWEEDY BIRD 2 TERRY KIM APR 30/2002APR 30/2002 20 - ANNUALCHECK UP12 - EYE WASH The functional dependencies that I note are as follows: Pet ID --> Pet Name, Pet Type, Pet Age, Owner Pet ID, Visit Date --> {Visit Procedure} (the set of visit procedures), note the use of procedure codes that repeat, but are listed in their own column So, Is there are other functional dependencies? If so, what are they? If not, why not? Do you believe it would help to create additional attributes during normalization? If so, what are they? If not, justify why it's not needed. Please help me understand this.

Sample invoice is given as follows: International Conference on Mathenatical Sciences and Technology (MathTech) Invoice Date Invoice No Name : 20 January 2022 : 0001 : Muhammad Irfan Ali : Presenter Category Accommodation (Y/N) : Y Conference Fee Acconnodation Fee Total Amount Due (RM) : 1290.00 : 990.00 : 300.00 Terms & Conditions Payment is due within 30 days. Please make payment via online banking to Maths USM (RHB: 1234554321) You are encouraged to add on extra features to your program. Proceed to Part 2 only if you have completed Part 1. Part 2: Create Invoice via File Processing a. Modify the program in Part 1 to read in the file provided, File.txt. b. Use array structure in your program. c. Print all 5 receipts continuously to Dutput.txt. amusm.my Sie samms Malaysia

COVID-19 TRACKER One Of Your Uncle Who's Working Under Department Of Health Learned That You've Taking Up Programming Class. That's Why You've Been Asked If It Would Be Possible For You To Replicate Their Current COVID Tracker. This Is His Small Step To Check Whether You Can Help Him On Creating An Automated Data Analytics. Develop A Program That WillCOVID-19 TRACKER One of your uncle who's working under Department of Health learned that you've taking up programming class. That's why you've been asked if it would be possible for you to replicate their current COVID tracker. This is his small step to check whether you can help him on creating an automated data analytics. Develop a program that will replicate the COVID19 Tracker by DOH You are provided with the official August 4 Data from DOH in csv format (csv is discussed on the next subsection) On the said spreadsheet, Your program should be able to do the ff analytics: Total Number of Cases: (a) Confirmed, (b) Active, (c) Recovered,…

Please help me adjust the X-axis on my graphs in Excel spreadsheet. Range numbers are from 200 to 500 but is graphed 0 to 300.  Link: Kahun Data Day 3.xlsx   Thank you!

Submission guidelines: The assignment must be submitted by the deadline (earlier submissions are encouraged) in PDF format through Blackboard using the following file name format: LastName_FirstName_Assignment_1.pdf. The assignment must be typewritten. All the assignments in this course are individual work; any overlap between assignment reports will be penalized. A bank requires for their customers to access their online banking accounts to provide as User Id (or user name) the last 8 digits of their bank card number, and a password with a length between 8 and 12 ASCII characters, including the following restrictions (posted on their website): Passwords must have at least 8 characters long and at most 12 characters long, and must include at least one character from each of the following four character types: Upper case letters ABC DEF Lower case letters ghijkl Numbers 1 2 345 67890 Special characters ! @ # $ % ^ & * (+) = - The remaining characters of the password must be selected…

INVOICES INVOICE LINE INVOICE NUM INVOICE DATE CUST ID 11/15/2021 INVOICE NUM ITEM ID QUANTITY 14216 QUOTED PRICE 14216 125 CA75 $37.99 14219 11/15/2021 227 14219 AD72 $79.99 14222 11/16/2021 294 14219 DT12 4. $39.99 14224 11/16/2021 182 14222 LD14 $47.99 14228 11/18/2021 435 14224 KH81 4. $18.99 14231 14233 14237 11/18/2021 11/18/2021 125 14228 FS42 $124.99 435 14228 PF19 1. $74.99 11/19/2021 616 14231 UF39 2. S189.99 14233 KH81 $19.99 QB92 WB49 LP73 14233 $109.95 14233 $74.95 14237 $54.95 ТЕМ ITEM ID DESCRIPTION ON HAND CATEGORY LOCATION PRICE Dog Feeding Station Fenthers Bird Cage (12x24x18) AD72 12 DOG B. $79.99 10 BRD B $79.99 CA75 Enclosed Cat Litter Station 15 CAT $39.99 Dog Toy Gift Set Fly Mask with FRars Folding Saddle Stand Aquarium (55 Gallon) DT12 27 DOG B $39.99 FM23 41 HOR $24.95 FS39 12 HOR $39.99 FS42 FSH A. $124.99 KHS1 LD14 Wild Bird Food (25 Ib) 24 BRD $19.99 Locking Small Dog Door 14 DOG $49.99 LP73 Lange Pot Carrier 23 DOG $59.99 Pump & Filter Kit Quilted Stable…

Font Paragraph Styles Editing Dictate Editor Reuse aste Files Styles Voice Sensitivity Editor Reuse Files oboard You have just been hired as a consultant for a big Health Care provider. Impressed by your background in databases, they want you to completely redesign their database system. Talking with the people at the HC provider, you get the following information (be very careful on some of these attributes, and apply everything you have learned to this point: - The database contains information about patients, hospitals and doctors. - Each patient has an ID, first name, last name, address and age. A patient is uniquely identified by his or her ID. - Each hospital has an id, name and budget. The id uniquely identifies a hospital. - Each doctor an id, a full name, email address and a favorite movie. The id uniquely identifies a doctor. - Each patient can be treated at many hospitals, a hospital can treat many patients. Each doctor can work at only one hospital. A hospital can have many…

Design databases only contain data about the spatial data of the design.  True  False

Spatial Data Analysis: Create a choropleth map showing the unemployment rate within a selected country. Design an appropriate legend for the map.

Q3: Draw DFD Level 1 and 2 for ATM machine. Note Hand drawing not allowed

EXPERIMENTAL PROCEDURE   Patients visit the hospital and their visit history is maintained by the hospital staff. Different physicians may be available on different dates. They diagnose and treat the patients of all categories. Some of treatments are free while others are to be paid by the patients. Sample data of the case is shown in the following chart.   Patient History Report PatientID Name Address Visit Date Physician Diagnosis Treatment P-100809 A City: X 12-02-2007 20-02-2007 29-02-2007 15-03-2007 Dr. Z Dr. F Dr. R Dr. L Chest Infection Cold Hepatitis-A Eyes Infection Free Free Paid Paid P-200145 N City: Y 10-01-2007 15-02-2007 25-03-2007 Dr. L Dr. K Dr. A Bone Fracture Cough Flu Paid Free Free     Task 1                     Draw a dependency diagram and transform the above data to first normal form by eliminating repeating groups such that each row in the relation is atomic. Be sure to create an appropriate name for the…

SQL QUESTIONS

Programming language: SQL Tool: Oracle SQL Developer   The database schema Employee (Lastname, FirstName, MidInitial, gender, street, city) Works (Lastname, FirstName, MidInitial, company-name, salary) company (company-name, city) company (company-name, city) Manages(Lastname, FirstName, MidInitial, ManagerLastname, MFirstName, MMidInitial, start-date)   Manages(Lastname, FirstName, MidInitial, ManagerLastname, MFirstName, MMidInitial, start-date) employee_table (you should define three attributes for employee and manager names) Name                           street          city           gender -------------------------------------------------------- Anderson, Susan L     108th        Omaha       F Brady, Dan L               P street     Lincoln       M Chen, Peter K             124th         Omaha       M Clemson, Ann M        O              Lincoln      F Dale, Mary K               132th        Omaha       F Gill, Mary L                P street      Lincoln       F Harrison, Susan…

city store sid $1001 S1002 S1003 store table True False sid n city Union Edison Newark price sell m sid 51001 51001 S1003 sell table pid product The values in the above 3 tables do NOT violate the E-R diagram. name name price Ipad 300 Iphone 550 Iphone 250 pid 1234 3456 3456 product table name Ipad Iphone Iwatch

GRADE REPORT STUDENT Name Student number Class Student number Section identifier Grade Major CS Smith 17 17 112 Brown 2 CS 17 119 85 92 COURSE 102 Course number Credit hours Department CS1310 Course name 135 Intro to Computer Science Data Structures Discrete Mathematice Database CS CS3320 4 CS MATH2410 MATH PREREQUISITE CS3380 CS Course number Prerequisite number CS3320 CS3380 CS3380 MATH2410 SECTION Section identifier Course number Semester Year Inatructor CS3320 CS1310 MATH2410 Fal King Anderson 85 07 02 CS1310 Fall 07 102 CS3320 Spring 08 Knuth 112 MATH2410 Fall 08 Chang 119 CS1310 Fal 08 Anderson 135 CS3380 Fall 08 Stone 4. Show the result of the following queries as it would apply to the database state given above. 1. SELECT DISTINCT Name FROM STUDENT WHERE Major="cs; 2. SELECT GRADE REPORT.Student number, SUM(Credit_hours), COUNT(") FROM GRADE_REPORT, SECTION,COURSE WHERE GRADE REPORT.Section_identifier= SECTION.Section_identifier AND SECTION.Course_number=COURSE.Course_number…

Database Management Jill Bill Marketplace is a business located in Florida. Within the JBM compound, you can purchase many types of products that are related to a specific category, for example, books or antiques. JBN does not own any of the stalls that sell products, rather they rent them out to small vendors. Each vendor has to pay a monthly fee to use the Marketplace. JBM products are available to different customers who sell their products daily. Each category type (e.g. books ) is managed by a particular supervisor. A customer will order their selected product in terms of the amount from that vendor, who is also free to apply discounts on any product in his store. Other than category supervisors there are other staff that manages different departments in the mall, but they all report to two marketplace managers. The small vendors will report to the category managers on the nature of their stock and if and when restocking is required. All category managers report to the third…