Create sql statement, Look at your Book how they have done.

Create sql statement

Assignment Help PL-SQL Programming

Reference no: EM131453992

The Final Case study must contain.

1. Problem Statement

2. Your User Requirements/Views

3. Information Model: Must contain Pk,Ak,FKetc identified. (DBDL - your model must show Functional dependency with arrows marked) Look at your Book how they have done. Mention, Fully Functional Dependency and No Transitive Dependency

4. Normal Form ( You need mention It satisfied 1 NF, 2 NF, 3NF in each information model)

5. ER Model

6. Tables implemented and the Create SQL statement Copied in the report

7. Also, I need to see sample of insert statements for each table.

8. Minimum, One Sql View for your requirement defined and copied in to the report (This

9. Minimum, One update statement for an update

10. All your requirements must have actual sql queries and you need 5 of them : Look below for sql query requirements. Actual results must be shown in the report. You do not need to copy all the rows show few rows.

Details
Tables implemented with

- proper data type,
- identity specification for non natural primary key
- Primary key defined
- index defined for access - unique and regular depending on the requirement
- Data loaded
- An Update query to update column values.
One SQL View defined for a table or combination of tables
Sql Scripts for your results: All the User requirement must have equivalent Sql.
- You must have One query with minimum of 3 table joins..
- One query must use a function such as sum, Avg etc... with Group By
- one query with Order By.

Attachment:- Manuelitos Shoe Shop.rar

Reference no: EM131453992

Questions Cloud

How well is the solution working : What are the advantages and/or disadvantages of each alternative?What is the problem?What are the alternatives?

What is the distance of this part from the baseline : Triangulation computations are to be used to determine the distance of parts moving on a conveyor.

Key differences between the juvenile and adult systems : Write a 1,050- to 1,400-word paper summarizing the key parameters of the juvenile justice system in the United States

Would you outsource key government services : Would you outsource key government services? What ways, if any, would you suggest to streamline the way government does business?

Create sql statement : Look at your Book how they have done. Mention, Fully Functional Dependency and No Transitive Dependency - Tables implemented and the Create SQL statement Copied in the report

Provides an opportunity to integrate and reflect : The final paper provides you with an opportunity to integrate and reflect on what you have learned during the class.

Develop a cause and effect diagram : Consider some organizational procedure with which you are familiar in your company that manifests some chronic problem.

What was the true fraction defect rate : An inspector reported a total of 18 detects out of a total batch size of 250 parts. On closer examination.

Provide the critique of her recommendation of the eu project : In the Observations section, you will also provide the critique of her recommendation of the EU project to the Pharma Heal Corporation's Board.

User Account

All Pages