Ask a question from expert

Ask now

Project Description and Teamwork

19 Pages3277 Words309 Views
   

Added on  2019-10-18

About This Document

Student name: final term project: week 7 Student name: final term project: week 7 Contents Account of who did what individual work: detail each team-members efforts throughout the project 2 Problems encountered 2 How your approach to the project changed 2 Project limitations or issues 3 Future work / improvements planned for future releases 3 Conclusion 3 References 4 The course material, video lectures and lecture notes. 4 Final project 4 INTRODUCTION 4 QUERY ROADMAP 5 ER-DIAGRAM 6 TRANSLATION METHOD 6

Project Description and Teamwork

   Added on 2019-10-18

BookmarkShareRelated Documents
Student name: FINAL TERM PROJECT: WEEK 7
Project Description and Teamwork_1
ContentsAccount of who did what individual work: detail each team-members efforts throughout the project...............................................................................................................................................................2Problems encountered..........................................................................................................................2How your approach to the project changed over time, and why it changed.........................................2Project limitations or issues...................................................................................................................3Future work / improvements planned for future releases....................................................................3Conclusion.............................................................................................................................................3References.............................................................................................................................................4The course material, video lectures and lecture notes..........................................................................4Final project...........................................................................................................................................4INTRODUCTION.....................................................................................................................................4QUERY ROADMAP.................................................................................................................................5ER-DIAGRAM.........................................................................................................................................6TRANSLATION METHOD........................................................................................................................6RELATIONAL SCHEMA............................................................................................................................7DATA DICTIONARY.................................................................................................................................8TABLE CREATION...................................................................................................................................9RECORD INSERTION.............................................................................................................................12SQL QUERIES........................................................................................................................................161 | P a g e
Project Description and Teamwork_2
Account of who did what individual work: detail each team-members efforts throughout the project<Member 1 name>: completed the designing of the scenario, case study and created the ER-diagram. Carried out a thorough study and analysis to create the structure which meets all possible requirements. < Member 2 name>: studied the ER-diagram and then created the schema and data dictionaryfor further completion of the project.< Member 3 name>: created the database using the schema and data dictionary. Then populated the tables with records and queried them as per the query roadmap.Problems encounteredSince we all followed the lecture notes and video lectures, we did not face any problem in completing the project. The topics covered in the lectures were very helpful in completing thecourse final term project. How your approach to the project changed over time, and why it changedOur approach was to simply design the scenario into the ER diagrams and then into the tables. But with time we realized that this was not the right way to proceed. So we tried to breakdown the process into following steps:1.Requirement gathering and analysis2.Logical diagram of the scenario3.Verification of the diagram2 | P a g e
Project Description and Teamwork_3
4.Translation of the diagram into a schema5.Creation of data dictionary for the schema6.Creation of tables with appropriate attributes.7.Populating tables with relevant data8.Querying the database to get useful results.That’s how we proceeded in the process and then towards a successful completion of the process.Project limitations or issuesThe limitations of the project are that:1.There are lesser tables and contain lesser detailed information.2.The database is less secure as there is no role based use.3. No use of username and passwords.4.The database is not present on a secure server and is prone to damage.5.There is scope to add new and detailed attributes which has not been utilized.Future work / improvements planned for future releasesIn future, we would like to add more tables to the database where we can even store all the detailed information about the items, their stock, employees, partners, promotions etc. we caneven use the process of data mining to extract useful patterns that can be used in the process of business improvements and business growth. Moreover, we can add the security feature and role based access to make the data more secure and guard against theft, damage or unrequired edits or additions. We can even create view so that the actual data is never affected. Conclusion3 | P a g e
Project Description and Teamwork_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
ER Modelling
|42
|8092
|1

Term Project ERD
|7
|684
|295

Accounting Information System (AIS) Assignment
|16
|1125
|185

DATABASE CONCEPTS CHALLENGE UK
|34
|5584
|38

Enterprise Data Warehouse Optimization
|10
|1285
|23

Database Systems for Toulis Construction: Diagrams, SQL Queries, Security Measures and Future Improvements
|23
|2197
|298