Web-Based Database Paper

Better Essays
WEB - BASED DATABASE - PART 1

Step 1 - Define the scope and function of the enterprise you have selected. Identify the requirements of your database.

Engineering Orientation Program

The system I have selected is the Engineering Orientation Program. This is a student run organization through the college of Engineering. This is a one day program in the beginning of the school year to help the transition into college for incoming freshman. It helps the freshman stay updated on network events and helps them stay involved with the College of Engineering the whole year. The incoming freshman students are placed in groups with an upperclassman mentor who will be leading the orientation with them. This will allow the rating system between students and mentors. The proposed system will also make scheduling events for
…show more content…
If there is any violation in this key constraints this resembles tuple constraint violation.

Task 3.5 Other constraints
The primary key value should not be null and must be unique. (Entity integrity constraint)

Step 4

Task 4.1. Initial set of relations

The initial set of relations without normalization are:

Students

Each Student is uniquely identified by his/her college email, and further described by his/her student name, cell number, and team color.

Mentor

A mentor is uniquely identified by his/her college e-mail, and further described by his/her name, major, team color, and cell number.

Director

Each director is uniquely identified by his/her email and is further described by his/her name, team color and cell number.

Rating

Each rating is uniquely identified by a submission number, and further described by availability and comments.

Questions

Questions are uniquely identified by question number, and further identified by subject and answer.

Event

Each event is uniquely identified by event name, and further described by location, and

Related Documents

  • Amazing Essays

    Solution, there are four positions that important to the company and that is system analyst, web developer, database administrator and network administrator. For example, system analyst jobs is to solved problems that related with the computer technology, database administrator is responsible for the performance and security of a database and also involved in the planning and development of the database. Network administrator jobs is to maintains computing environment such as monitoring network performance…

    • 1337 Words
    • 6 Pages
    Amazing Essays
  • Amazing Essays

    Kelly's Salon Case Study

    • 1186 Words
    • 5 Pages

    Kelly‚Äôs Salon, employees still use conventional methodologies that are very inefficient. This paper presents a guide on the proposed IT solution- Software known as Service (SaaS) for Kelly to tackle challenges she is facing in her current business environment. II. Proposed IT Solution The proposed IT solution is Order Motion software (OMX). This is simply Software as a Service (SaaS) supplied by NetSuite, a US based vendor…

    • 1186 Words
    • 5 Pages
    Amazing Essays
  • Good Essays

    You just found out you have to conduct research for a paper in your course but you are not sure how to get started. Nonetheless, you felt stressed or confused about using the Ashford University Library that is required of you. On the condition that you need to find physical library resources such as books, magazines, journals multimedia for references for this paper. In this case, we are going to explore in-depth on the benefits of using the Ashford University Library. First, to explain the differences…

    • 835 Words
    • 4 Pages
    Good Essays