Database Structure Requirements (1 page) What requirements do you have for your
ID: 440363 • Letter: D
Question
Database Structure Requirements (1 page) What requirements do you have for your database? You have already specified which platforms you are going to use in the first section of the document, so there's no need to repeat that here. You do need to answer the following questions, however. How many tables will your database include? What are the primary keys for each? Which fields are included for each? What are the datatypes and field sizes for each field? What validation will be done at the database level? Are you setting up any table relationships? Include a chart showing the tables and their fields; you can create it in Visio or by building the table in Access and getting a screenshot. Note that a chart by itself does not fulfill the requirements, and hand-drawn sketches are not acceptable in your final project. Like the previous section, this section will require substantial reworking of your earlier submission. You have had some time to reflect and learn new possibilities, and now is the time to look at the overall picture of the site.Explanation / Answer
A database schema refers to the organization of the data to create a blue print in order to construct a useful database for an organization. It contains a set of formulas representing the integrity constraints and all these formulas are expressible in the same language. The conceptual schema which is created first is transformed in to explicit mapping and database schema and this describes in which way real world entities are modeled in database. In oracle database system the schema has different connotation. Schema is also used to refer graphical depiction of the database structure and these are generally stored in a data dictionary. There are four levels of database schema and they are Conceptual schema Logical schema Physical schema Schema object There are some requirements for the schema integration and these requirements influence the detailed structure of schema that are produced. These are given below: Completeness: Database schema should be provided with all the information available in the source data. Minimality: Database schema is not ideal in the case if any elements of database schema are dropped. Overlap preservation: Each of the overlapping elements which are specified in the input mapping are also in a database schema relation. Normalization: In the database schema, independent entities and relationships in the source data should not be grouped together in the same relation. Source specific schema elements and overlapping schema elements should not be grouped. Extended overlap preservation: Source specific elements associated with a source’s overlapping elements are passed through the database schema.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.