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
Self-Join:   In a self join a table is joined with itself.  Let consider the following sample partial data of EMP table EMPNO ENAME MGRID

You will be analysing a set of financial data of your choice. It is not necessary to collect any primary data of your own, and publicly available secondary data will be sufficient

Define the concept of aggregation.  Give two examples where this concept is useful. Ans: Aggregation transforms a relationship among the objects into a higher-level object. A

Group By clauses  • It is used to group database tuples on the basis of definite common attribute value like as employees of a department. WHERE clause still can be used

Explain Relational model and their use in DBMS? Relational Model - The relational model was first introduced through E.F. Codd of the IBM Research in the year of 1970. The mode

a. Define the term "deadlock". There are four conditions that must hold before deadlock is possible. Name them. b. Outline an algorithm that detects whether there is a deadlock.

Query Processor The query language processor is responsible for taking query language statements or shifting them from the English-like syntax of the query language to a form

Problem: A DBMS built for Online Transaction Processing (OLTP) is usually regarded as unsuitable for data warehousing. Each system is designed with a different set of requireme

Availability: A site having the copy of a replicated relation fails, even then the relation may be found in another site. Therefore, the system may carry on to process at least th

Multilevel Indexing Scheme Consider the indexing scheme where the address of the block is consider in the index for each record, for a little file, this index would be little a