Design a database table, Database Management System

A database named yourusernameFMA has been set up for you to use for this assignment.  For the FMA you must create the required tables and run the queries using this database.  If you are unable to access this database by the last session of the module, please inform your tutor so that the problem can be resolved.

Note: you should not make changes to your FMA database once you have submitted your work. Marks will be lost if the queries you submit cannot be run on the FMA database that you have created.

Review the feedback from your TMA to ensure that your database model and table specifications are correct. Make any amendments necessary before creating the tables. Write and run CREATE TABLE statements for each table. Each statement should include a brief comment at the start stating its purpose, the name of the author and date of creation. Statements should be clearly set out with each column definition starting on a new line and using UPPERCASE for MySQL reserved words. They should include primary and foreign keydefinitions as appropriate and define the database engine to be used.

Hint: Think about the order that you need to create the tables in.

Posted Date: 3/13/2013 6:48:42 AM | Location : United States







Related Discussions:- Design a database table, Assignment Help, Ask Question on Design a database table, Get Answer, Expert's Help, Design a database table Discussions

Write discussion on Design a database table
Your posts are moderated
Related Questions
Which method is used to key transformation ? A hash method is used to key transformation.

Ways for Selecting Data Structure Algorithms operate on data structure. Therefore, selection of the best algorithm means selecting the best data structure from whole bunch. Th

What is the archtetype/instance pattern? The archetype/instance pattern happens when one entity tracks occurrences of another entity. A common example is the relationship among

The physical location of a record is determined by which mathematical formula that transforms a file key into a record location? The physical location of a record is determined

A well-maintained relational DBMS has a high level of data integrity. What features of a relational DBMS contribute towards this level of integrity? Relational DBMS gives high

Write the syntax of creating an INDEX ? Syntax of Creating an Index: CREATE [BITMAP] [UNIQUE] INDEX ON ( [, ] . . .);

er diagram on cosmetics.

What Count function return in SQL? Count function within SQL returns the number of values. (Count function counts all the not null values in the exact column. If we need to cou

Define deadlock avoidance. An alternative method for avoiding deadlocks is to needs additional information about how resources are to be requested. Each request requires the s

Describe Data Manipulation language ? Data Manipulation Language (DML) - A data manipulation language is a language which enables users to access or manipulate data as organize