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 concept of decomposition?

A super key is an attribute or set of attributes used to recognize the records uniquely in a relation. For instance, in the Relation PERSON defines earlier PERSON_ID is a super

CREATE TABLE prodtrans ( pno number (4) ptype char (1) CHECK (ptype in ('I','R','S')), qty number (5) FOREIGN KEY pno REFERENCES product (pno) ON DELETE CASCADE);


Build a database application for a sports league. Assume your application is to keep track of teams and equipment that is checked out to teams. Explain the steps that is needed and

What are the kinds of Strings?  -A binary string in MySQL is one that MySQL treats as case sensitive in comparisons. -A non binary string in MySQL is one that MySQL does'nt

Explain the functions of data manager? Functions of Data Manager : - Convert operations in user's queries coming directly through query processor or indirectly in an applicatio

Describe the tools that are available for managing MySQL Server. Given below are the tools to manage MySQL server: mysqld - MySQL server daemon. This is used to begain t

A TDMS project plan is not a typical Information Technology project plan; therefore, a traffic data project has several unique characteristics: Traffic data management system