Concluído

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.

Habilidades: Desenvolvimento de Banco de Dados, Programação de Banco de Dados, Administração de Bancos de Dados, Oracle, Design UML

Veja mais: 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

Acerca do Empregador:
( 0 comentários ) Singapore, Singapore

ID do Projeto: #20419637

Concedido a:

abdulrehman57

Hi There, My name is Abdul Rehman. I have much experience to design & develop the database and also design the ER Diagram by using scenario or Case Study. My main working area to design and develop the Database Mais

$30 SGD em 3 dias
(17 Comentários)
4.8

5 freelancers estão ofertando em média $23 para esse trabalho

rainbow

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

$21 SGD in 7 dias
(9 Comentários)
3.4
ProgramICO

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 in 7 dias
(0 Comentários)
0.0
ExpertSoul

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 em 1 dia
(0 Comentários)
0.0
techlinesols6

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 Mais

$21 SGD in 7 dias
(0 Comentários)
0.0