For this project, you will design and implement a relational database system to support the operations...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For this project, you will design and implement a relational database system to support the operations of a University Registration System. You will use HTML for the user interface, MySQL for the database server, and Java, JDBC for connectivity between the user interface and the database server. You will have to install your own web server that will host your web application (Tomcat) as well as a MySQL server. Everything will be local. All you need to complete the project (installation, etc.) can be found in the "Project Information" Module. Project Specification A University offers courses which have a course id, course name, number of credits, department offering the course, and a list of prerequisite courses. Each semester, the Department Administrator adds the courses that will be offerred by the department. The courses offerred include a section number, a list of days/times that they meet during each week (for example, Tuesdays, Thursdays from 10am-11:20am), and a professor that will teach the course. Professors are also added by the Department Administrator, a professor has ID, name, phone number, and office number. Students have an ID, name, phone, and birth date, can register for courses by selecting available sections from a list of elegible courses. Design For the first part of this project you will draw the Entity Relationship Diagram to be used by your application program, and then transform your diagram into tables in the relational model. User-level Functionality There are three types of users: Department Administrators, Students, and Professors. Department Administrators should be able to: o Add users of all types (including their passwords) o Add courses and course schdeules for a given semester Professors should be able to: ● o View a list of students of the courses that they are teaching. o Assign grades to the students taking their courses. . Students should be able to: o See all the courses that they have taken (including their grades). o Register for a course, as long as they have taken the requried prerequisites. How to work in your project 1. Work on your ER Diagram and relational schema. 2. Create all the tables in SQL 3. write down the main SQL queries such as o Given a student ID, produce a list of available course sections that the student can take and that satisfies the required prerequisites. The list should include course id, section number, the day/time that the course is offerred, and the name of the professor teaching the course. o Given a student ID, produce the list of the course sections that the student is enrolled in, including the weekly day/time of classes. o Given a semester, a course id and a section number, generate a list of the students enrolled in that course section. 4. Create a login screen (html) that has basic functionality and distinguishes among the three types of users. 5. Complete functional screens for each one of the required user-level functions described above. For this project, you will design and implement a relational database system to support the operations of a University Registration System. You will use HTML for the user interface, MySQL for the database server, and Java, JDBC for connectivity between the user interface and the database server. You will have to install your own web server that will host your web application (Tomcat) as well as a MySQL server. Everything will be local. All you need to complete the project (installation, etc.) can be found in the "Project Information" Module. Project Specification A University offers courses which have a course id, course name, number of credits, department offering the course, and a list of prerequisite courses. Each semester, the Department Administrator adds the courses that will be offerred by the department. The courses offerred include a section number, a list of days/times that they meet during each week (for example, Tuesdays, Thursdays from 10am-11:20am), and a professor that will teach the course. Professors are also added by the Department Administrator, a professor has ID, name, phone number, and office number. Students have an ID, name, phone, and birth date, can register for courses by selecting available sections from a list of elegible courses. Design For the first part of this project you will draw the Entity Relationship Diagram to be used by your application program, and then transform your diagram into tables in the relational model. User-level Functionality There are three types of users: Department Administrators, Students, and Professors. Department Administrators should be able to: o Add users of all types (including their passwords) o Add courses and course schdeules for a given semester Professors should be able to: ● o View a list of students of the courses that they are teaching. o Assign grades to the students taking their courses. . Students should be able to: o See all the courses that they have taken (including their grades). o Register for a course, as long as they have taken the requried prerequisites. How to work in your project 1. Work on your ER Diagram and relational schema. 2. Create all the tables in SQL 3. write down the main SQL queries such as o Given a student ID, produce a list of available course sections that the student can take and that satisfies the required prerequisites. The list should include course id, section number, the day/time that the course is offerred, and the name of the professor teaching the course. o Given a student ID, produce the list of the course sections that the student is enrolled in, including the weekly day/time of classes. o Given a semester, a course id and a section number, generate a list of the students enrolled in that course section. 4. Create a login screen (html) that has basic functionality and distinguishes among the three types of users. 5. Complete functional screens for each one of the required user-level functions described above.
Expert Answer:
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these databases questions
-
Circular loops in a Venn diagram divide the universe U into distinct regions. No sets 1 1 set 1 region 2 regions Answer the following parts (a) through (d). 2 2 sets 34 4 regions (a) Draw a diagram...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Oriole Ltd. had the following transactions in its first month of operations: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. Issued 18,000 common shares in exchange for $90,000 cash. Took out a $24,900 loan from the...
-
Prepare journal entries to record each of the following sales transactions for the sales company. The company uses a perpetual inventory system and the gross method. 1. April 1st Sold for $3,000,...
-
Nonmonetary Exchange Santana Company exchanged equipment used in its manufacturing operations plus $2,000 in cash for similar equipment used in the operations of Delaware Company. The following...
-
A car repair is either on time or late and either satisfactory or unsatisfactory. If a repair is made on time, then there is a probability of 0.85 that it is satisfactory. There is a probability of...
-
When a new health club opens, the owners offer a discount to the first 100 members who enter into a five-year contract. The fee is \($2,400\) annually for the first five years, prepaid, regardless of...
-
As part of the engagement team for the audit of JA Tire Manufacturing for the year ended December 31, 2019, you are responsible for auditing the sales and collection cycle. If you have not done so...
-
5 Which one of the following correctly represents Sodium oxide? +2 XX a) Na 20 XX 6) 2NaOx x; 1-2 'xx' 1-2 c) 2 Na 20% c) Na XX XX 6 An element with atomic number_ will form a basic oxide. a) 7 (2,5)...
-
1. Prepare manual entries and complete the general and subsidiary ledgers. 2. Prepare an account receivable and account payable reconciliation of the subsidiary ledger accounts to the control...
-
The diagram below shows a dipole centered at the origin and along the x-axis. Determine an expression for the total electric field at a point A (r = 3.7L,0) in terms of q and L. Calculate the...
-
The following extract is taken from a report prepared for the Auditor General for Scotland in November 2008. It analyses the case for a change to a rail service. Additional North Berwick services and...
-
The following extract is taken from a report prepared for the Auditor General for Scotland in November 2008. It analyses the case for a change to a rail service. Additional North Berwick services and...
-
Those who comment on the applications of costvolumeprofit analysis always emphasise that it is a short-run decision-making tool. Write a 200-word note explaining this view.
-
Marlane Villa-Real, chairman and chief executive officer of Buena Mano Crafts, Inc., a manufacturer and exporter of handicraft, said that while export sales declined to stiff competition from China...
-
Write down two products or services where the pricing might be based on cost plus a percentage to cover profits. Write down two products or services where the prices are determined in a highly...
-
Economic profits in the nomic profits in the rent-a-wreck Industry are $400,000 per firm. Assuming that the Industry is perfectly competitive Multiple Choice new firms will enter but there will be no...
-
a. Determine the domain and range of the following functions.b. Graph each function using a graphing utility. Be sure to experiment with the window and orientation to give the best perspective of the...
-
What measures do many development groups use to assess a systems usability?
-
In which phase of the SDLC does project planning typically occur? In which phase does project management occur?
-
Which of the four phases of the project management processdo you feel is most challenging? Why?
-
What does the Richter scale measure?
-
Where do earthquakes occur?
-
Climates farther from the equator usually have (a) lower average temperatures. (b) higher solar intensity. (c) more precipitation. (d) more water.
Study smarter with the SolutionInn App