12.18.23 Sec2 hmwk query editor features

docx

School

Pensacola State College *

*We aren’t endorsed by this school

Course

102

Subject

Computer Science

Date

Feb 20, 2024

Type

docx

Pages

5

Uploaded by MagistrateTurtlePerson4989

Report
Charles Norris Sect2 Query Editor Features 12/18/2023 1. CREATING TABLES (RIGHT CLICK NEW TABLE) 2. 2. If they already exist, delete and recreate emp (empid int,empname varchar(50),deptid int) & dept (deptid int,deptname varchar(50)) TABLES .
Charles Norris Sect2 Query Editor Features 12/18/2023 3. Populate the above tables using (Right Click table – Edit Top 200 Rows) a. Put 10 rows into each table.
Charles Norris Sect2 Query Editor Features 12/18/2023 4. CREATING SELECT STATEMENTS - If the statements below don’t match your data, alter your data to be able to answer the questions.
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
Charles Norris Sect2 Query Editor Features 12/18/2023 5. CREATE TABLES USING SCRIPT Create emp2 (empid int,empname varchar(50),deptid int) & dept2 (deptid int,deptname varchar(50)) TABLES using CREATE TABLE.
Charles Norris Sect2 Query Editor Features 12/18/2023 Submit a screenshot of your created zoom account. Add to it the 2 meet times for your group

Related Documents

Understanding digital citizenship, ribble 2015.pdf
CS651_KristineCameron_IP2.doc.docx
CS651_KristineCameron_IP3.doc.docx
CS651_KristineCameron_Final.doc.docx
CS651_KristineCameron_IP4.doc.docx
12.21.23 Sec3 Hmwk Lab2 wrk with Tables.docx
INF103Week2Assignment.docx
Discussion 6.docx
3-3 Milestone Paper Prototype.docx
Discussion 2.docx
5-3 Data priorities.docx
Project One.docx
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
SEE MORE TEXTBOOKS
Recommended textbooks for you
  • Text book image
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning
    Text book image
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781305627482
    Author:Carlos Coronel, Steven Morris
    Publisher:Cengage Learning
    Text book image
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781285196145
    Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
    Publisher:Cengage Learning
  • Text book image
    A Guide to SQL
    Computer Science
    ISBN:9781111527273
    Author:Philip J. Pratt
    Publisher:Course Technology Ptr
    Text book image
    CMPTR
    Computer Science
    ISBN:9781337681872
    Author:PINARD
    Publisher:Cengage
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
SEE MORE TEXTBOOKS