2-2 Instructions & Directions - Project 2 (Ampersand, Inc
.pdf
keyboard_arrow_up
School
Tarrant County College, Fort Worth *
*We aren’t endorsed by this school
Course
1329
Subject
Computer Science
Date
May 10, 2024
Type
Pages
4
Uploaded by vhousen1 on coursehero.com
Address SSN Federal State Marital W/H Allow. | W/H Allow. | Status Maggie Hough 13 Spruce Street 222-22-2222 1 1 Single Somerset, VT 05363 William Finnegan 7 Smith Boulevard 999-99-9999 | 2 2 Married Somerset, VT 05363 Stacey Jones 8110 Browning Place 555-55-5555 | 2 1 Single Somerset, VT 05363 Francine Stewart 101 Park Court 888-88-8888 | N/A N/A Married Somerset, VT 05363 November 24. All employees of Ampersand, Inc., work a regular 40-hour workweek (thus all hours worked over 40 in a given week are overtime hours), receive overtime pay at a rate of 1.5 times the regular wage rate, and are paid weekly on Saturday for the most recent week (which runs from Sunday through Saturday, but employees never work Three-Month Project: Ampersand, Inc. 227
Earnings and voluntary deduction information for each of the four employees is as follows: ~ EARNINGS AND VOLUNTARY DEDUCTIONS Name Regular Wage Annual Salary Weekly 401(k) Weekly Charitable Rate Deduction Cont. Maggie Hough $14/hour N/A 5% of gross pay | $10 William Finnegan $18/hour N/A 4% of gross pay | $5 Stacey Jones N/A $262,000.44 N/A $15 Francine Stewart N/A $94,000.40 2% of gross pay | N/A The first three quarters of the year have passed, and all payroll-related activity has been properly accounted for as of 9/30/2023. Quarterly payroll data for each of the four employees is as follows: RN e R e St e VA G G U E S O U G I e e e e S e Period Gross Federal State Social Medicare | 401(k) Charitable Earnings Income Tax | Income Tax | Security Tax | Tax Deduction | Cont. Q1 $7,280 $494 $345.80 | $451.36 $105.56 | $364 | $130 Q2 $7,280 $494 $345.80 $451.36 $105.56 | $364 $130 Q3 $7,280 $494 $345.80 $451;36 $105.56 | $364 $130 R N R e e S AT IR AN IR E NN E GAIN s - P TS S e - e Period Gross Federal State Social Medicare | 401(k) Charitable Earnings Income Tax | Income Tax | Security Tax | Tax Deduction | Cont. Q1 $9,360 $312 $449.28 $580.32 $135.72 | $374.40 $65 Q2 $9,360 $312 $449.28 $580.32 $135.72 | $374.40 $65 Q3 [ 39,360 $312 $449.28 $580.32 $135.72 | $374.40 | $65 7 ERE TR e, e S e S ASTTACEY] JONES‘W’ Period Gross Federal State Social Medicare | 401(k) Chaitable Earnings income Tax | Income Tax | Security Tax | Tax Deduction | Cont. Q1 $65,500.11 | $14,683.76 | $3,274.96 $4,061.07 $949.78 | $0 $195 Q2 $65,500.11 | $14,683.76 | $3,274.96 $4,061.07 $949.78 | $0 $195 Q3 $65,500.11 | $14,683.76 | $3,274.96 | $1,810.26 $949.78 $0 $195 R e e T e e L Period Gross Federal State Social Medicare | 401(k) Charitable Earnings Income Tax | Income Tax | Security Tax | Tax Deduction | Cont. Q1 $0 $0 $0 $0 $0 $0 $0 Q2 $0 $0 $0 $0 $0 $0 $0 Q3 $1,807.70 | $140 $88.58 $112.08 $26.21 $36.15 $0 228 Payroll Accounting Chapter 7: Year-End Projects
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Required information
id fname lname company address city ST zip
103
Art
Venere
8 W Cerritos Ave #54
Bridgeport
NJ
8014
104
Lenna
Paprocki
Feltz Printing
639 Main St
Anchorage
AK
99501
arrow_forward
Given the Employee, Class, and Training tables.
Employee
Emp_id (PK)
EM8765
Address
USA
Name
Phone
Email
Ali
ali@yahoo.com
nazire@gmail.com
katrina@gmail.com
lemi@hotmail.com
alican@yahoo.com
mustafa@hotmail.com
hasan@gmail.com
98733211
ЕМ3456
Nazire
Dubai
98764533
90857464
EM7658
Katrina
USA
EM1987
Lemi
USA
99663425
EM8009
Alican
UK
95583372
|EM7698
Mustafa
Dubai
Jordan
92234452
EM6666
Hasan
92123366
Class
Class_id (PK)
Class_name
Multimedia
Credit
СOM106
COM206
Database
сомз06
Public Speaking
9.
Training Table
Emp_id (FK)
EM8765
Date
Class_id (FK)
Result
05-May-2010
08-May-2011
08-Feb-2010
08-Feb-2010
соM106
Pass
EM3456
COM206
Pass
EM7658
сомз06
Fail
EM1987
сомзо6
Fail
28-Jan-2011
10-March-2012
EM8009
сомз06
Pass
EM7698
сом106
Fail
EM8765
08-May-2011
сOM206
Pass
Write the appropriate SQL queries
a) Get the address of employee whose name is Alican
b) Get the name and email of employees located in Dubai. Sort the results in
alphabetical order of name.
c) Show the count of employees…
arrow_forward
Part 1:
CUSTOMER
CUST_NUM
CUST_LNAME
CUST_FNAME
CUST_BALANCE
1000
Billy
Jean
1050.11
1001
Amanda
John
840.92
INVOICE
INV DATE
23/3/2020
INV_NUM
CUST_NUM
INV_AMOUNT
8000
1000
235.89
8001
1001
23/3/2020
312.82
8002
1002
30/3/2020
528.10
8003
1003
12/4/2020
194.78
8004
1004
23/4/2020
619.44
1. Create both the CUSTOMER and INVOICE tables structure above. Details of both tables are:
a) The customer number should store integer values. The name attributes should support variable
length character data up to 30 characters each. The customer balance should support up to six digits on
the left of the decimal place and two digits to the right of the decimal place.
b) The invoice number should store integer values. The invoice date should store date values. The
invoice amount should support up to 8 digits to the left of the decimal place and two digits to the right
of the decimal place.
2. Write the SQL commands necessary to insert the data into the CUSTOMER table and the INVOICE
table created in…
arrow_forward
Note:- its @ CSE sub don't reject
arrow_forward
CUSTOMERColumns = 7, Rows = 10
CustomerID
LastName
FirstName
Address
ZIP
Phone
Email
1
Shire
Robert
6225 Evanston Ave N
98103
206-524-2433
Robert.Shire@somewhere.com
2
Goodyear
Katherine
7335 11th Ave NE
98105
206-524-3544
Katherine.Goodyear@somewhere.com
3
Bancroft
Chris
12605 NE 6th Street
98005
425-635-9788
Chris.Bancroft@somewhere.com
4
Griffith
John
335 Aloha Street
98109
206-524-4655
John.Griffith@somewhere.com
5
Tierney
Doris
14510 NE 4th Street
98005
425-635-8677
Doris.Tierney@somewhere.com
6
Anderson
Donna
1410 Hillcrest Parkway
98273
360-538-7566
Donna.Anderson@elsewhere.com
7
Svane
Jack
3211 42nd Street
98115
206-524-5766
Jack.Svane@somewhere.com
8
Walsh
Denesha
6712 24th Avenue NE
98053
425-635-7566
Denesha.Walsh@somewhere.com
9
Enquist
Craig
534 15th Street
98225
360-538-6455
Craig.Enquist@elsewhere.com
10
Anderson
Rose
6823 17th Ave NE
98105
206-524-6877
Rose.Anderson@elsewhere.com
EMPLOYEEColumns = 5, Rows = 5
EmployeeID
LastName
FirstName…
arrow_forward
CUSTOMERColumns = 7, Rows = 10
CustomerID
LastName
FirstName
Address
ZIP
Phone
Email
1
Shire
Robert
6225 Evanston Ave N
98103
206-524-2433
Robert.Shire@somewhere.com
2
Goodyear
Katherine
7335 11th Ave NE
98105
206-524-3544
Katherine.Goodyear@somewhere.com
3
Bancroft
Chris
12605 NE 6th Street
98005
425-635-9788
Chris.Bancroft@somewhere.com
4
Griffith
John
335 Aloha Street
98109
206-524-4655
John.Griffith@somewhere.com
5
Tierney
Doris
14510 NE 4th Street
98005
425-635-8677
Doris.Tierney@somewhere.com
6
Anderson
Donna
1410 Hillcrest Parkway
98273
360-538-7566
Donna.Anderson@elsewhere.com
7
Svane
Jack
3211 42nd Street
98115
206-524-5766
Jack.Svane@somewhere.com
8
Walsh
Denesha
6712 24th Avenue NE
98053
425-635-7566
Denesha.Walsh@somewhere.com
9
Enquist
Craig
534 15th Street
98225
360-538-6455
Craig.Enquist@elsewhere.com
10
Anderson
Rose
6823 17th Ave NE
98105
206-524-6877
Rose.Anderson@elsewhere.com
EMPLOYEEColumns = 5, Rows = 5
EmployeeID
LastName
FirstName…
arrow_forward
Normalize the following table to the 3rd Normal form:
Student
Student Phone
Course
Term
Grade
Instructor
Instructor Phone
Lauren Fernell
555-7771
MIS 350
F12
A
Hess
555-2222
Lauren Fernell
555-7771
MIS 372
F12
B
Sarker
555-2224
Lauren Fernell
555-7771
MIS 426
F12
A
Fuller
555-2227
Lauren Fernell
555-7771
MIS 375
F12
B+
Wells
555-2228
Brigit Schnieder
555-2215
MIS 350
F12
A
Hess
555-2222
Brigit Schnieder
555-2215
MIS 375
F12
B+
Wells
555-2228
Brigit Schnieder
555-2215
MIS 372
F12
A
Sarker
555-2224
Brigit Schnieder
555-2215
MIS 374
F12
B
Clay
555-2221
Jackie Judson
555-1245
MIS 350
F12
A
Hess
555-2222
Jackie Judson
555-1245
MIS 372
F12
B+
Sarker
555-2224
How many tables did you create after normalizing the table?
List each of…
arrow_forward
TABLE 4-6 Parking Tickets at Millennium College
Parking Ticket Table
St ID
L Name
F Name
Phone No
St Lic
Lic No
Ticket #
Date
Code
Fine
38249
Brown
Thomas
111-7804
FL
BRY 123
15634
10/17/12
2
$25
16017
11/13/12
1
$15
82453
Green
Sally
391-1689
AL
TRE 141
14987
10/05/12
$100
16293
11/18/12
1
$15
17892
12/13/12
2
$25
1. Convert to INF Relation
2. Draw dependency diagram showing all functional dependencies
3. Identify anomalies
4. Convert to 3NF Relations
5. Develop EER Diagram with appropriate cardinalities
arrow_forward
Estem.org/courses/64525/assignments/9460783?module_item_id=18078917
The following information can help you get started:
• Invitation Details: it boils down to when and where
o When: Time and date
• Where: Address
• Invitee List: Name and email
• Name: First Name, or First Name and Last Name
Email: Email address
. Other considerations:
After you complete your invitation, answer the following questions:
1. What type of data are time, date, and place? How are they different from the other data types on the
invite and guest list?
F4
A
Additional information worth including: dress code, directions, gifting, how to contact you.
. How will you know who is showing up? RSVP?
. Is there a theme to your invitation/design?
x
F5
%
F6
F7
DELL
F8
F9
ROMNA
F10
F11
PrtScr
arrow_forward
PK
Cus CODE
PK
INV NUMBER
PK,FK1 INV NUMBER
LINE NUMBER
HEDenerates
contains
PK
CUS LNAME
CUs FNAME
CUs INITIAL
CUS AREACODE
CUS PHONE
CUS BALANCE
FK1 CUS CODE
INV DATE
P CODE
LINE UNITS
LINE PRICE
FK2
is found in
VENDOR
PRODUCT
PK V CODE
PK
P CODE
V NAME
v CONTACT
V AREACODE
V PHONE
V_STATE
V ORDER
P DESCRIPT
P INDATE
P_QOH
P MIN
P PRICE
DISCOUNT
FK1 V CODE
upplies
Write a SQL query to list the product code, vendor code, and vendor name for all products and includes those
vendors with no matching products.
Y CODE- PRODUCTY CODE
arrow_forward
provided code:
arrow_forward
Cse number 6,can you please help me on my assignment sir.
arrow_forward
Populate the CUST_NUM, INV_DATE, and INV_AMOUNT fields with the following customers:
CUST_NUM
INV_DATE
INV_AMOUNT
1000
2016-03-23
235.89
1001
2016-03-23
312.82
1001
2016-03-30
528.10
1000
2016-04-12
194.78
1000
2016-04-23
619.44
arrow_forward
How to format student Id number as; S2018164701,S2018164702......S2018164701 in Microsoft Access
arrow_forward
My id last two digit =32 so x1x2=32
Subject:Datacommunication
arrow_forward
Indicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a manager who is identified by a manager ID, a manager first name, and a manager last
name.
arrow_forward
Q9. Write an SQL statement to answer the question: 'Are there any bookings not
driven by qualified drivers, i.e. driver tvpe not matching vehicle type?’ The
resulting table is as follows.
BOOK ID VEH_DESC YEH_TYPE
1 8728 Volvo FM12 Medium Truck Vincent Ma LGV
DRIVER_MAME DRIVER_TYPE BOOK_DATE BOOK_TIME BOOK_HRS
|2022/3/4 14:30
2
Q10. In view of the possible problem as per Q9, suggest a way to prevent such
booking. You may consider running query to highlight this or changing the data
model to prevent so. Explain your suggestion.
arrow_forward
Write a program according to these class diagram and output results.
Booking.java
TestBooking.java
-name: String
|-address: String
-phone: String
-price: Double
|-countBooking =0: static int
|-totalPay=0: static double
+ static void main()
+ Booking()
+ Booking(name, phone)
+ getName()
+ getAddress()
+ getPhone()
+ getPrice()
+ getTotalPay()
+ setName()
+ şetAddress()
+ setPhone()
+ setPrice()
+ display()
arrow_forward
The data in flat files has been provided:
INVOICE TABLE
INVOICE_NUM
CUSTOMER_ID
INVOICE_DATE
EMPLOYEE_ID
COIN_ID
DELIVERY_ID
8111
11011
15 May 2021
emp103
7111
511
8112
11013
15 May 2021
emp101
7116
512
8113
11012
17 May 2021
emp101
7112
513
8114
11015
17 May 2021
emp102
7111
514
8115
11011
17 May 2021
emp102
7115
515
8116
11015
18 May 2021
emp103
7115
516
8117
11012
19 May 2021
emp105
7112
517
8118
11013
19 May 2021
emp105
7112
517
COIN_RETURNS TABLE
RETURN_ID
RETURN_DATE
REASON
CUSTOMER_ID
COIN_ID
EMPLOYEE_ID
ret001
25 May 2021
Customer not satisfied with product
11011
7116
emp101
ret002
25 May 2021
Product missing part
11013
7114
emp103
COIN TABLE
COIN_ID
PRODUCT
PRICE
QTY
7111
1oz Gold Kruger Rand
R 5 999
10
7112
1oz Silver Kruger Rand
R 12 999
8
7113
Gold Big 5 Uncirculated
R 15 999
8
7114
Silver Big 5 Pack
R 7 999
5
7115
1oz Gold Palaeontology
R 11 999
15
7116
1oz Silver Palaeontology
R 7 999
12
COIN_DELIVERY TABLE…
arrow_forward
Member ID
1582
2587
3549
9536
2567
2154
3265
8765
3259
6540
First Name
Mara
Philip
Kathleen
Sau
Shanice
Chase
Tommie
Dorcas
Angel
Weston
BookingID
1
2
3
4
5
6
7
8
Table 1: Member
Last Name Gender Age
Female 25
Male 36
Female 25
United States
Female 25 United States
Hashimoto
Gent
Hanner
Pfau
Mccrystal
Karner
Jia
Darity
Sanor
Martina
Room
Room 15
Room 25
Room 1
Room 15
Room 5
Room 21
Room 3
Room 8
Date
29-Dec-2020
9-Dec-2021
3-Mar-2019
4-Sep-2021
13-Feb-2021
6-May-2021
10-Nov-2020
4-Apr-2022
Table 2: Booking
Days
2
4
6
5
10
6
5
Female
36
Male 37
Male 26
Female
37
Male
24
Male
23
4
Table 3: Make
MemberID
3549
9536
6540
2154
2567
2154
3265
1582
$150.00
$80.00
$120.00
$300.00
Country
Uganda
France
3
4
China
Australia
United States
United States
Cost per day
$200.00
$80.00
$80.00
$150.00
5
6
7
8
France
China
BookingID
1
2
Joined Date
16-Aug-2020
21-May-2015
12-Dec-2017
16-Aug-2019
16-Aug-2020
1-Jan-2021
29-Dec-2018
21-May-2019
4-Mar-2019
1-Feb-2022
Status
Paid
Paid
Pending
Paid
Pending
Paid…
arrow_forward
Customer (CID, CName, Street, City, State, Gender)Agent (AgentID, GName, Position, Salary, Gender, BranchNo)Invoice(InvoiceNo, CID, AgentID, Product, Quantity, Total_amt)
List the invoice number, customer id, product id, quantity and total amount for all purchase made by customer with customer ID equal to ‘C001’, ‘C016’ and ‘C018’.
arrow_forward
Add/insert the following records to the CLIENTS table:
CLIENTS
CID
CName
Gender Address Contact
стуре
1521
Ahmed Said
Male
SLL
92214561
Old
1522
Salma
Female
MCT
92384792
New
Mohammed
1523
Faiza Ahmed
Female
SLL
97451382
Old
1524
Noaman Said
Male
NZW
New
arrow_forward
3. Input any KCST ID, Display the following message based the first 2 digits of the
KCST ID
ID first 2 digit
16
17
18
19
Sample Run-1
Enter a KCST ID: 1711112004
Hello, You joined KCST in 2017
Sample Run-2
Enter a KCST ID: 1911112008
Hello, You will join KCST in 2019
Message to Print
Hello, You joined KCST in 2016
Hello, You joined KCST in 2017
Hello, You joined KCST in 2018
Hello, You will join KCST in 2019
arrow_forward
Kindly answer the table, thank you <33
arrow_forward
What are the codes for this case?
C
Emergency Department
Patient Case Number: ED16-White, Salem
Patient Name: Salem White
Date of Service: 11-21-XX
Reason for Visit: Abdominal pain, diarrhea
C
DOB: 06-01-70
Sex: F
Attending Physician: Carl Landry, MD
Chief Complaint: Abdominal pain, diarrhea.
History of Present Illness:
Mrs. White presents to the Emergency Department with a complaint of mid supraumbilical
abdominal discomfort that has been intermittent over the past 6 days. Patient reports waking or
Saturday with mid abdominal discomfort and diarrhea.
Diarrhea persisted throughout the day with every po intake. She had voluminous diarrheal bowe
movements on multiple occasions Friday and Saturday. She also had intermittent
lightheadedness/dizziness with changes in position. Denies vomiting,
Denies fevers or chills. Patient denies episodes of chest pain or dyspnea different than her baseli
with underlying pulmonary disease. On Monday she was asymptomatic throughout the day. On t
lol,…
arrow_forward
Code. Request.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Related Questions
- Required information id fname lname company address city ST zip 103 Art Venere 8 W Cerritos Ave #54 Bridgeport NJ 8014 104 Lenna Paprocki Feltz Printing 639 Main St Anchorage AK 99501arrow_forwardGiven the Employee, Class, and Training tables. Employee Emp_id (PK) EM8765 Address USA Name Phone Email Ali ali@yahoo.com nazire@gmail.com katrina@gmail.com lemi@hotmail.com alican@yahoo.com mustafa@hotmail.com hasan@gmail.com 98733211 ЕМ3456 Nazire Dubai 98764533 90857464 EM7658 Katrina USA EM1987 Lemi USA 99663425 EM8009 Alican UK 95583372 |EM7698 Mustafa Dubai Jordan 92234452 EM6666 Hasan 92123366 Class Class_id (PK) Class_name Multimedia Credit СOM106 COM206 Database сомз06 Public Speaking 9. Training Table Emp_id (FK) EM8765 Date Class_id (FK) Result 05-May-2010 08-May-2011 08-Feb-2010 08-Feb-2010 соM106 Pass EM3456 COM206 Pass EM7658 сомз06 Fail EM1987 сомзо6 Fail 28-Jan-2011 10-March-2012 EM8009 сомз06 Pass EM7698 сом106 Fail EM8765 08-May-2011 сOM206 Pass Write the appropriate SQL queries a) Get the address of employee whose name is Alican b) Get the name and email of employees located in Dubai. Sort the results in alphabetical order of name. c) Show the count of employees…arrow_forwardPart 1: CUSTOMER CUST_NUM CUST_LNAME CUST_FNAME CUST_BALANCE 1000 Billy Jean 1050.11 1001 Amanda John 840.92 INVOICE INV DATE 23/3/2020 INV_NUM CUST_NUM INV_AMOUNT 8000 1000 235.89 8001 1001 23/3/2020 312.82 8002 1002 30/3/2020 528.10 8003 1003 12/4/2020 194.78 8004 1004 23/4/2020 619.44 1. Create both the CUSTOMER and INVOICE tables structure above. Details of both tables are: a) The customer number should store integer values. The name attributes should support variable length character data up to 30 characters each. The customer balance should support up to six digits on the left of the decimal place and two digits to the right of the decimal place. b) The invoice number should store integer values. The invoice date should store date values. The invoice amount should support up to 8 digits to the left of the decimal place and two digits to the right of the decimal place. 2. Write the SQL commands necessary to insert the data into the CUSTOMER table and the INVOICE table created in…arrow_forward
- Note:- its @ CSE sub don't rejectarrow_forwardCUSTOMERColumns = 7, Rows = 10 CustomerID LastName FirstName Address ZIP Phone Email 1 Shire Robert 6225 Evanston Ave N 98103 206-524-2433 Robert.Shire@somewhere.com 2 Goodyear Katherine 7335 11th Ave NE 98105 206-524-3544 Katherine.Goodyear@somewhere.com 3 Bancroft Chris 12605 NE 6th Street 98005 425-635-9788 Chris.Bancroft@somewhere.com 4 Griffith John 335 Aloha Street 98109 206-524-4655 John.Griffith@somewhere.com 5 Tierney Doris 14510 NE 4th Street 98005 425-635-8677 Doris.Tierney@somewhere.com 6 Anderson Donna 1410 Hillcrest Parkway 98273 360-538-7566 Donna.Anderson@elsewhere.com 7 Svane Jack 3211 42nd Street 98115 206-524-5766 Jack.Svane@somewhere.com 8 Walsh Denesha 6712 24th Avenue NE 98053 425-635-7566 Denesha.Walsh@somewhere.com 9 Enquist Craig 534 15th Street 98225 360-538-6455 Craig.Enquist@elsewhere.com 10 Anderson Rose 6823 17th Ave NE 98105 206-524-6877 Rose.Anderson@elsewhere.com EMPLOYEEColumns = 5, Rows = 5 EmployeeID LastName FirstName…arrow_forwardCUSTOMERColumns = 7, Rows = 10 CustomerID LastName FirstName Address ZIP Phone Email 1 Shire Robert 6225 Evanston Ave N 98103 206-524-2433 Robert.Shire@somewhere.com 2 Goodyear Katherine 7335 11th Ave NE 98105 206-524-3544 Katherine.Goodyear@somewhere.com 3 Bancroft Chris 12605 NE 6th Street 98005 425-635-9788 Chris.Bancroft@somewhere.com 4 Griffith John 335 Aloha Street 98109 206-524-4655 John.Griffith@somewhere.com 5 Tierney Doris 14510 NE 4th Street 98005 425-635-8677 Doris.Tierney@somewhere.com 6 Anderson Donna 1410 Hillcrest Parkway 98273 360-538-7566 Donna.Anderson@elsewhere.com 7 Svane Jack 3211 42nd Street 98115 206-524-5766 Jack.Svane@somewhere.com 8 Walsh Denesha 6712 24th Avenue NE 98053 425-635-7566 Denesha.Walsh@somewhere.com 9 Enquist Craig 534 15th Street 98225 360-538-6455 Craig.Enquist@elsewhere.com 10 Anderson Rose 6823 17th Ave NE 98105 206-524-6877 Rose.Anderson@elsewhere.com EMPLOYEEColumns = 5, Rows = 5 EmployeeID LastName FirstName…arrow_forward
- Normalize the following table to the 3rd Normal form: Student Student Phone Course Term Grade Instructor Instructor Phone Lauren Fernell 555-7771 MIS 350 F12 A Hess 555-2222 Lauren Fernell 555-7771 MIS 372 F12 B Sarker 555-2224 Lauren Fernell 555-7771 MIS 426 F12 A Fuller 555-2227 Lauren Fernell 555-7771 MIS 375 F12 B+ Wells 555-2228 Brigit Schnieder 555-2215 MIS 350 F12 A Hess 555-2222 Brigit Schnieder 555-2215 MIS 375 F12 B+ Wells 555-2228 Brigit Schnieder 555-2215 MIS 372 F12 A Sarker 555-2224 Brigit Schnieder 555-2215 MIS 374 F12 B Clay 555-2221 Jackie Judson 555-1245 MIS 350 F12 A Hess 555-2222 Jackie Judson 555-1245 MIS 372 F12 B+ Sarker 555-2224 How many tables did you create after normalizing the table? List each of…arrow_forwardTABLE 4-6 Parking Tickets at Millennium College Parking Ticket Table St ID L Name F Name Phone No St Lic Lic No Ticket # Date Code Fine 38249 Brown Thomas 111-7804 FL BRY 123 15634 10/17/12 2 $25 16017 11/13/12 1 $15 82453 Green Sally 391-1689 AL TRE 141 14987 10/05/12 $100 16293 11/18/12 1 $15 17892 12/13/12 2 $25 1. Convert to INF Relation 2. Draw dependency diagram showing all functional dependencies 3. Identify anomalies 4. Convert to 3NF Relations 5. Develop EER Diagram with appropriate cardinalitiesarrow_forwardEstem.org/courses/64525/assignments/9460783?module_item_id=18078917 The following information can help you get started: • Invitation Details: it boils down to when and where o When: Time and date • Where: Address • Invitee List: Name and email • Name: First Name, or First Name and Last Name Email: Email address . Other considerations: After you complete your invitation, answer the following questions: 1. What type of data are time, date, and place? How are they different from the other data types on the invite and guest list? F4 A Additional information worth including: dress code, directions, gifting, how to contact you. . How will you know who is showing up? RSVP? . Is there a theme to your invitation/design? x F5 % F6 F7 DELL F8 F9 ROMNA F10 F11 PrtScrarrow_forward
- PK Cus CODE PK INV NUMBER PK,FK1 INV NUMBER LINE NUMBER HEDenerates contains PK CUS LNAME CUs FNAME CUs INITIAL CUS AREACODE CUS PHONE CUS BALANCE FK1 CUS CODE INV DATE P CODE LINE UNITS LINE PRICE FK2 is found in VENDOR PRODUCT PK V CODE PK P CODE V NAME v CONTACT V AREACODE V PHONE V_STATE V ORDER P DESCRIPT P INDATE P_QOH P MIN P PRICE DISCOUNT FK1 V CODE upplies Write a SQL query to list the product code, vendor code, and vendor name for all products and includes those vendors with no matching products. Y CODE- PRODUCTY CODEarrow_forwardprovided code:arrow_forwardCse number 6,can you please help me on my assignment sir.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L