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
Explain trigger? Trigger: A database trigger is procedural code which is automatically executed within response to certain events on a particular table in a database. Trigger

What are the requirements to ensure the objectives of file management principle is realized?

The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

This project requires you to perform a systems analysis and then design a system solution using database software. Ace Auto Dealers specializes in selling new vehicles from Subaru.

Benefits: It limits data access. It makes difficult queries look easy. It permits data independence. It presents dissimilar views of the similar data.

List any two disadvantages of a database system ? The disadvantages of database system are: • Database systems are difficult, complex, and time-consuming to design. • Substanti

Explain group By clause in SQL? Group By clause in SQL: The GROUP BY clause can be used in a SELECT statement to collect data across multiple records and group the results thro

What are partial, alternate,, artificial, compound and natural key? Partial Key: It is a set of attributes that can uniquely recognize weak entities and that are related to s

What is a Database? To know what database is, we have to start from data, which is the basic building block of any DBMS. Data: Facts, figures, statistics etc. having no pa

what are information system hirarchy?