Critically compare different data models such as Hierarchical, Network, Relational and justify which data model best fits the scenario
Prepare a power point presentation to critically discuss the benefits and limitations of different database technologies such as distributed database, data warehouse, Data mining, Multimedia database.
Analyze different approaches such as Top down and Bottom up which can be used to design a database and justify how these approaches relate to database design
2.1 Identify entities and attributes of the given scenario and draw an ER diagram by showing different attribute types and cardinality constraints
2.2 Translate the ER diagram into relational schemas by showing the relation with each through primary keys and foreign keys
2.3 Design a relational database system according to the ER diagram you have created (Use SQL DDL statements)
2.4 Provide evidence of the use of a suitable IDE to create a simple interface to insert, update and delete data in the database
3.1 Explain the benefits of different manipulation and query tools which can be used to design the relational database system
3.2 Perform following SQL queries using the tables you have created and provide the output gained
Display the details of students who have awarded by a grade with particular lecturer’s ID and the lecturer’s name using Join queries
Delete all the details of the students who have not achieved a PASSS grade
Write an update query with the help of Join queries to update a particular record in the database.
3.3 Critically evaluate how different query tools can be used to obtain meaningful data with its unique functionalities
4.1 Provide a suitable test plan to support the documentation of the testing process
4.2 Provide relevant test cases for the database you have implemented
4.3 Create user documentation for a developed relational database system with the help of help menus, Pop ups
4.4 Provide evidences on how to address verification and validation
4.5 explain how control mechanisms have been used and the importance of these mechanisms for the security of the database
12 freelancere byder i gennemsnit $55 på dette job
I'm a Bsc degree holder in computer science. I have worked on many papers in report writing, research.I have read and understood your requirement and I know you will never regret, thank you.
I have good understanding of database and have done multiple projects. The work will be quality work and on time as per the requirements mentioned in the assignment.