Find Jobs
Hire Freelancers

Database Triggers

$10-15 USD

已完成
已发布大约 21 年前

$10-15 USD

货到付款
This project is bout creating some database triggers with SQL scripts..There is very tiny lil 3 problems on it..which i have to get done as soon as possible..like arround in 5-6 [login to view URL] database triggers should work Under Oracle 8i or 9i with sqlplus. ## Deliverables a) Implement and test a statement trigger that verifies a consistency constraint: “A truck cannot be used for two or more different trips on the same day??. b) Implement and test a row trigger that verifies the following consistency constraint: “The values of attribute LEG# in TRIPLEG table must be contiguous, i.e. 1,2,3,4 … for each trip??. c)Implement SQL script that adds to a relational table TRUCK an attribute TOTMTIME (TOTal Maintenance TIME) and sets the values of the attribute consistent with the current contents of the database. Attribute TOTMTIME should contain information about the total time of all maintenance tasks performed on each truck. If a truck has not been maintained so far set the appropriate value of TOTMTIMT to zero. Implement and test a trigger that automatically updates the values of TOTMTIME whenever it is necessary. ## Platform Should work on Oracle 8i or 9i with SqlPlus. A file named "[login to view URL]" has got all the tables thats needed to get goin with the database is includin on the zip file.
项目 ID: 2918836

关于此项目

2提案
远程项目
活跃21 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
See private message.
$12 USD 在14天之内
4.9 (7条评论)
2.2
2.2
2威客以平均价$12 USD来参与此工作竞价
用户头像
See private message.
$12.75 USD 在14天之内
5.0 (27条评论)
4.1
4.1

关于客户

AUSTRALIA的国旗
Australia
5.0
9
会员自10月 13, 2002起

客户认证

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