Case study: The Final Case study must contain.
1. Problem Statement
2. Your User Requirements/Views
3. Information Model: Must contain Pk,Ak,FK etc 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
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.
• Actual Results - Copied and pasted