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 Resut A a a soL AlI Rows Fenched 6 in 0.759 seconds 5D 5 LAST 5.FRST )5MS ADDRESS 1 30100 Jones TannyR 2 PELBO Perez Jorge C 05 STATES,ZS PHONE 05.CLASS5008 0S PNFD TIME_ENROLLED 1817 Eagleridge Circle Tallatassee FL 1-03-02 1-04-02 32811 7155559876 SR 14-JUL-15 8891 951 Rainbow Dr Clernent FL 34711 7155552345 SR 19-AUG-85 1230 3 MAL0 Harsh John A 1275 West Main St Carratelle FL 32320 7155553987 JR 10-OCT-82 1613 1+03-00 4 SMIee Saith 5 30101 Johnson Lisa Eastpeint FL Leesburg Mike (rull) 428 Markson Ave 32328 7155556982 S0 24-SEP-16 1841 2+82-02 764 Johnson Place FL 34751 7155558899 so 20-NOV-16 4420 401-11 6 NGI0 Nguyen Ni 688 4th Street Orlando FL 31458 7155554944 FR 84-DEC-86 9LE8 3-04

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
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 Resut
A a a soL AlI Rows Fenched 6 in 0.759 seconds
5D 5 LAST 5.FRST )5MS ADDRESS
1 30100 Jones TannyR
2 PELBO Perez Jorge C
05 STATES,ZS PHONE 05.CLASS5008 0S PNFD TIME_ENROLLED
1817 Eagleridge Circle Tallatassee FL
1-03-02
1-04-02
32811 7155559876 SR
14-JUL-15
8891
951 Rainbow Dr
Clernent FL
34711 7155552345 SR
19-AUG-85
1230
3 MAL0 Harsh John
A
1275 West Main St
Carratelle FL
32320 7155553987 JR
10-OCT-82
1613
1+03-00
4 SMIee Saith
5 30101 Johnson Lisa
Eastpeint FL
Leesburg
Mike
(rull) 428 Markson Ave
32328 7155556982 S0
24-SEP-16
1841
2+82-02
764 Johnson Place
FL
34751 7155558899 so
20-NOV-16
4420
401-11
6 NGI0 Nguyen Ni
688 4th Street
Orlando
FL
31458 7155554944 FR
84-DEC-86 9LE8
3-04
Transcribed Image Text: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 Resut A a a soL AlI Rows Fenched 6 in 0.759 seconds 5D 5 LAST 5.FRST )5MS ADDRESS 1 30100 Jones TannyR 2 PELBO Perez Jorge C 05 STATES,ZS PHONE 05.CLASS5008 0S PNFD TIME_ENROLLED 1817 Eagleridge Circle Tallatassee FL 1-03-02 1-04-02 32811 7155559876 SR 14-JUL-15 8891 951 Rainbow Dr Clernent FL 34711 7155552345 SR 19-AUG-85 1230 3 MAL0 Harsh John A 1275 West Main St Carratelle FL 32320 7155553987 JR 10-OCT-82 1613 1+03-00 4 SMIee Saith 5 30101 Johnson Lisa Eastpeint FL Leesburg Mike (rull) 428 Markson Ave 32328 7155556982 S0 24-SEP-16 1841 2+82-02 764 Johnson Place FL 34751 7155558899 so 20-NOV-16 4420 401-11 6 NGI0 Nguyen Ni 688 4th Street Orlando FL 31458 7155554944 FR 84-DEC-86 9LE8 3-04
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY