![]() ![]() Label the columns Employee and Monthly Salary, Modify lab2_3 to list the last name and salary of employees who earn between $5,000 and Display the last name and department number of all employees in departments 20 and 50 inĦ. Order the query in ascending order by start date.ĥ. Display the employee last name, job ID, and start date of employees hired between February 20,ġ998, and May 1, 1998. Place your SQL statement in a text file named lab2_3.Ĥ. Modify lab2_1 to display the last name and salary for all employees whose salary is not in Your SQL statement to a file named lab1_7.ģ. Hire date, and employee number for each employee, with employee number appearing first. Create a query to display the last name, job code, Show the structure of the EMPLOYEES table. Select all data from the DEPARTMENTS table.ħ. Show the structure of the DEPARTMENTS table. A comma is missing after the column, LAST_NAME.Ħ. The alias should read ANNUAL_SALARY or be enclosed The ANNUAL SALARY alias cannot include spaces. The multiplication operator is *, not x, as shown in line 2. Can you identify them?įROM employees – The EMPLOYEES table does not contain a column called sal. There are four coding errors in this statement. ![]() The following SELECT statement executes successfully:ĥ. The following SELECT statement executes successfully:Ĥ. iSQL*Plus commands access the database.ģ. ![]() Initiate an iSQL*Plus session using the user ID and password provided by the instructor.Ģ. Atif Student Name Dilawar Khan CMSID 45898 Department Software Engineering Section Fall- 1. This course may impose additional academic integrity stipulations consult the official course documentation for more information.DATABASE LAB MANUALS Instructor Mr. See the College of Computing's technical requirements. Academic IntegrityĪll Georgia Tech students are expected to uphold the Georgia Tech Academic Honor Code. Flexibility and readiness to work remotely with team members is a must. Willingness to learn basic system administration tasks is necessary. Some familiarity with software engineering concepts and Git/source control will be helpful. ![]() Learners should be familiar with at least one scripting or programming language, e.g., PHP, Python, Java. You can view the lecture videos for this course here. For the most up-to-date information, consult the official course documentation. Note: Sample syllabi are provided for informational purposes only. Finally, techniques and tools for metadata management and archival will be presented. Students will also learn the Extended Entity Relationship Model, the Relational Model, Relational algebra, calculus and SQL, database normalization, efficiency, and indexing. In parallel - slightly delayed - learners in the course will apply the database application development methodology, techniques, and tools to their own major class team project. All the database concepts, techniques, and tools that are needed to develop a database application from scratch are introduced along the way when they are needed. This course presents an example of applying a database application development methodology to a major real-world project. I believe in learning-by-example and learning-by-doing. Instructional Team Leo Mark Creator, Instructor ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |