Database Design
The Data type that a Cell can hold:
Data Type Description Char (size)
:
This data type is used to store character strings values of fixed length. The size in brackets determines the number of characters the cell can hold. The maximum number of characters this data type can hold is 255 characters
varchar (size) : This data type is used to store variable length alphanumeric data. The maximum this data type can hold is 2000 character.
nvarchar (size) : This data type is used to store variable length alphanumeric data. The maximum this data type can hold can be specified in brackets. int (P, S) : The „int‟ data type is used to store numbers
(fixed of floating point). Numbers of virtually any magnitude may be stored up to 10 digits of precision.
DATE : This data type is used to represent data and time. The standard format is DD-MM-YY as in 24-JAN-03. To enter dates other than the standard format, use the appropriate functions. Date Time stores date in the 24-hour format. Smalldatetime : This format is used to store date in a small
Long : This data type is used to store variable length character strings containing up to 2GB. LONG data can be store arrays of binary data in ASCII format.
Database Table Name: LOGIN TABLE
Description:
This table stores details of users who are provided with RefId in this website. Refid is allocated to the customers who are provided with Social Networking. Each user is given a unique RefId. RefId is the primary key field and it must have unique and not null value.
It stores the information of User. The Refid is the unique id provided to the user who has owned the Web Based Security System, Name of the User, Address of user‟s house, is the special Id provided to user to access.
Description:
The Registration table stores the details of users who are already registered in this website. Each user is given a unique user_name. user_name is the primary key field and it must have unique and not null value.
It stores the information of User. The RefId of the User, the first_name and last_name of the user, gender, date_of_birth, email, occupation, address,
telephone, mobile_no , password and agreement fields.These all are to be filled necessarily by the user at the time of registration while completing the registration form. These fields are to be filled and not left empty as these fields are provided by not null constraint which means the field is must to be filled and cannot left empty.
Here one important thing is to be noticed that in the registration table the refid is to be taken as Foreign Key. when the admin is to edit the reference id of the user for example is to remove the refid of user in case no longer need of the access system and respectively no need of refid.so the admin is to remove refid from Reference Table and correspondingly the changes will be reflected in the Registration table also.In the context of relational databases, a foreign key is a referential.
Description:
The User Log table is the table that contains all the information about the timings and dates of user logging in and log out. Here each user_id column describes the identity of the user, which is unique foe every user.This table contains seven columns, the first columns is reference id of integer type which is taken from registration table, nulls are allowed. The other columns are User_id, User_name, SID, Login_time, Logout_time, offline.
The important thing about this table is that it is used in keeping tracks of the users with the help of date time datatype. It helps in reports generation in the admin panel. The refid belongs to the reference table, so there is a primary key/foreign relation \ship in these two tables. The refid is primary key in reference table and foreign key in User Log table.
The country table is made to display names of states according to their respective countries in the drop down list panel in the registration page of our website.
The country table has two columns one is for displaying name of the country in registration table. His table stores of varchar(50) type data. Varchar data type is used to store variable length alphanumeric data. In this database table we used data type varchar with size 50.
Description:
The Feedback table,it has four columns namely name,Email, Subject, Feedback.
The name specifies the name of the user who is going through the website, it is of varchar(50) type of data, and nulls are allowed throughout the whole table. The Email is the email id of the user it also stores varchar type of data.subject is the name of the topic. It is specific to the user,s feedback.
Feedback is the information provided by the user in order to improve the website. It directly goes to the admin, and feedbacks are daily visited by the user.
Database Table Name: - Presedental
Description:
The Profilepic table stores the information about the change of the profile picture by the user. It has three fields pid, last_name, image. Pid is incremented automatically as the user changes its profile picture.
This table has no primary key/ foreign key relationship with any table. This table is made just to keep the the record of profile pictures changed by the users. This is just for user interactivity.
The image column is of varbinary(max) type, it means it can store any kind of image format i.e. .jpeg, .gif, .png or any else.
• Home Access
both ECMA and the ISO, making them available as open standards. This makes it possible for third parties to create compatible implementations of the framework and its languages on other platforms.
both ECMA and the ISO, making them available as open standards. This makes it possible for third parties to create compatible implementations of the framework and its languages on other platform.
Description: This Home Page Screen shots showing the room and kitchen pictures.