Create a technology web server, Database Management System

Database design

Database tables will be created for you on the Technology web server. The schema will be as follows. Please note that this is a simplified database structure, designed to make it straightforward to implement the assignment on a basic level; you can modify this or add additional tables if you wish. Only the first two tables are absolutely essential to implement a bare pass solution.

sc_users table

Records users in the system, and whether they are an administrator or a regular user.


isadmin TINYINT

name VARCHAR(255)

username VARCHAR(255)

password VARCHAR (255)

dayofbirth INT

monthofbirth INT

yearofbirth INT


Records the current film showings.


film VARCHAR(255)

date VARCHAR(255)

time VARCHAR(255)

screen INT

maxtickets INT

certificate VARCHAR(5)


A table which can be used if you wish to implement code to allow users to view, change and cancel their bookings. Not required for a bare pass answer but useful for more advanced answers.

username varchar(255)

showingID INT

ntickets INT

Posted Date: 3/20/2013 6:32:28 AM | Location : United States

Related Discussions:- Create a technology web server, Assignment Help, Ask Question on Create a technology web server, Get Answer, Expert's Help, Create a technology web server Discussions

Write discussion on Create a technology web server
Your posts are moderated
Related Questions
Differentiate between various levels of data abstraction? Data Abstraction - Abstraction is the procedure to hide the irrelevant things from the users and represent the rele

Control as Concurrent Tasks The expression control as simultaneous task means applying control for those events of object which can happen simultaneously. An object can be imp

In order to keep pace with competitors, Space Ltd has decided to implement an ERP system in order to replace its old legacy and manual systems. Management does not have much knowle

Use again the GE Flight Quest Data and build on the work done for homework 1 and 2. The goal is to create a classification model which classifies flights into "on-time" (you can de

What is horizontal fragmentation? Horizontal fragmentation divides the relation by assuming every tuple of r to one or more fragments

Describe five main functions of a database administrator. Ans: A database administrator (DBA) is a person who is accountable for the environmental aspects of a database. Genera

prototype of a distributed information system for a national car part retail outlet chain.

What are the storage types? The storage types are: a) Volatile storage b) Nonvolatile storage

What is the difference between WHERE and HAVING clauses?. Predicates in the WHERE clause applies to every tuple while the predicate in the HAVING clause applies to groups.