BlogDatabase Design for Business Assignment Help

April 1, 2022by Dennis kimotho0

Hits: 0

Database Design for Business

Can be any business other than a bicycle shop (sales/repair)

1 Person 20 Tables

2 People 38 Tables

3 People 56 Tables

4 People 74 Tables

(Average 5 Columns per table)

Should be normalized to 3rd Normal Form

1 (per person) instance where 1st, 2nd, or 3rd normal form is violated, give a detailed explanation as to why you designed this violation (you can have more than one, but it must be explained) Database Design for Business Assignment Help

Create Select/Insert/Update/Delete statements for each table (other than  many-to-many tables)

Create at least 12 business rules, 10 should be built into the design (Per person)

Naming convention – explain the naming convention you used.

Data Dictionary

10 rows of dummy data in each table (where possible)

DDL Scripts for each table, PK, and FK

Using https://app.diagrams.net/ create the ERD using Crow’s Foot Notation (No other Notation will be accepted)

If you are working as a team, make sure it is obvious who created which pieces. Color code the ERD, showing who did what.

One person should submit the project for the team.

Database Design for Business Assignment Help

Database Design for Business Assignment Help

This is not part of the assignment

Refer to MySQL nested loop documentation for an explanation of the nested loop algorithm.

Now, replace = in the WHERE clause with < and generate a new execution plan. Step 1 of the execution plan says Index Range Scan. The index scan accesses all films with titles preceding “ALONE TRIP”, rather than a single film.

Finally, replace < in the WHERE clause with > and generate a third execution plan. Step 1 of the execution plan says Full Table Scan and accesses actor rather than film.

For Database Design for Business Assignment Help please click here

Leave a Reply

Your email address will not be published. Required fields are marked *