Page 1 of 2 King Saud University College of Computer and Information Sciences Information Technology Department IT422 Artificial Intelligence HOMEWORK 1 Q1: Problem formulation Three fathers with 3 children (A and his child CA‚ B and his child CB‚ and C and his child CC) are standing on side North of a river. The three fathers want to cross the river (go to side South) with their children‚ but there is only one boat‚ which can hold a maximum of two persons (a child is considered a person). Furthermore
Premium Saudi Arabia Hierarchy Graph theory
operations using Entity Framework. Using examples specified below implement the following pages: Page that will show all the employees Page that will show all the employees filtered by Job Page where you will be able to insert or update new employee Page where you will be able to delete employee by EmpNo Create tables that we used for Library case study in SQL Server DB and implement Lbrary system using Entity Framework. Entity Framework Examples Select //getting list of objects
Premium Object
#include <stdlib.h> #include <stdio.h> #include <string.h> #include "dynamicArray.h" #include <assert.h> /* param: s the string * param: num a pointer to double * returns: true (1) if s is a number else 0 or false. * postcondition: if it is a number‚ num will hold * the value of the number * */ int isNumber(char *s‚ double *num) { char *end; double returnNum; returnNum = strtod(s‚ &end); /* If there’s
Premium Mathematics
Tag Example: Main Module End Main Module Declare [DataVariableName] as [DataType] * DataVariableName can be any name chosen as long as it is one word. * DataType can be one of the following basic types: Float‚ Real‚ Integer‚ String. Example: Declare NumSandwiches As Integer Declare FirstName As String Display (or Write) [Sting or data variable to be displayed] * If sting is used‚ you must have it start and end with quotations Example 1: Display “Hello World” Example 2:
Premium Statement
Using the database and tables from Week Three‚ write queries using the SQL SELECT statement. Note: Select all of the data from both of your tables before you perform the following. · Select an EEO-1 Classification: Enhance all employees’ salaries that have: the selected EEO-1 classification by 10%. revise employee set salary = salary * 1.1 where eeo_1_classification = ’sales workers’ · Increase all employees’ salaries by 5%. revise employee set salary = salary
Premium Wage SQL Employment
LAB 4 STUDENT NAME: Rajendhar Dayalan Student ID:12667690 Q1 Please write down the modified script for creating the add_jobs procedure into your report. CREATE OR REPLACE PROCEDURE ADD_JOBS (p_jobid IN jobs.job_id%TYPE‚ p_jobtitle IN jobs.job_title%TYPE‚ p_minsal IN jobs.min_salary%TYPE ) is v_maxsal jobs.max_salary%TYPE; BEGIN v_maxsal:= 2* p_minsal; Insert into jobs values(p_jobid‚p_jobtitle‚p_minsal‚v_maxsal); DBMS_OUTPUT.PUT_LINE (’Added the following
Premium SQL Programming language Statement
SQL Exercises (with answers) Give the SQL commands for the following and answer any associated questions: (A) “Simple” SELECT Command Questions 1. Display all information in the tables EMP and DEPT. SELECT * FROM emp; SELECT * FROM dept; 2. 3. 4. 5. 6. 7. Display only the hire date and employee name for each employee. SELECT hiredate‚ ename FROM emp; Display the hire date‚ name and department number for all clerks. SELECT hiredate‚ ename‚ deptno FROM emp WHERE job = ’CLERK’; Display the names and
Premium SQL Employment
Oracle Table Triggers Version 11.1 General Data Dictionary Views Related To DDL Triggers trigger$ dba_triggers all_triggers user_triggers System Privileges Related To Table Triggers create trigger create any trigger administer database trigger alter any trigger drop any trigger Table Trigger Firing Options -- before constraints are applied BEFORE INSERT BEFORE UPDATE BEFORE DELETE -- after constraints are applied AFTER INSERT AFTER UPDATE AFTER DELETE Transaction
Premium SQL
1. SELECT e.ename‚ e.deptno‚ d.dname‚ d.deptno FROM dept d LEFT OUTER JOIN emp e ON d.deptno = e.deptno ORDER BY d.deptno; SQL> SELECT e.ename‚ e.deptno‚ d.dname‚ d.deptno 2 FROM dept d 3 LEFT OUTER JOIN emp e 4 ON d.deptno = e.deptno 5 ORDER BY d.deptno; ENAME DEPTNO DNAME DEPTNO ---------- ---------- -------------- ---------- MILLER 10 ACCOUNTING 10 KING 10 ACCOUNTING
Premium SQL Foreign key Relational model
Design Patterns FOR DUMmIES by Steve Holzner‚ PhD ‰ Design Patterns FOR DUMmIES ‰ Design Patterns FOR DUMmIES by Steve Holzner‚ PhD ‰ Design Patterns For Dummies® Published by Wiley Publishing‚ Inc. 111 River Street Hoboken‚ NJ 07030-5774 www.wiley.com Copyright © 2006 by Wiley Publishing‚ Inc.‚ Indianapolis‚ Indiana Gamma/Helm/Johnson/Vlissides‚ DESIGN PATTERNS: ELEMENTS OF REUSABLE OBJECT-ORIENTED SOFTWARE‚ © 1995 Pearson Education‚ Inc. Reprinted
Premium