Find Jobs
Hire Freelancers

Creating queries (database)

$5-10 USD

已完成
已发布将近 22 年前

$5-10 USD

货到付款
Create all necessary tables based on the schema shown on the following page. b. Prepare a relational schema diagram for the database shown on the following page. c. Populate the tables with the data shown on the following page and some of your own. d. Perform the following queries: 1. Retrieve, in alphabetic order, the name and address of all employees who work for "Research" department. 2. List the names of all employees who have a dependent with the same first name as themselves. 3. For every project located in "Stafford", list the project number, the controlling department number, and the department manager's name, address, and birthdate. 4. Retreive the name of employees who work on every project. 5. Find the names of employees who work on all the projects controlled by department number 5. 6. Make a list of project numbers for projects that involve an employee whose last name is 'Smith', either as a worker or as a manager of the department that controls the projects. 7. List the names of all employees with two or more dependents. 8. Retrieve the names of employees who have no dependents. 9. List the names of employees who have at least one dependent. 10. Find the number of employees whose salary is above the average salary. e. Perform one of the above queries using either PL/SQL or Embedded SQL. ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. SEE ATTACHED FILE FOR ALL THE DESCRPTION ## Platform Oracal 8i
项目 ID: 2848540

关于此项目

11提案
远程项目
活跃22 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
See private message.
$7 USD 在14天之内
4.9 (7条评论)
2.2
2.2
11威客以平均价$8 USD来参与此工作竞价
用户头像
See private message.
$8.50 USD 在14天之内
5.0 (122条评论)
6.8
6.8
用户头像
See private message.
$8.50 USD 在14天之内
4.9 (133条评论)
6.4
6.4
用户头像
See private message.
$8.50 USD 在14天之内
5.0 (35条评论)
4.8
4.8
用户头像
See private message.
$8.50 USD 在14天之内
5.0 (32条评论)
4.2
4.2
用户头像
See private message.
$8.50 USD 在14天之内
5.0 (38条评论)
4.1
4.1
用户头像
See private message.
$8.50 USD 在14天之内
5.0 (3条评论)
2.7
2.7
用户头像
See private message.
$8.50 USD 在14天之内
5.0 (8条评论)
2.5
2.5
用户头像
See private message.
$8.50 USD 在14天之内
4.0 (2条评论)
0.0
0.0
用户头像
See private message.
$7.65 USD 在14天之内
0.0 (0条评论)
0.0
0.0
用户头像
See private message.
$8.50 USD 在14天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
United States
5.0
10
会员自11月 27, 2001起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。