Identify all functional dependencies

Assignment Help Science

Reference no: EM133351735

Questions:

1. Create a single listing all attributes/fields above, and any other fields necessary for implementation (if any)

2. Identify all functional dependencies

3. Normalize database to 3NF

4. Think about and determine what all the appropriate attributes/fields/columns/legal values required in these tables should be to adequately support the scenario described above, prior to any coding

5. Implement the database using MS Access or Oracle 19c software (whatever you have up and running) subject to the following conditions:

Tables must be fully created using separate SQL statements (table name, field names, data types, field size, primary and foreign keys, etc.). note: special care must be paid to the order in which tables are created due to foreign key references. Creating tables in the incorrect order will result in error messages. Generally, starting with tables without foreign keys in them will facilitate the creation of later tables. You must dedicate time to thinking about the order in which tables must be created. Each SQL statement must be saved as a separate query named Table_NameTable, e.g., UsersTable, TicketSalesTable, etc. Careful attention must be paid to spelling. When used as foreign keys, each field name is modified by adding FK to it to differentiate it from the field in the parent table. For example, if the field Field1 is used as a foreign key, it is called Field1_FK in the child table.

6. Create an ERD (Entity Relationship Diagram)

Reference no: EM133351735

Questions Cloud

Vehicle acquisition tax reduction or exemption : Which of the following vehicles is certainly eligible for Vehicle Acquisition Tax reduction or exemption?

Explain and discuss de beauvoirs concept of the other : De Beauvoir introduces her concept of "the other" (perhaps one of the most famous philosophical concepts relating to gender in the history of philosophy!!!).

Initial impressions regarding clearance rates : What were your initial impressions regarding clearance rates? How do the resources a department has influence an investigation?

Excessive progressive tax rate : Because it is fairer than the excessive progressive tax rate, the full progressive tax rate is commonly introduced in many taxation systems in many countries.

Identify all functional dependencies : Create a single listing all attributes/fields above, and any other fields necessary for implementation Identify all functional dependencies

Determine the elementary operations that can be derived : Determine the elementary operations that can be derived - Represent the operation of the simple switching circuits shown in FIGURE 1 by a truth table

Basic function of tax law : Which of the following option are the basic function of tax law? Which of the following tax is the regular tax revenue of the local government?

What accounts in statement of income : What accounts in the statement of income and the statement of financial position

Compare and contrast different theories of religion : Compare and contrast three or more different theories of religion Demonstrate the sharp distinctions and similarities between the theorists you have chosen.

User Account

All Pages