How to Create HND in Software Engineering SEC4205 Database Design and Development Assignment

How to Create HND in Software Engineering SEC4205 Database Design and Development Assignment (A Personal DVD Library)
Report
In this assignment, the scenario relates to a personal DVD collection, for which I have to create and design a database, but first I’ll have to design an Entity Relationship diagram.

Introduction

Task 1

ER DIAGRAM

Task 2

Step 1: Mapping of Regular Entities

Step 2: Mapping of weak entities

Step 3: Mapping of 1:M Relationships

Step 4: Mapping of M:M Relationships

Step 5: Mapping of Multivalued and Composite attributes

Step 6: Mapping of N-Array Relationships

Step 7: Mapping of ISA Relationships

Finalized Relational Scheme

Task 3

1-Select Add database from database node.

2-input database name and press “ADD”.

3- Create table

4- Insert data to table

5- Delete data from table

6- Update data from table

7- Certificate table

8- Producer table

9- Actor table

10- Actor Role table

10- Actor Role table

Task 4

Queries

Task 5

Step 1

Step 2

Step 3

Step 4

Step 5

Task 6

What is a data base?

What is a Query?

Advantages of SQL

Task 7

Test case for table DVD Info

Test case for table FIlM_CERT

Test case for FIlM_PROD

Test case for FIlM_ACTOR

Test case for ACTOR_ROLE

Test case for FILM_CATEG

Task 8

User Manual

Task 9

Validation

Verification

Task 10

Open Sequel Pro and connect to the server

Bibliography

Your Queries:
assignments
assignment solution
assignment work website
assignment bnane ka tarika
assignment design
case study
case study video
case study assignment
case study research methodology
case study presentation
case study examples
case study research
case study format

For Complete Free Assignments Like these visit our Website:
https://tasks24.com