[SOLVED] Database Assignment

20.00 $

Programming resource
, Digital learning resource
Categories: ,
Practical programming resource
Suitable for guided study and reference
Tutor guidance available when needed

Description

5/5 - (6 votes)

The following assignment is based on the database environment designed in the Week Three Individual Assignment.

Your database project must meet the following assessment requirements:

  • Create a database using professional principles and standards.
  • Use a relational database software application to develop a database implementing the logical design into a physical design.
  • Use MySQL database to create the normalized physical database including tables, columns with data types, primary keys, constraints, etc.

Create a minimum of ten rows of test data in each table in an SQL script file with the SQL statements needed to create tables with keys and to insert test rows, etc., into the tables.

Submit your single SQL script file containing all statements to the Assignment Files tab.

Resource details

Understand the Task Before You Use the Resource

Review the requirements, identify the programming concepts involved, study the implementation and test your understanding with your own examples and modifications.