Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Section 3 - More Exercises: Create a new database named as LastNameFirstName 1: create database LastNameFirstName_1; 7. (2 points) Use appropriate DDL to create

Section 3 - More Exercises: Create a new database named as LastNameFirstName 1: create database

Section 3 - More Exercises: Create a new database named as LastNameFirstName 1: create database LastNameFirstName_1; 7. (2 points) Use appropriate DDL to create two new tables EMP and DEPT. Please make sure to choose appropriate data type for each attribute, and also add a primary key to each table. REMINDER: Don't forget to hit refresh and then double click to select your new database schema! (Include your DDL statements in your submission.) 8. (2 points) Now you are ready to add new tuples into your tables. Note: This is a bunch of busy work, but it's easy ;-) (Include your DDL statements in your submission.) 1. Insert all 14 tuples listed in Appendix 1 into EMP 2. Insert all 4 tuples listed in Appendix 1 into DEPT

Step by Step Solution

There are 3 Steps involved in it

Step: 1

The Below are the DDL statements to create the EMP and DEPT tables along with the DDL statements to ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Programming questions

Question

If Io = 4 ) 2 ) A 310 1 1, 10 ) + -j1a +1

Answered: 1 week ago

Question

How can NAFTA be beneficial to suppliers of Walmart?

Answered: 1 week ago