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
Having Clause with sub queries: First we have to recollect the GROUP BYclause. The following query searches the minimum salary in every department. SELECT DEPTNO, MIN (SAL)

What is a transaction ? The Transaction is a unit of data processing. For instance, many of the transactions at a bank may be withdrawal or deposit of money; transfer of money f

Examples:- Hierarchical Model: It tells data as and relationships by hierarchy of data values. Figure illustrates an example of hierarchical model. Now a day's these models are

List the set operations of SQL? 1) Union 2) Intersect operation 3) The except operation

The scenario You have been approached to design and implement a prototype of a distributed information system for a national car part retail outlet chain. The company comprises


entity relationship diagram for online examination system

FDs in Relationships:  Enrols Relationship: None as it is many to many Teaches Relationship : Course code → Instructor Instructor → Course code The next question is:


I want Database Of United Kingdom with Criteria of:\r\n\r\n1). Name, Number, City, State, Postal Code, Address, Email id, DOB.\r\n\r\n2). Unsecure Debts only adds Credit Card Payme