Assignment Data Analysis and Design
$10-30 USD
Paid on delivery
Task 1:
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
Task 2
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
Task 3:
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
Task 4
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
Project ID: #17329109
About the project
9 freelancers are bidding on average $65 for this 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.
Hi Dear I have a lot of experience in DataBases ,Data Warehous,DB2 , Teradata etc . I am DataBases + Warehouse certified from Oracle,postgresSQL,SQL SERVER , Access. I have done many work in Requirements analysis , More
i have done similar work in the past. Please check my profile section for the same work and past client reviews. I have over 8 years of experience as a database developer using mysql, oracle, sql server, mongo db dat More
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.
Complete analysis and design of a system and leave database prepared. Justifying at each point why it makes each decision among the different options. Documentation about structure & test batery. Relevant Skills and E More
