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.

ID INT PRIMARY KEY

isadmin TINYINT

name VARCHAR(255)

username VARCHAR(255)

password VARCHAR (255)

dayofbirth INT

monthofbirth INT

yearofbirth INT

filmshowings

Records the current film showings.

ID INT PRIMARY KEY

film VARCHAR(255)

date VARCHAR(255)

time VARCHAR(255)

screen INT

maxtickets INT

certificate VARCHAR(5)

mybookings

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
What is normalization? It is a method of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to attain the properties (1).Minim

Project Description: Looking to prepare automated trading engine for alternate cyprto currencies starting with Cryptsy, finally integrating into other exchanges. Need to work wi

Question 1 Discuss the classification of DBMS based on location of database Question 2 Explain with examples different SQL commands used for creating and deleting relations.

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Submit SQL INSERT Statements that will populate the database with sample data.  You must insert at least 5 records into each table in your database.Submit your SQL INSERT Statement

Problem: (a) Data mining is one of the best ways to analyse data and using software techniques, hidden and unexpected patterns and relationships in sets of data can be extrac

Define the following constraints for the table client. (i) BAL_DUE must be at least 1000. (ii) NAME is a unique key. (i)ALTER TABLE CLIENT ADD CONSTRAINT CLIENT_BAL_DUE_C1

Define Fifth Normal form is concerned with Ans : Fifth Normal form is concerned with Join dependency.

An entity set that does not have sufficient attributes to form a primary key is called? An entity set that doesn't have sufficient attribute to form a primary key is known as w