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 view in RDBMS? View - A view is a relation (virtual rather than base) and could be used in query expressions, which is, queries can be written by using the view as a re

Define the terms   i) DDL   ii) DML   DDL: Data base schema is specified by a set of definitions expressed by a special   language known as a data def

as a customer service employee, explain five measures you would recommend a displeased student to patronise a school canteen

The ER diagram clearly showing the additional tables you have implemented. SQL table creation scripts for the tables you have set up. SQL scripts showing the sample data you

This report identifies and outlines my CIS 499 project named Traffic Data Management  Systems (TDMS) .   My goal is to design a replica of all traffic issues to be implemented i

Oracle Fusion Middleware: Key Skills: Consulting,Architect, Oracle Fusion Middleware,ECM, UCM, Stellent,Identity Management, SOA Suites, BPEL, ESB,OAM,OIM,J2ee, Java, Livelink

What is called mirroring? The simplest approach to introducing redundancy is to duplicate each disk. This method is called mirroring or shadowing.

State about the Tables- DBMS Data is stored in columns and rows (much like a spreadsheet -main difference is how data is organised). Every row in a table is known as a record

Primary Index In primary index, there is a one-to-one relationship among the entries in the index table and the records in the major table. Primary index can be of two types:

What does data dictionary is a special file contains ? The data dictionary is a special file contain The name of all fields in all files.The width of all fields in all files an