В работе

Databases - Entity Relationship Diagram (ERD) & Data Dictionary

Improve on existing ERD from Case Study 1, full details attached. Only have to complete part 1 and 2 from Case Study 2.

Part 1

a) Create and submit the ERD for this database that you are going to use as the basis of your implementation.

b) Include a one or two paragraph explanation as to the changes you have made to the ERD on the basis of your feedback from the ERD done in Case Study 1 and/or as a result of having to support the new functionality and views described.

c) Show the relational schema in 3NF that will be the basis of your implemented design. Show your relations using the following convention: RELATION_NAME (PrimaryKey, Attribute, Attribute, … ForeignKey)

Part 2: Data Dictionary

Create a data dictionary for your database. This should include:

a) For each table: a definition of each column (attribute), consisting of the column name, brief description of what it represents, its data type and size, domain (allowable values), any default value, whether it is required, whether unique, and any constraints (primary key, foreign key).

Use the data types available in Oracle.

b) For each of the columns that is a foreign key, give the appropriate referential integrity rules (i.e. the “on delete…. ; on update“ etc actions that should apply when the corresponding primary key is altered). The appropriate action should be included whether or not there is a statement in Oracle to implement it.

c) Any business rules (enterprise constraints) that should apply to the database that haven’t already been covered by cardinality or participation constraints.

Note that your data dictionary must be consistent with your ERD and schema.

Квалификация: Разработка баз данных, Программирование баз данных, Управление базами данных, Oracle, Проектирование с UML

Показать больше entity relationship diagram catering services, example entity relationship diagram catering, entity relationship diagram creator, entity relationship diagram sas, aurion entity relationship diagram, sip entity relationship diagram, entity relationship diagram airline case study, entity relationship diagram airline reservation system, entity relationship diagram project, entity relationship diagram gymnasium booking system, entity relationship diagram case study, entity relationship diagram cinema, entity relationship diagram catering order system, entity relationship diagram catering system, entity relationship diagram design projects, entity relationship diagram dormitory, entity relationship diagram freelancer, entity relationship diagram hospital management system, entity relationship diagram job company, jobs entity relationship diagram

О работодателе:
( 1 отзыв ) Singapore, Singapore

ID проекта: #20419637

4 фрилансеров(-а) в среднем готовы выполнить эту работу за $21


I am a database designer and system analyst I can prepare E-R diagram Please send details of work

$21 SGD за 7 дней(-я)
(9 отзывов(-а))

Hello I am a senior developer so i can do it very easily if you want. Contact me right now i am ready to start this project for you. Low cost and high quality result reply to discuss more about this project

$21 SGD за 7 дней(-я)
(0 отзывов(-а))

Hello I'm expert Content writing,UML design, report writing with experience in technical writing. I can help you to finish this project with great quality. Regards Relevant Skills and Experience.

$21 SGD за 1 день
(0 отзывов(-а))

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th Больше

$21 SGD за 7 дней(-я)
(0 отзывов(-а))