annotated-Assignment3.pdf

CS631-105Fall 2022 Assignment 3 – SQL Due 12/12/22 1 If you do not read the Guidelines and Submission Requirements, you will probably be giving away points. Also, check the Announcements page on Canvas daily for hints and revisions to the assignment. Creation of Tables 1. Create the Company database. a. Do not submit the code used to create the database. 2. Enter each table as it is shown in the sample database at the end of the assignment. a. DO NOT MAKE UP DATA b. MADE UP DATA WILL RESULT IN A 20 POINT PENALTY c. DO NOT SUBMIT THE CODE USED TO CREATE THE DATABASE AND THE TABLES. I DO NOT NEED TO SEE IT. 3. After you have created the database, tables. read the Guidelines, and read the Submission Assignments you can proceed to Problem1. Guidelines: 1. All problems must be solved using SQL code. The SQL code and the output of your query should be cut and pasted into your submitted file (via Canvas). a. All SQL code must be displayed in your submission. Do not omit any code. b. Output tables must be a screenshot taken from the DBMS output page. c. You must display the whole output. Points will be deducted for partial displays. 2. Do not paste outputs from multiple queries into a single result. This does not apply to problems 1,2,4, and 6. 3. When creating your own column headings, NEVER use a column heading with an underbar( ‘_’ ) in it. So, when modifying the display of fname, the heading of First Name is acceptable but First_Name is NOT. 4. Check your work carefully. I am not very sympathetic to errors that would easily turn up if checked. 5. You may assume thedatabase tables will not change in size (unless stated). 6. Certainly, if you have questions, you are welcome to call me (908-418-6078) or send an email. More specifically, this is not a math test, so if you do not know how to do a calculation, I will provide that information. 7. Submit one document only, unzipped. a. Handwritten problems will not be accepted. 8. You do not need to include the code that shows how the original tables were created and table data was entered for the Employee database. 9. Here is a sample of what I expect to see.

CS631-105Fall 2022 Assignment 3 – SQL Due 12/12/22 2 Submission Requirements: 1. This assignment is due Wednesday 4/26/23 at 6pm. IT WILL NOT BE ACCEPTED LATE . 2. The assignment must be submitted via Canvas. a. Submit one document only, unzipped. b. It must be readable, and it is your responsibility to confirm this. If I cannot read it, you run the risk of getting a zero. c. Handwritten problems will not be accepted unless permission is granted by ME. 3. All work must be your own. The only person you may discuss the assignment with is me (Professor Forman) a. You may NOT discuss problems with any other student. b. You may NOT get answers from sites such as Chegg or Homework Hero or any other online site. c. Use of an SQL code generator will be considered a violation of the “do your ow n work rule” d. Anything not mentioned, that constitutes “ not doing your own work” will be considered cheating. e. Violation of these requirements will result in a grade of 0.

CS631-105Fall 2022 Assignment 3 – SQL Due 12/12/22 3 At this point you should have created the Company database, including all tables and all required data. Problem 1 (5 points) : Display the following tables. Use the format Select * from table name. You do not need to submit the code that shows how the database and the tables were created. I do not need to see it. Employee Department

CS631-105Fall 2022 Assignment 3 – SQL Due 12/12/22 4 Works_On Project

CS631-105Fall 2022 Assignment 3 – SQL Due 12/12/22 5 Dependent This is not a “ trick question ” . Problem 2(10 points) : Write SQL code to add the following three records to the Employee table and the new department record to the Department table. Cut and paste the code and display the modified tables. Note the output for this problem MUST show the original Employee and Department table records plus the new records created. Show all code plus output. Employee Table Attribute Person 1 Person 2 Person 3 Fname Fred Natasha George Minit F Q W Lname Flinstone Fatale Jetson SSN 444-55-8666 444-23-5175 585-66-3733 Bdate 1981-06-17 1948-09-08 1946-08-19 Home Address (#+Street), City, State) 101Plano, Dallas, TX 369 Plano, Houston, CA 4499 Humble, Plano, TX Sex M M M Salary 75,675 101,345 201,999 Super_ssn 585-66-3733 585-66-3733 888-66-5555 Dno 6 6 6

CS631-105Fall 2022 Assignment 3 – SQL Due 12/12/22 6 insert into employee values ( 'Fred', 'F', 'Flinstone', '444558666', '1981-06-17', '101 Plano, Dallas, TX', 'M', '75675', '585663733', '6' ), ('Natasha', 'Q', 'Fatale', '444235175', '1948-09-08', '369 Plano, Houston, CA', 'M', '101345', '585663733', '6' ), ('George', 'W', 'Jetson', '585663733', '1946-08-19', '4499 Humble, Plano, TX', 'M', '201999', '888665555', '6'); Output: Department Table Attribute New Department Dname Crazy Cartoons Dnumber 6 Mgr_ssn 585-66-3733 Mgr_start_date 2022-09-14

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