CSE3055-Final Project

40.00 $

Category:
Click Category Button to View Your Next Assignment | Homework

You'll get a download link with a: . zip solution files instantly, after Payment

Description

5/5 - (1 vote)

 

Project

Step 1   Proposal 0.9 pts  
 

Determine a practical (applicable to real business) database project that you want to implement. Specify the scope of your project. Give a name to your project.    
You can study in groups. At most two members are allowed in a group.    

 

 

 

 

Submit a report (max 1 page A4) and take the approval of your lab instructor before beginning to study on your project.

±     You may take the approval via office hours or e-mail.

   
Step 2   Requirement analysis & Conceptual database design 3.0 pts  

 

  • Submit a report (2-3 pages A4) that contains data and requirement analysis of your database.
    • Attach the documents that you have collected from the company.
  • Create a diagram (with E/R studio, Microsoft Visio or a similar product) that shows the entities, attributes and relationships in your database using Entity-Relationship Model.
    • The diagram should obey the rules of Entity-Relationship drawing conventions.
    • Attach your ER diagram.

 

Step 3 Requirement analysis & Conceptual database design & Logical database design and mapping & Physical design and database implementation 12.9 pts  

 

  • Develop a Microsoft SQL Server 2014 database with the following characteristics:
    • The name of the database should be same as your project name in capital letter format.
    • Create at least 6 tables in your database.
      • Each table should be normalized to third normal form.
      • Populate your data to an acceptable amount. (Each table should contain at least 10 records.)
      • Use indices, uniques, identities, check constraints, defaults, computed columns and triggers where necessary. Be sure to have at least one from each.
      • Use the most appropriate data types for the fields.
    • Create at least 4 views in your database. o Do not simply write “SELECT… FROM…WHERE…” statements.
    • Create at least 1 trigger in your database.
  • Create at least 4 stored procedures in your database.
    • You may create them for insertions, updates, deletions or specific business rules.
    • Try to do different jobs in each procedure.
  • Submit a detailed report:
    • Explain what your database project is about o 1 paragraph or half of a page is enough
    • Write about your data and requirements analysis
    • If necessary, update the E/R diagram which you created in the previous step.
    • Explain each table and indicate why you used:
      • Columns, Data types used (and why, if needed)
      • Primary key, Foreign keys, Relationships Constraints, Indices
± Explain Triggers and Stored procedures    
±

 

 

 

 

Explain Views    
Step 4   Web interface

 

  • Create a user friendly web interface for your database.
  • There will be a demo session for every project.
    • Demo sessions will be arranged and announced later.

 

  • Project-oxbwqc.zip