Telah Dianugerahkan

Oracle Job by kiba85

(UOD) bookstore database design. NEEDED AS SOON AS POSSIBLE.

• A 1-2 page introduction and background of your related domain – Consult at least 3

references and cite them clearly in your text. This should be an in-depth analysis of your

domain not your proposed system.

• A 1-2 page External Schema of your System – This needs to be at least one full page,

thoroughly describe the entities and types of activities in your system and how they relate

to the UOD. Include your general sentence and sentences about each of your entities.

• A 1 page E-R diagram of your proposed system – Be sure to include min,max cardinality,

on all relations.

• A 1 page diagram of an unnormalized translation of your E-R model into a relational

model.

• A 1-2 page explanation of your normalization process. Clearly show any functional

dependencies or anomalies. Explain also your selection of primary keys and justify the use

of any synthetic keys. Explain how knowledge of processes within your UOD helped you

to model certain aspects of your system. Include at least one 1:1 relationship and justify.

At this point you must include at least one table which will hold codes. You may have as

many code tables as required for example (States, Degrees, etc.)

• A 1 page diagram of your normalized relational model.

• A data dictionary of your final model. For each table list every column and indicate

primary key. For each column indicate datatype, min,max attribute cardinality, brief

natural language description

o For numeric (non coded) and date attributes describe normal and threshold ranges

o Describe the value-set for enumerated or coded attributes or for foreign keys

indicate the table and column to which the attribute is related.

o For synthetic keys indicate the name of the sequence.

• Create a script called [url removed, login to view] and include this script at this point. The [url removed, login to view] script

should contain all of the DDL statements required to create the tables, views, and

sequences within your system. This script should also include all of the INSERT

statements to initially populate your coded tables.

• Run your script and include actual screen prints or buffer of your Oracle Session. This

script must run with no errors and correctly implement your relational model. It must be

clearly commented.

• Create at least one view. Include 1 page showing the SQL required to create the view.

Include a 1-paragraph justification for creating this view and describe how it will be used.

• On a separate page for each, describe in natural language 5 types of queries you may wish

to execute against your database. Follow this by the actual SQL syntax of the query and a

screen shot or buffer of an Oracle Session in which you execute this query. Include the

results of the query. Each query must run without error and produce the expected result.

o At least one query must use an aggregate function with GROUP BY and HAVING.

o At least one query must involve a sub-query.

o At least one query must involve a left-join.

• On a separate page for each, describe in natural language 2 types of updates you may wish

to execute against your database. Follow this by the actual SQL syntax of the update and a

screen shot or buffer of an Oracle Session in which you execute this update. Query the

row(s) before and after the update to show that the update produces the desired result.

• A 1-page glossary (dictionary) of at least 10 terms within your domain.

• A 1-page correctly formatted references page for the 3 or more references you cited in your

introduction.

Kemahiran: Oracle

Lihat lebih lanjut: use of sequence diagram, the sequence diagram, system sequence diagram example, sql function in oracle, sequences diagram, sequence diagram with example, sequence diagram or, sequence diagram include, sequence diagram how to, sequence diagram explanation, sequence diagram example, schema update, oracle sql codes, oracle codes sql, key selection, it degrees, how to sequence diagram, how to design sequence diagram, how to design a sequence diagram, how to create sequence diagram, how to create a sequence diagram, group o, functional sequence diagram, example of sequence diagram, example of a sequence diagram

Tentang Majikan:
( 0 ulasan ) United States

ID Projek: #1599556

1 pekerja bebas membida secara purata $30 untuk pekerjaan ini

syscomsolutions

Hired by the Employer

$30 USD dalam sehari
(1 Ulasan)
2.0