- 1、本文档共12页,可阅读全部内容。
- 2、有哪些信誉好的足球投注网站(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
关系数据库outcome4A答案
Assessment task
4 Part A
Outcomes(s) covered 4 Implement structures and manipulate data in a relational database management system
Assessment task instructions
Before commencing the assessment your attention is drawn to the following:
‘The assessor reserves the right to reject any material that is not deemed the work of the candidate. Further, any material from another candidate that has been used for copying, will also be rejected.’
Assessment Conditions
The development for this outcome is combined with outcomes 2, 4B and 5 to form a complete project.
The use of course material and candidate’s own research notes are permitted.
Candidate Instructions
You are required to implement a relational database from a supplied data model, dictionary definitions, entity descriptions and data. A checklist is provided to ensure that all relevant performance criteria are completed.
Candidate’s Assessment Evidence
The candidate will produce evidence demonstrating proficiency in the use of DDL within an RDBMS covering the following items:
Creating, copying, altering and deleting tables
Creating views and synonyms同义词---oracle
Creating primary and foreign keys
Creating unique and non-unique indexes
Manipulating read, insert, modify and delete privileges权限
Evidence should be in the form of hard copy of the DDL, output from the data dictionary (eg output from Describe tablename), data from user_indexes, other dictionary views and spooled output.
A checklist is provided to ensure that all relevant performance criteria are completed. Please ensure you obtain a checklist from your tutor before starting the assessment, Fill in your name, candidate number, date of submission and completed tick boxes and return the checklist as part of your evidence.
Outcome 4A (DDL) - Questions
Note:
Ensure that you have completed Activity 28 before starting this assessment
Using the provided data model, dictionary definitions and entity descriptions answer all the following questions. Dat
您可能关注的文档
- 青岛版一年级数学上册《快乐的校园-0的认识》PPT课件.ppt
- 小学教学设计稿纸.docx
- STTH1003SB-TR;STTH1003SG-TR;中文规格书,Datasheet资料.pdf
- EMIF02-USB03F2 免费下载.pdf
- 如何防范中学生在课间活动中的意外伤害.doc
- 体育课安全教育(共12张PPT).ppt
- 9_张衡.ppt
- Linux Kernel for Android 4.0_初稿.pdf
- 《日出》教学设计.doc
- 2.《让家更美好》教学课件.ppt
- 专题05 质量守恒定律的应用(原卷版)(广东).docx
- 信息必刷卷05(武汉专用)(原卷版).docx
- 第十一单元 盐 化肥A卷(解析版).docx
- 第九单元 溶液B卷-2023-2024学年九年级化学下学期同步测试优选卷(人教版)(原卷版).docx
- 第5节物质的转化(第2课时)——2022-2023学年浙教版九年级上学期科学.docx
- 第4节简单机械(第5课时)—2022-2023学年浙教版九年级上学期科学.docx
- 专题07 历史解释类选择题(含答题技巧,题型专练100题)(原卷版).docx
- 选择专项02 有机高分子材料的分类及鉴别共30题-2024年中考化学常考点专题必杀题(广东专用)(解析版).docx
- 热点专题08 政治篇(国际部分)(解析版).docx
- 实验探究专练17(工业流程30题)-2023年中考化学常考点专题必杀题(深圳专用)(解析版).docx
文档评论(0)