Question

Case Study

Win Vet High School is located in the heart of Sydney. It services students from Year eight (7) to Year twelve (12) in the local surrounding community.

Win Vet High School has hired you to create a front-end administrative website for updating student details to a database. The following are some notes that you have made following initial discussions with the principal and senior educational staff at Win Vet High School.

Based on the requirements you believe that at a minimum the following web pages need to be developed:

• A login web page
• A student web page

The website is to be written in HTML5, CSS, php using a MySQL database to store data. All web pages should be located within the same directory with any images to be stored in a sub-directory called “Images”. You have been supplied with an image called “Logo.png” which must be incorporated into all web pages. This is the high school’s logo as well as create a favicon to use for the website to ensure live presence.

Login web page

The Login web page should be the first web page that the user encounters when they visit the website. It is to contain a username and password fields and a login button to authenticate the user. The password field should also be masked.

Required value	Validation required
Username	Required. Must be at least 6 characters.
Password	Required. Must be between 8 and 12 characters

Student web page

At the top of the web page a personalised message should be displayed to the user. This message should read “Welcome <<user>>”, where <<user>> is the users name. This name should be retrieved from the stored value that was create from the users being able to use a registration form you will create. This will be displayed after the user logins into the system using the Login page.

Create different themes for different user types. An example is one theme for every guest user (a user that can access the website, student user and an administration user.

For each theme you need to create a skin and CSS file. The skin file should apply styling to the CSS styling each of the web pages while the CSS should apply styling to the HTML elements on the web page. The settings in the skin and CSS files have been left to you but there should be a visible difference between each theme based on its title.

Under this should be the functionality to be able to retrieve, add, edit and delete a student.

Each student should receive a unique student id from the system when they are first added. This should be provided by a New button. Once clicked the system should look up the current highest student id, add 1 to it and then use this as the student id value for the new student. The student id field should be between 1,000 and 10,0000.

To add a student, the user should click the Add button once they have filled out all of the relevant information about the student. At a minimum the user should provide the following information as shown in the following table for a new student.

Required value	Validation required
Their first name	Required. Must be a string.
Their surname	Required. Must be a string.
Their gender	Required. Must be male or female.
Their date of birth	Required. Must be between the dates of 01/01/1950 and today's date.
A street address	Required.
A suburb	Required. Must be a string.
A city	Required. Must be a string.
A post code	Required. Must be between 0001 and 9999.
A mobile number	Required. Must be between eight and ten digits in length.
An email address	Required. Must be a valid email address.

These details should be validated and then stored using MAMP MySQL database table so they can be accessed.

To retrieve, edit or delete an existing student the user should enter a valid student id, and then click an appropriate button (Retrieve, Update and Delete) to undertake the operation. Validation should occur to ensure that the student id exists for the student that is to be retrieved, deleted or have their details updated.

Usability functionality

As well as allowing a user to be able to change a theme the website should highlight which control the user is currently hovering the mouse cursor over. That is, when a user moves the mouse cursor over a control it should be highlighted in a different colour that none of the themes implement. Once the cursor is moved away from the control the highlighting should disappear.

QUESTION

Identify and report on attributes and determine data types that are required for your database ensuring that you undertake normalization of the attributes and draw the ERD Diagram as well

Answer 1

HELLO I AM ADDING ATTRIBUTE,ENTITIES AND ERD BELOW

PLEASE GO THROUGH IT

Following Are The Attributes And Entities For Given System:
1>UserType
        UserTypeId - int - Primary key
        UserTypeName - varchar(255)

2>Login
        Username - varchar(255) - Primar key
        Password - varchar(MAX) - If hashed password is stored
                           varchar(16)  - If Normal Text Password is saved
        UserTypeId - int - Foreign Key To UserType Entity               

3>Gender
        GenderId - int - primary key
        Gender - varchar(50)
        
4>Address
        AddressId - int - Primary key
        Street Address - varchar(MAX)
        Suburb - varchar(255)
        PostCode - decimal(4,0)
        
5>StudentDetails
        SId - int - primary key
        FName - varchar(255)
        LName - varchar(255)
        GenderId - int - ForeignKey To Gender Table
        DOB - Datetime
        AddressId - int - Foreign key to Address Table
        MobileNo - decimal(10,0)
        Email - varchar(255)
        

ERD