Chinaunix首页 | 论坛 | 博客
  • 博客访问: 672425
  • 博文数量: 487
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 4936
  • 用 户 组: 普通用户
  • 注册时间: 2018-07-05 13:59
个人简介

ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291

文章分类

全部博文(487)

文章存档

2024年(2)

2023年(37)

2021年(151)

2020年(37)

2019年(222)

2018年(38)

我的朋友

分类: Oracle

2019-10-28 16:19:47

choose two

Examine this business rule:

Each studert can work on mutiple projects and eath project can have multiple students

You must desion an Entity Relationsep (ER) model for optional data storage and allow generating reports in this format:

STUDENT_ID  FIRST_NAME  LAST_NAME  PROJECT_ID  PROJECT_NAME  PROJECT_TASK

Which two statements are true?

A) An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID,which is the foreign key linked to the STUDENTS and PROJECTS entities.

B) The ER must have a many-to-many relationship between the STUDENTS and PROJECTS entities that must be resolved into 1-to-many relationships.

C) PROJECT_ID must be the primary key in the PROJECTS eitity and foreign key in the STUDENTS entity.

D) The ER must have a 1-to-many relationship between the STUDENTS and PROJECTS entities.

E) STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.

Anaswer:AB

(解析:这道题涉及到调优问题,应用中经常出现多对多之间的关系,如何解决 STUDENTS and PROJECTS 两张表的多对多关系,可以创建一个中间表,这个表包含那两张表的主键列,同时是另外两张表的外键约束。通常这个表建成索引组织表。)

阅读(971) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~