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 are the components of storage manager? The storage manager components include a) Authorization and integrity manager b) Transaction manager c) Buffer manager d

compare the features of oracle RDBMS with MySQL and Microsoft SQL server

Describe the algorithm to draw the dependency graph?   Ans: Algorithm to draw Precedence Graph is like this: a.  For every transaction T i participating in schedule S, make

project on dbms

external and internal mapping with examples

This language that enable user manipulate to or access data as organized by appropriate data model. Low level or Procedural DML : DML needs a user to specify what data ar

Security: In a centralised system, access to the data can be simply controlled. Though, in a distributed DBMS not only does access to replicated data have to be controlled in many

What are the advantages of DBMS ? 1. Centralized Management and Control - One of the major advantages of using a database system is in which the organization could exert, thr

Aggregation : One limitation of the E-R diagram is that they do not permit representation of relationships between relationships. In such a case the relationship along with its ent