(UOD) bookstore database design. NEEDED AS SOON AS POSSIBLE.
&acirc;€¢ A 1-2 page introduction and background of your related domain &acirc;€“ 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.
&acirc;€¢ A 1-2 page External Schema of your System &acirc;€“ 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.
&acirc;€¢ A 1 page E-R diagram of your proposed system &acirc;€“ Be sure to include min,max cardinality,
on all relations.
&acirc;€¢ A 1 page diagram of an unnormalized translation of your E-R model into a relational
&acirc;€¢ 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.)
&acirc;€¢ A 1 page diagram of your normalized relational model.
&acirc;€¢ 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.
&acirc;€¢ 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.
&acirc;€¢ 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
&acirc;€¢ 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.
&acirc;€¢ 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.
&acirc;€¢ 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.
&acirc;€¢ A 1-page glossary (dictionary) of at least 10 terms within your domain.
&acirc;€¢ A 1-page correctly formatted references page for the 3 or more references you cited in your