Wessex University Students' Union wishes to create a new dynamic website to replace its existing static, HTML-only website. The existing website has the problem that it must be edited by hand. For example, when the union puts on a new event, such as a club night or live band, the administrator must edit the HTML pages by hand. Similarly, each time a society wishes to put on an event, the president must edit the society's HTML page by hand.

There is also no way for students to reserve tickets for events online, an often-requested feature. The new website aims to use database-driven server-side scripts to provide a more interactive experience for the administrator and the user.

Students need to book tickets for any event, including free events; this is because the union venues only have room for a certain number of students. When booking tickets for an event, students should be able to choose how many tickets they want. Students should only be able to book tickets if there are enough tickets left. Students must also be logged in to book tickets, so that the system has a record of who booked what, and to prevent an individual student booking most or all of the tickets for an event!

Students do not have to pay for charged-for events online. It is assumed that they will pay when they arrive on the night.
Administrator facilities

The site's administrator (a specific member of students' union staff) should be able to log on to the site and add new events. When adding new events, the administrator should be able to specify the name, the price, a description of the event and a maximum number of tickets. Regular students should not be able to perform this action.

Database design

Database tables will be created for you on the Technology web server. The schema will be as follows:

Users table

ID INT PRIMARY KEY
isadmin TINYINT
Name VARCHAR(255)
Username VARCHAR(255)
Password VARCHAR (255)

Events

ID INT PRIMARY KEY
Name VARCHAR(255)
Eventdate DATE
Maxtickets INT
Price FLOAT.

Could some please help me with how I should go about doing the site and if possible help with the coding of bringing the site together as I have no idea how to start and design a web site, or how to code a site.

    Wessex University Students' Union wishes to create a new dynamic website to replace its existing static, HTML-only website. The existing website has the problem that it must be edited by hand. For example, when the union puts on a new event, such as a club night or live band, the administrator must edit the HTML pages by hand. Similarly, each time a society wishes to put on an event, the president must edit the society's HTML page by hand.

    There is also no way for students to reserve tickets for events online, an often-requested feature. The new website aims to use database-driven server-side scripts to provide a more interactive experience for the administrator and the user.

    Students need to book tickets for any event, including free events; this is because the union venues only have room for a certain number of students. When booking tickets for an event, students should be able to choose how many tickets they want. Students should only be able to book tickets if there are enough tickets left. Students must also be logged in to book tickets, so that the system has a record of who booked what, and to prevent an individual student booking most or all of the tickets for an event!

    Students do not have to pay for charged-for events online. It is assumed that they will pay when they arrive on the night.
    Administrator facilities

    The site's administrator (a specific member of students' union staff) should be able to log on to the site and add new events. When adding new events, the administrator should be able to specify the name, the price, a description of the event and a maximum number of tickets. Regular students should not be able to perform this action.

    Database design

    Database tables will be created for you on the Technology web server. The schema will be as follows:

    Users table

    ID INT PRIMARY KEY
    isadmin TINYINT
    Name VARCHAR(255)
    Username VARCHAR(255)
    Password VARCHAR (255)

    Events

    ID INT PRIMARY KEY
    Name VARCHAR(255)
    Eventdate DATE
    Maxtickets INT
    Price FLOAT.

    Could some please help me with how I should go about doing the site and if possible help with the coding of bringing the site together as I have no idea how to start and design a web site, or how to code a site.

      Wessex University Students' Union wishes to create a new dynamic website to replace its existing static, HTML-only website. The existing website has the problem that it must be edited by hand. For example, when the union puts on a new event, such as a club night or live band, the administrator must edit the HTML pages by hand. Similarly, each time a society wishes to put on an event, the president must edit the society's HTML page by hand.

      There is also no way for students to reserve tickets for events online, an often-requested feature. The new website aims to use database-driven server-side scripts to provide a more interactive experience for the administrator and the user.

      Students need to book tickets for any event, including free events; this is because the union venues only have room for a certain number of students. When booking tickets for an event, students should be able to choose how many tickets they want. Students should only be able to book tickets if there are enough tickets left. Students must also be logged in to book tickets, so that the system has a record of who booked what, and to prevent an individual student booking most or all of the tickets for an event!

      Students do not have to pay for charged-for events online. It is assumed that they will pay when they arrive on the night.
      Administrator facilities

      The site's administrator (a specific member of students' union staff) should be able to log on to the site and add new events. When adding new events, the administrator should be able to specify the name, the price, a description of the event and a maximum number of tickets. Regular students should not be able to perform this action.

      Database design

      Database tables will be created for you on the Technology web server. The schema will be as follows:

      Users table

      ID INT PRIMARY KEY
      isadmin TINYINT
      Name VARCHAR(255)
      Username VARCHAR(255)
      Password VARCHAR (255)

      Events

      ID INT PRIMARY KEY
      Name VARCHAR(255)
      Eventdate DATE
      Maxtickets INT
      Price FLOAT.

      Could some please help me with how I should go about doing the site and if possible help with the coding of bringing the site together as I have no idea how to start and design a web site, or how to code a site.

        Honestly, I'd say look at some pre-made CMSs out there. Something like Mambo would suit your needs. It would do everything, less the ticket selling/reserving. That you'd have to come up with on your own. But permissions, authentication, Syndication (which you'll probably want), news and event stories, categories, and all that is taken care of. All you'd have to do is create a "module" to be added that you can purchase/reserve tickets for.

        Look into Mambo or some other CMS (google PHP CMS, there's plenty that'll come up) and see if they give you want you want. If none of them offer what it is you're looking for (less the ticket module), then we'll start. But really if you can, just use the CMS. It would make things a whole lot easier.

          Hmm... cross posting... YAY!!!
          NOT!!
          I replied to your other thread......

            I have no idea how to start and design a web site, or how to code a site

            With respect, are you sure you should be doing this, then?

              It is university course work and this is the only subject I cant do

                pick up a book first. then get some personal help. you are not going to be able to do this on your own. it's too big of a task

                  If you can afford it, I would suggest hiring someone to code a nice looking and easily updatable site. They would be able to help you more personally and professionaly in a fast manner.
                  Beware of how spendy it is though. My school (www.nnu.edu) paid around $75,000 for their site because of the extreme complexity of it. I don't care much for the design, but it does work quite nice.
                  If that is too much for you to pay out, then good luck, and maybe you shouldn't worry about all the interactivity. 🙂

                    It is university course work and this is the only subject I cant do

                    What Kind of Course Incorporates Web Design In With Other Areas. And If You Are On A Computer Course Why Have'nt You Learned To Script Yet.

                    If you can afford it, I would suggest hiring someone to code a nice looking and easily updatable site

                    Brilliant Idea. I Put MySelf Forward As I Have Previous CMS Development Experience And Would Find The Online Ticket Buying A Doddle

                    Beware of how spendy it is though. My school (www.nnu.edu) paid around $75,000 for their site because of the extreme complexity of it. I don't care much for the design, but it does work quite nice.

                    I wouldnt Charge The University $75,000. However For Such An Undertaking I Could Charge £5,000 With A Turnaround Time Of 20 Days After Contract Signing. I Go To Anglia Ruskin University And I May Be Redoing Their WebCT And E-Vision or Integrating the Two Technologies

                      4 days later

                      The website is meant to be quite easily done as it is actually an assignment for the first year of uni.

                      The site is meant to have just a simple login where an admin person can create events and a user can book events.

                      The databases are on the top of the page.

                      When a user views the site he is only meant to be able to view the events of the next two weeks.

                      That is all the site needs to do.

                      So any help at all would be most appreciated.

                      Thanks.

                        Write a Reply...