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
Need For Distributed Database Systems A distributed database is a set of database kept on multiple computers that appears to applications as a one database. As a result, an app

Question A What is operational intelligence? Question B What is Business Intelligence? Explain the components of BI architecture Question C Differentiate between databas

i need help for assignment ..

Define the terms  1) physical schema 2) logical schema.  Physical schema:  The physical schema explains the database design at the physical level, which  is  the  lowest  lev

#ques Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a p

Components of database manager The above functions are reached by the database manager. The major elements of a database manager are: Authorisation control: This mod

What are the various properties of Relational tables? Relational tables have 6 properties: 1. Each row is unique. 2. Column values are of the same kind. 3. Values are

A file manipulation command that extracts some of the records from a file is called ? A file manipulation command that extracts some of the records from a file is called SELECT

We will explain here an example database application having COLLEGE database and use it in showing several E-R modelling concepts. College database remains track of faculty, Stu

What are advantages of object models? Object models are efficient for communicating with the application experts and reaching a consensus about the significant aspects of the p