Assignment Data Analysis and Design

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

Evner: Databaseudvikling, SQL

Se mere: business systems analysis design, system analysis design project using vb6, analysis design development support, data analysis and design pdf, unit 21 data analysis and design assignment 1, unit 33 data analysis and design, sql, database development, proposal data analysis project, resume data analysis, collating data analysis, understand algorithm analysis design, data analysis survey design spss, data analysis assignment university, aimsun hatris data analysis task, tasks data analysis design assignment, data analysis design assignment, assignment system analysis design, system analysis design assignment, system analysis design project assignment

Om arbejdsgiveren:
( 8 bedømmelser ) Boralesgamuwa South, Sri Lanka

Projekt ID: #17329109

11 freelancere byder i gennemsnit $57 på dette job


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 , Flere

$50 USD in 3 dage
(15 bedømmelser)

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 Flere

$111 USD in 2 dage
(6 bedømmelser)

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.

$100 USD på 1 dag
(5 bedømmelser)
$111 USD på 1 dag
(3 bedømmelser)

Hi, bro. Nice to meet you. I have read your request. I have a full of experiences with data analysis and design. I am confident in your project and I can finish your project clearly. I think we can carry from ju Flere

$25 USD på 1 dag
(1 bedømmelse)

Hi, My work experience as shown in my profile have helped me develop mastery in Website design & development. From your brief, I noticed that you need to Assignment Data Analysis and Design. Please have a loo Flere

$10 USD på 1 dag
(0 bedømmelser)

Hi, Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have got Rich experience in Jooml Flere

$21 USD in 7 dage
(0 bedømmelser)

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.

$35 USD på 1 dag
(0 bedømmelser)
$133 USD in 5 dage
(0 bedømmelser)

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 Flere

$25 USD in 10 dage
(0 bedømmelser)
$10 USD in 2 dage
(0 bedømmelser)