B01DBFN212/ BIT 208 The Design, Building, Querying And Testing Of Relational Database Assessment Answer

Question :

COURSE:Bachelor of Business / Bachelor of IT
Unit:	Database Fundamentals
Unit Code:	B01DBFN212/ BIT 208
Type of Assessment:	Individual Project
Course Learning Outcomes addressed:	a) b) c)	To gather, critically analyse, manage and present in meaningful ways information and data, and To act as an ethical practitioner while demonstrating skills in data analysis, database design, system design, web design and software development and testing. To implement and document user experience analysis, design and testing.

Assessment Task:

The design, building, querying and testing of a relational database

ASSESSMENT DESCRIPTION:

This assessment is an individual Project. The actual scenario for carrying out the following tasks will be available on Moodle by week 8.

Tasks to be completed

Given the above information:

Create a complete ERD with all entities and relationships.
Convert the ERD to a set Relational tables in at least 3NF and draw a dependency diagram.
Create a database using MS ACCESS - with primary keys, foreign keys and other attributes mentioned for each entity using proper constraints.
Create a form to input/update data.
Input some significant data in each table showing your understanding of the scenario.
Create three Queries.
Create a report.

For solution, connect with our online professionals NOW!