Fendi包包价格
高仿七个星期五多少钱
高仿江诗丹顿机械表
宝珀男士手表怎么样
高仿华伦天奴包包价格
高仿江诗丹顿机械表怎么样
积家女表价格
高仿百达翡丽男表多少钱
高仿宝格丽女表多少钱
皇家橡树男士手表价格
高仿ugg包怎么样
宝格丽
安德玛运动鞋价格
万国手表价格
高仿绿水鬼男士手表多少钱
高仿罗意威女包怎么样
高仿理查德米勒机械表
宝格丽男士手表
天梭表怎么样
浪琴女表多少钱
沛纳海男表
迪奥价格
七个星期五男表
卡地亚女士手表
宝格丽机械表价格
高仿百达翡丽手表价格
古奇包包
理查德米勒手表
高仿PUMA多少钱
高仿卡地亚手表价格
高仿loewe包包
高仿积家手表多少钱
Fendi女包
高仿万国表
真力时男表价格
高仿帕玛强尼男表
高仿黑水鬼男士手表怎么样
高仿宝格丽怎么样
PUMA运动鞋
百达翡丽女士手表
高仿普拉达包多少钱
香奈儿
高仿卡西欧男表
高仿真力时男士手表怎么样
万宝龙男士手表
机械表怎么样
天梭男表多少钱
香奈儿
高仿蓝气球机械表价格
高仿巴宝莉包包价格
高仿格拉苏蒂价格
loewe怎么样
高仿卡地亚女士手表价格
高仿蓝气球机械表价格
高仿ugg包价格
高仿乔丹运动鞋
欧米茄女士手表怎么样
爱彼男表怎么样
理查德米勒机械表
浪琴男士手表
高仿鬼冢虎运动鞋价格
浪琴男表
高仿泰格豪雅机械表价格
阿迪达斯运动鞋多少钱
高仿冠军鞋价格
高仿卡地亚机械表多少钱
劳力士机械表价格
华伦天奴怎么样
高仿aj运动鞋
天梭男士手表怎么样
高仿宝玑手表多少钱
阿迪怎么样
百年灵机械表多少钱
高仿沛纳海价格
芝柏表怎么样
高仿劳力士男表
高仿皇家橡树男表
高仿普拉达男包价格
七个星期五男表价格
高仿帝舵多少钱
高仿y3运动鞋
高仿皇家橡树手表价格
蓝气球价格
高仿泰格豪雅怎么样
高仿乔丹鞋怎么样
高仿男包
百年灵表多少钱
高仿宝格丽男士手表怎么样
高仿积家机械表怎么样
高仿浪琴手表价格
宝格丽男表
理查德米勒男表怎么样
蓝气球价格
帝舵机械表
香奈儿
高仿万宝龙手表价格
高仿宇舶表怎么样
香奈儿价格
高仿万宝龙男士手表
高仿芝柏表怎么样
格拉苏蒂男表价格
理查德米勒手表价格
瑞士名表价格多少
高仿欧米茄机械表怎么样
高仿理查德米勒
高仿古奇女包多少钱
高仿伯爵女士手表多少钱
卡地亚手表价格
mcm
阿迪达斯运动鞋多少钱
高仿蓝气球男表怎么样
高仿天梭机械表
万国男士手表怎么样
高仿手表
万国男士手表怎么样
高仿宝玑男士手表怎么样
高仿LV男包
高仿宝玑手表价格
高仿爱彼
芝柏多少钱
华伦天奴包价格
高仿宝珀男表价格
美度男表价格
百达翡丽男士手表怎么样
高仿天梭男士手表多少钱
高仿LV男包
高仿帝舵表价格
宇舶手表怎么样
路易威登包多少钱
帝舵手表
高仿泰格豪雅表多少钱
高仿蓝气球手表
CHANEL包
高仿古驰男包多少钱
高仿皇家橡树价格
高仿手表
高仿绿水鬼手表价格
耐克怎么样
男表怎么样
古驰包
高仿理查德米勒手表怎么样
真力时手表怎么样
爱彼男士手表价格
卡地亚女士手表
新百伦运动鞋价格
高仿ysl多少钱
宝格丽女表
高仿陀飞轮
高仿劳力士手表
泰格豪雅表多少钱
高仿LV
爱彼男表怎么样
高仿伯爵怎么样
高仿亚瑟士鞋多少钱
鬼冢虎鞋
高仿安德玛鞋怎么样
百达翡丽机械表多少钱
高仿古奇包怎么样
高仿美度机械表怎么样
高仿PUMA鞋价格
香奈儿多少钱
高仿七个星期五男士手表价格
高仿伯爵机械表怎么样
高仿百达翡丽男士手表多少钱
高仿安德玛篮球鞋多少钱
高仿瑞士男士手表多少钱
高仿皇家橡树手表怎么样
范思哲包价格
高仿古驰包价格
宇舶男士手表多少钱
高仿理查德米勒怎么样
高仿宝格丽手表价格
香奈儿包包价格
高仿普拉达
高仿陀飞轮怎么样
宝玑手表
卡西欧机械表多少钱
高仿爱马仕男包
高仿ysl包价格
高仿宝玑表价格
高仿y3鞋怎么样
高仿瑞士男士手表怎么样
高仿天梭男士手表多少钱
高仿LV包
劳力士男士手表
蓝气球男士手表怎么样
高仿帝舵机械表价格
高仿包
高仿香奈儿女士手表价格
高仿宝珀男士手表多少钱
Fendi包包价格
亚瑟士鞋
高仿理查德米勒机械表多少钱
陀飞轮表价格
积家女士手表怎么样
高仿蓝气球表多少钱
高仿皇家橡树机械表价格
欧米茄男表
高仿nike多少钱
高仿男士手表价格
高仿陀飞轮多少钱
高仿女包
高仿欧米茄男表怎么样
鬼冢虎篮球鞋怎么样
古驰
高仿宝格丽女士手表价格
高仿ugg包包多少钱
普拉达包
高仿美度手表价格
高仿百年灵男表
高仿皇家橡树手表
高仿斐乐多少钱
亚瑟士篮球鞋
匡威价格
高仿七个星期五表怎么样
万国机械表
高仿男表价格
卡地亚女表怎么样
高仿美度男士手表价格
古奇包包
高仿蓝气球男士手表
高仿百达翡丽女表价格
高仿宝玑价格
卡地亚表价格
皇家橡树机械表价格
卡地亚女表怎么样
芝柏手表怎么样
江诗丹顿机械表多少钱
高仿沛纳海机械表
阿迪达斯鞋价格
高仿匡威运动鞋怎么样
路易威登男包怎么样
CHANEL包怎么样
高仿
高仿宝玑表多少钱
高仿y3篮球鞋
欧米茄手表
高仿三叶草鞋多少钱
普拉达女包
高仿安德玛运动鞋价格
高仿理查德米勒手表怎么样
高仿包包
高仿路易威登价格
高仿绿水鬼表
爱彼价格
高仿黑水鬼男士手表怎么样
伯爵机械表
江诗丹顿多少钱
理查德米勒
宇舶表价格
彪马运动鞋
瑞士男表怎么样
高仿普拉达女包价格
高仿宇舶男士手表怎么样
高仿百年灵男士手表多少钱
浪琴男士手表怎么样
高仿爱彼男表多少钱
adidas
高仿泰格豪雅男士手表多少钱
高仿普拉达包包
泰格豪雅手表价格
阿玛尼怎么样
高仿爱马仕男包
范思哲
女表价格
芝柏手表价格
万国表怎么样
高仿真力时机械表多少钱
hermes 酷奇
军队人才网:2020军队文职招聘考试报名入口 河北新闻联播,00493,jason walker down,
中青网   2019-12-06 05:10   
泰格豪雅:
美度
三亚市市政维护应急中心-2019年市政维护设备购置项目-公开招标公告,  伊顿EGE3040FFB新优惠价格 价格咨询请联系:毛女士13671505969微信同号,  

  

  王者glory蔡文姬邪式私布新皮肤繁星吟游,这款皮肤的目前已经要上线了,在12月5日会合启限时秒杀,仅仅主要60面券就可以拿下。对于这样一款皮肤玩家们肯定想知说限时秒杀的持绝时间,这个皮肤会下架吗?对于这些问题战小编一起去了解一下详情吧。



  王者glory蔡文姬繁星吟游会下架吗?



  



  这款皮肤是没有会下架的,只是在第一周的流动中会以60面券去售售,到了第二周就会以原价的方式去售售了,所以玩家们想要购买这款皮肤的捉住第一周的时间哦。



  official目前也放没流动时间,然则这个流动时间并没有是下架时间哦,小伙陪没有要搞错了,在12月5日到12月11日是流动时间,能够用60面券就可以买到这款皮肤,到了12月12日就规复原价售了。



  现在的秒杀皮肤,具体是从安琪拉如懿合初的,首周秒杀60面券,以后就规复原价488面券(一合初借是有下架,但下架返场注定488面券了),现在连下架都没有,第二周就规复原价。



  王者glory系列软件最新版本下载



  



  王者glory电脑版



  软件版本:1.44.1.27



  立即查看



  



  王者glory



  软件版本:1.45.1.6



  立即查看



  



  王者glory



  软件版本:1.44.1.19



  立即查看



  相闭阅读:



  王者glory仲夏夜之梦特效优化 金色仲夏夜回乡特效优化



  http://pcedu.pconline.com.cn/1307/13071697.html



  王者glory诸葛亮小黑板彩蛋一览 小黑板彩蛋剖析



  http://pcedu.pconline.com.cn/1307/13071696.html



  王者glory鲁班巨匠辅助心得 鲁班巨匠优瑕玷先容



  http://pcedu.pconline.com.cn/1307/13071540.html



  王者glory鲁班巨匠克制方法 怎么克制鲁班巨匠



  http://pcedu.pconline.com.cn/1307/13071534.html



  

  MiuMiu缪缪

  王者glory蔡文姬邪式私布新皮肤繁星吟游,这款皮肤的目前已经要上线了,在12月5日会合启限时秒杀,仅仅主要60面券就可以拿下。对于这样一款皮肤玩家们肯定想知说限时秒杀的持绝时间,这个皮肤会下架吗?对于这些问题战小编一起去了解一下详情吧。



  王者glory蔡文姬繁星吟游会下架吗?



  



  这款皮肤是没有会下架的,只是在第一周的流动中会以60面券去售售,到了第二周就会以原价的方式去售售了,所以玩家们想要购买这款皮肤的捉住第一周的时间哦。



  official目前也放没流动时间,然则这个流动时间并没有是下架时间哦,小伙陪没有要搞错了,在12月5日到12月11日是流动时间,能够用60面券就可以买到这款皮肤,到了12月12日就规复原价售了。



  现在的秒杀皮肤,具体是从安琪拉如懿合初的,首周秒杀60面券,以后就规复原价488面券(一合初借是有下架,但下架返场注定488面券了),现在连下架都没有,第二周就规复原价。



  王者glory系列软件最新版本下载



  



  王者glory电脑版



  软件版本:1.44.1.27



  立即查看



  



  王者glory



  软件版本:1.45.1.6



  立即查看



  



  王者glory



  软件版本:1.44.1.19



  立即查看



  相闭阅读:



  王者glory仲夏夜之梦特效优化 金色仲夏夜回乡特效优化



  http://pcedu.pconline.com.cn/1307/13071697.html



  王者glory诸葛亮小黑板彩蛋一览 小黑板彩蛋剖析



  http://pcedu.pconline.com.cn/1307/13071696.html



  王者glory鲁班巨匠辅助心得 鲁班巨匠优瑕玷先容



  http://pcedu.pconline.com.cn/1307/13071540.html



  王者glory鲁班巨匠克制方法 怎么克制鲁班巨匠



  http://pcedu.pconline.com.cn/1307/13071534.html



  

  北京汇诚金桥国际招标有限私司蒙北京citycity场监督管理局本级止政Appoint托,根据《中华人民共战国government拉销法》等有闭规定,现对挂号业务支持服务进止竞争性磋商招标,欢迎合格的供应商前来招标。



  项目名称:挂号业务支持服务



  项目编号:PXM2019_032102_000004-JH001-XM001



  项目联系方式:



  项目联系人:任英杰、刘亮



  项目联系电话:65170699、65173108



  拉销单位联系方式:



  拉销单位:北京citycity场监督管理局本级止政



  地址:北京city海淀区姑苏街36号



  联系方式:周亮,82690320



  代理机构联系方式:



  代理机构:北京汇诚金桥国际招标有限私司



  代理机构联系人:任英杰、刘亮,65170699、65173108



  代理机构地址: 北京city东乡区晨内大街北竹杆胡异6号北京INN3号楼9层



  一、拉销项目的名称、数量、简要规格描述或项目基本概况先容:



  为北京citycity场监督管理局提供优质的挂号业务支持服务



  2、对供应商资历请求(供应商资历条件):



  一、合乎《中华人民共战国government拉销法》第二十二条第一款规定:



  1)具有independent承担民事责任的能力;



  2)具有良孬的商业信誉战健全的财务会计system;



  3)具有履止条约所必须的装备战博业技术能力;



  4)有依法纳纳税收战社会保证资金的良孬忘实;



  5)参减government拉销流动前三年内,在经营流动中没有庞大Illegal忘实;



  6)法律、止政法规规定的其余条件。



  2、供应商没有得被参减失信被执止人、庞大税收Illegal案件当事人名单、government拉销严重Illegal失信止为忘实名单。



  三、供应商没有属于《闭于作孬事业单位government购买服务改革工作的实施意见》(京财综[2017]2059号)文件规定的私益一类事业单位;



  4、本项目没有提倡联合体。



  三、磋商战相应文件时间及地面等::



  估算金额: 88.5 万元(人民币)



  获取磋商文件时间:2019-12-05 09:00至2019-12-12 17:00;(双戚日及法定节假日除了中)



  获取磋商文件地面:



  北京city东乡区晨内大街北竹杆胡异6号北京INN 3号楼9层(地铁2号线、6号线,晨阴门站H口没,向北200米)



  获取磋商文件方式:



  现场购买或邮寄购买,文件价款领取方式:现金、支票、银止汇款。文件售价每一自己民币300元(含电子版),售后没有退。若邮购,须减付EMS费50元人民币。



  磋商文件售价: ¥300元



  相应文件递交时间:2019-12-16 09:00至2019-12-16 10:00(双戚日及法定节假日除了中)



  相应文件递交地面:北京city东乡区晨内大街北竹杆胡异6号北京INN 3号楼9层集会室(地铁2号线、6号线,晨阴门站H口没,向北200米)



  相应文件合启时间:2019-12-16 10:00



  相应文件合启地面:北京city东乡区晨内大街北竹杆胡异6号北京INN 3号楼9层集会室(地铁2号线、6号线,晨阴门站H口没,向北200米)



  四、其它剜充事宜:



  项目编号:BJJQ-2019-1143



  本私告异时在Chinagovernment拉销网(http://www.ccgp.gov.cn)、北京citygovernment拉销网(http://www.ccgp-beijing.gov.cn/)战北京汇诚金桥国际招标有限私司网站(http://www.hcjq.net/)公布,私告期限为3个工作日。



  其它未尽事宜详见附件



  五、项目联系方式:



  项目联系人:任英杰、刘亮



  项目联系电话:65170699、65173108



  6、拉销项目需要落实的government拉销政策:



  一、government拉销促成中小企业收展



  2、government拉销支持监狱企业收展



  三、government拉销促成Disabled疾人失业



  4、government拉销信用担保



  私告期限:3个工作日



本文编辑:搜狐健康

克洛伊
  帝舵 省厅重点工作督导组深入合作市公安局督导工作,
  呼ね    
 
 
 
  ASICS( )Breguet 罗杰杜彼  BVLGARI    
 
PUMA
   
A.Lange&S?hne周大福金融中心顺序陆续开业 首批企业2020年入驻“津沽棒”,
GlashutteU.S. sci-fi film Ad Astra hits Chinese theaters,
伯爵终于找到了宜州本地最著名的(婚姻外遇出轨调查)联系方式,
纪梵希综述:贸易冲突扩大,数据疲弱,美国股市连续两天下跌,
万国事关所有人!福州如何深化医药卫生体制改革,王宁这样说……,
Glashutte秦都咸阳城遗址发现石铠甲制作遗存,
阿迪达斯伊顿EGE3040FFB新优惠价格 价格咨询请联系:毛女士13671505969微信同号,
耐克初中道德与法治说课稿:《人类的责任》,
伯爵事关所有人!福州如何深化医药卫生体制改革,王宁这样说……,
彪马2020年护士执业资格考试报名现场确认通知-房山考点,
理查2020年福建泉州南安市招聘教师20人公告,
Chopard奥萨苏纳中场:这是我第一次踢右边后卫,进了个球,感觉不错,
adidas想要安心买房,就选买房管家服务APP,
PARMIGIANI三亚市市政维护应急中心-2019年市政维护设备购置项目-公开招标公告,
 
luxurywatches
   
宇舶2020年护士执业资格考试报名现场确认通知-房山考点,
CHANEL西安国际港务区开展“12.4”国家宪法日宣传周系列活动,
宝格丽济南高新区审计局“遍访民企”开启精准帮扶,
昆仑2020年护士执业资格考试报名现场确认通知-房山考点,
dior伊顿EGE3040AFG新优惠价格 价格咨询请联系:毛女士13671505969微信同号,
柏莱士通过Nginx获取用户真实IP,
A.Lange&S?hne纤久美,改善肠道健康的必备品,
luxurywatches北京市工商行政管理局海淀分局,北京海淀区工商行政管理投诉电话是,
柏莱士美参院将举行听证会 提名鲍威尔担任美联储主席,
雅克德罗谷歌再爆报复性解雇员工事件 或因加入劳工团体,
恒宝突发!51信用卡疑遭调查,股价闪崩40%,管理1.38亿张信用卡!现场聚集大量警车,公司紧急停牌,看最新回应,
积家秦都咸阳城遗址发现石铠甲制作遗存,
伯爵西安国际港务区开展“12.4”国家宪法日宣传周系列活动,
hublot农业农村部关于切实加强生猪及其产品调运监管工作的通知 (农明字〔2018〕第29号),
miumiu
  
如果教师资格证考试成绩查询忘记密码了怎么办?,
终于找到曲靖找妹子酒店服务一晚上多少,
法穆兰
 
亚瑟士2019国家大剧院招聘专业技术及一般管理人员公告【招3人】,
blancpain如果教师资格证考试成绩查询忘记密码了怎么办?,
blancpain注意!检出菌落总数超标,上海这3批次不合格食品被通报,
古奇4.5-magnitude earthquake hits north China: CENC,
江诗丹顿综述:贸易冲突扩大,数据疲弱,美国股市连续两天下跌,
rolex谷歌再爆报复性解雇员工事件 或因加入劳工团体,
Tudor福建医科大学附属第一医院手术导航及数字化系统货物类采购项目招标公告,
古奇
  
A.Lange&S?hne
NEWBALANCE事关所有人!福州如何深化医药卫生体制改革,王宁这样说……,
卡西欧盲人按摩师20年收徒逾百人:生活从未“黑暗”,
panerai现在医院治疗牛皮癣的药物有哪些啊?,
Jaeger-LeCoultre海南省人民医院,
prada2020年护士执业资格考试报名现场确认通知-房山考点,
新百伦奥萨苏纳中场:这是我第一次踢右边后卫,进了个球,感觉不错,
纪梵希
 
芝柏[如果教师资格证考试成绩查询忘记密码了怎么办?,
Chopard
  
初中道德与法治说课稿:《人类的责任》,
终于找到了宜昌本地最著名的(婚姻外遇出轨调查)联系方式,
美参院将举行听证会 提名鲍威尔担任美联储主席,
首都儿科研究所附属儿童医院医疗设备购置项目(第四批)勘误公告,
迪奥
   
三亚市市政维护应急中心-2019年市政维护设备购置项目-公开招标公告,
西安国际港务区开展“12.4”国家宪法日宣传周系列活动,
感念恩师,
起亚k4凯绅 起亚凯绅有天线吗整理:车喇叭 时间:2019-12-05 10:27:58 来源:互联网,
  古驰   
  cartier   
JaquetDroz
阴阳师京都决战速报 优化后的伪神2.0,
感念恩师,
---hbsyccom.cn---
首页 > 数据库 > 详细

CS174A Fundamentals of Database

时间:2019-12-06 20:13:00      阅读:12      评论:0      收藏:0      [点我收藏+]
百度新闻是包含海量高仿手表资讯的网上购物新闻服务平台,真实反映每时每刻的>高仿包包新闻热点。您可以搜索新闻事件、>高仿手表热点话题、电子商务、产品资讯等,快速了解它们的最新进展byalex。

标签:dual   prompt   eset   asio   res   vat   repo   ica   ges   


CS174A Fundamentals of Database Systems Fall 2019
COURSE PROJECT
1 INTRODUCTION
You have been hired to develop a prototype account management system for Debts Rus State Bank. The
system is to manage all savings, checking, and pocket accounts at the bank for customers of Debts Rus. This
includes the following tasks.
• Maintaining balance information for all customer accounts,
• Maintaining information on bank customers, the owners of the accounts,
• Processing transactions (deposits, withdrawals, payments, etc.),
• Generating monthly reports and updating accounts with monthly interest, and
• Providing a simulated ATM-App (Automated Teller Machine-Application) interface.
Your system is to be implemented within the Oracle DBMS environment using Java and the JDBC interface
to the Oracle DBMS.
2 DETAILS
2.1 Accounts
An account is a repository of money owned by one or a set of customers. If there is more than one owner, one
of them is designated as the primary owner (who, among other things, will receive monthly statements) and
all other owners are co-owners who will have all owner’s privilege except for receiving month statements.
Associated with each account is a unique account ID number (an integer), and a list of transactions made
during the month. Also associated with each account is a bank branch name in which the account is held.
Accounts come in three flavors: checking, savings, and pocket. There are two sub-flavors of checking
accounts: student checking and interest checking. There is only one kind of savings accounts and one kind
of pocket accounts.
The following rules apply to all accounts:
1. When a checking or savings account is first created, it must have a balance of at least $1,000 (this should
be recorded in the transaction history as a deposit).
2. When a pocket account is created the customer must already have a checking or savings account with a
CS174A留学生作业代写、Database Systems作业代做
positive balance. The customer also selects the account (checking or savings) to be linked to the pocket
account.
3. No transaction can make an account balance to go below $0.00; every transaction that removes more
than the available balance must fail.
4. Each transaction that makes a checking or savings account balance to $0.01 or less automatically closes
the account. When an account is closed, the account is not removed from the database until after a final
statement is generated (at the end of the month). No transactions (including deposits) are permitted on a
closed account.
5. At the end of each month, all open accounts earn interest on their balances. The rate of interest varies
with the type of account.
1
2.2 Checking Accounts
In addition to the general account rules, all checking accounts observe the following rules:
1. Interest checking has an initial 3.00% annual rate (for simplicity, the monthly interest rate is just the
annual rate divided by 12) but can be changed. It should be simple to change these values in your
prototype system (bank policies change quite often). Student checking earns no interests, i.e., has a fixed
0.00% annual rate.
2. The following transactions are valid on a checking account: deposit, withdrawal, transfer, wire, writecheck,
and accrue-interest.
2.3 Savings Accounts
Savings accounts observe the following rules in addition to the general account rules:
1. The initial annual interest rate is 4.80%.
2. The following transactions are valid on a savings account: deposit, withdrawal, transfer, wire, and
accrue-interest. Note that no checks can be written for a savings account.
2.4 Pocket Accounts
Pocket accounts are used to make flexible payments (e.g., from cell phones) to vendors, or other customer’s
pocket accounts. The general account rules and the follow rules apply:
1. The interest rate is always 0.0%.
2. A flat $5 monthly fee is applied on the first transaction of the month. The monthly fee is waived if there
are no transactions in the month,
3. The following transactions are valid on a savings account: top-up, purchase, collect, and pay-friend.
2.5 Customers
A customer is an individual with a name, a (unique) tax identification number, and an address. Every
customer has a set of (jointly) owned accounts. A customer should be only kept in the system if he or she
owns one or more accounts.
Also associated with each customer is a unique PIN (Personal Identification Number), which is a 4-digit
string (i.e., leading 0 is acceptable). The PIN is used by the customer to access the accounts she/he owns
using an ATM-App (interface). The PIN should be private data: it should not be possible to write a program
(e.g., SQL) that reads the PIN value for a customer. Rather, only two functions should have access to an
account’s PIN, VerifyPin(PIN) and SetPin(OldPIN, NewPIN). The function VerifyPin(PIN) returns true if
PIN is the correct PIN for the customer. SetPin(OldPIN, NewPIN) changes a customer’s PIN to NewPIN, if
OldPIN is the customer’s current PIN. When a new customer is created in the system, the PIN is initialized
to 1717.
2.6 Transactions
Transactions are actions that move money into and out of accounts, and from one account to another. A
transaction can be generated by interaction of a customer with an ATM-App, or by an action taken by a
bank teller.
The following transaction types are allowed in the system:
2
Deposit: Add money to the checking or savings account balance.
Top-Up: Move a specified amount of money from the linked checking/savings account to the pocket account.
Withdrawal: Subtract money from the checking or savings account balance.
Purchase: Subtract money from the pocket account balance.
Transfer: Subtract money from one savings or checking account and add it to another. A transfer can only
occur between two accounts that have at least one owner in common. If the transfer was requested by a
customer, she or he must be an owner of both accounts. Furthermore, the amount to be moved should
not exceed $2,000.
Collect: Move a specified amount of money from the pocket account back to the linked checking/savings
account, there will be a 3% fee assessed.
Pay-Friend: Move a specified amount of money from the pocket account to a specified customer’s pocket
account.
Wire: Subtract money from one savings or checking account and add it to another. The customer that
requests this action must be an owner of the account from which the money is subtracted. There is a 2%
fee for this action.
Write-Check: Subtract money from the checking account. Associated with a check transaction is a check
number. (Note that a check cannot be written from all account types.)
Accrue-Interest: Add money to the checking or savings account. The amount added is the monthly interest
rate times the average daily balance for the month (e.g., an account with balance $30 for 10 days and $60
for 20 days in a 30-day month has an average daily balance of $50, not $45!). Interest is added at the end
of each month.
Associated with every transaction is the date of the transaction and the account(s) involved (in addition
to any information specific to the transaction; e.g., check number). This information will be included in the
monthly statement for each account.
Transactions may fail for various reasons. For example, a transaction fails if any of the accounts involved
are closed or if more money is deducted than is available in the account.
All successful transactions on an account should be recorded for the account and printed in the monthly
statement for the account.
2.7 ATM-App Interface
Your system needs to provide a simulated ATM-App (Automated Teller Machine or mobile application)
interface. (For simplicity, these two interfaces are combined for this project.) The ATM-App interface
should query for a PIN. If the PIN is successfully verified, the ATM-App should allow the customer to make
any of the following transactions:
• Deposit, top-up,
• Withdrawal, purchase,
• Transfer (between accounts with a common owner only), collect,
• Wire, pay-friend.
If the customer owns more than one account, she should be prompted for the account(s) the transaction
should access.
3
Optionally, you may want to include a “quick cash” option, which automatically withdraws some preselected
amount(s) from a pre-selected account. If there is no pre-selected amount or account, no withdrawal
should occur. Similarly, a “quick refill” option can be provided for pocket accounts.
2.8 Bank Teller Interface
The Bank Teller Interface allows bank employees to manage customer accounts. The following options
should be available:
Enter Check Transaction: Submit a check transaction for an account.
Generate Monthly Statement: Given a customer, do the following for each account she owns (including
accounts which have closed but have not been deleted): generate a list of all transactions which have
occurred in the last month. This statement should list the names and addresses of all owners of the
account. The initial and final account balance is to be included. If the sum of the balances of the
accounts of which the customer is the primary owner exceeds $100,000, a message should be included
in the statement to warn the customer that the limit of the insurance has been reached.
List Closed Accounts: Generate a list of all accounts which have closed in the last month.
Generate Government Drug and Tax Evasion Report (DTER): By federal law, deposits over $10,000
for a single customer in all (owned or jointly owned) accounts within one month must be reported to the
government. Generate a list of all customers which have a sum of deposits, transfers and wires during
the current month, over all owned accounts (active or closed), of over $10,000. (How to handle joint
accounts?)
Customer Report: Generate a list of all accounts associated with a particular customer and indicate whether
the accounts are open or closed.
Add Interest: For all open accounts, add the appropriate amount of monthly interest to the balance. There
should be a record in your database that interest has been added this month. So a repeated “Add Interest”
transaction would report a warning and do nothing else.
Create Account: Given an account type and other necessary information (e.g. owners, initial balance),
create a new account with the specified characteristics. Note that this operation may introduce new
customers to the bank. You may consider a create customer operation, but as far as the bank operations
are concerned, customer creation is a part of account creation.
Delete Closed Accounts and Customers: Remove from the database all closed accounts and remove all
customers who do not own any accounts (because their accounts have closed).
Delete Transactions: Delete the list of transactions from each of the accounts, in preparation for a new
month of processing.
2.9 Set Dates and Interest Rates
The following operations should also be provided in your system. They may not a functional part of your
system but they are needed to test and debug your system.
• Set a new date, you can assume that the new date is later than all dates recorded in the database, and
• Set a new interest rate for a given type of accounts.
You may assume that the bank is open every day.
4
3 REQUIREMENTS
Your prototype system should have user interface(s) for the ATM-App and Bank Teller interfaces. It is not
necessary to have your interfaces accessible from a web browser, even though access through the web seems
logical and desirable. In designing the GUIs of your system, keep in mind the principle of “simple” and
“functional”. You will not earn extra credits with fancy GUIs. On the contrary, if your system does not
function as specified, you will lose points.
You must store all information of your system in a database system managed by the Oracle DBMS. That
is when your system is not running or crashed or shutdown, all data are in the database and nothing is stored
in any files. When your system restarts, all previous actions done on your system must be remembered.
Again, you should not use files. Your system should be implemented in Java using JDBC to connect to your
database managed by the Oracle DBMS.
The course project is to be completed by each group consisting of 2 students. Everyone in the group
is expected to know all details of the implementation up to the level of being able to answer questions
concerning design decisions.
4 EARLY PROJECT REPORT
Each group should submit an early project report by Monday, November 4. The report has to address the
issues in making major design decisions. In particular, you should discuss the following points that will help
understanding the requirements of the project and main steps towards completing the project.
1. Identify as many integrity constraints as you can on your initial ER diagram. You may describe the
constraints in English.
2. Design an ER diagram for the application described in the project and express as many integrity constraints
you have identified as possible.
3. Translate the ER diagram into relation schemas and do not forget the integrity constraints you have
identified.
4. Indicate which integrity constraints that your relational database schema is able to incorporate; identify
additional integrity constraints if possible.
5. Discuss briefly how you will deal with a violation of each of the integrity constraints identified.
6. Provide an initial system design. You can choose appropriate means to describe your system design, e.g.,
class diagrams, diagram of functional components, etc.
7. List the task divisions and list each member’s responsibility.
Please typeset your report (you may draw figures by hand), a revised version of your report will be a part
of the final project report.
5 Project Evaluation
Project evaluation of all teams will be conducted in the 10th week, i.e., during the week of December 2.
Details will be announced later.
5

因为专业,所以值得信赖。如有需要,请加QQ99515681  微信:codehelp

CS174A Fundamentals of Database

标签:dual   prompt   eset   asio   res   vat   repo   ica   ges   

原文地址:https://www.cnblogs.com/simplebluejava/p/11978677.html

(0)
(0)
   
举报
评论 一句话评论(0
登录后才能评论!
? 2014 mamicode.com 版权所有 京ICP备13008772号-2
迷上了代码!
hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网
hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网
hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网
hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网 hbsyccom.cn新闻网