database design

Database design.

## Deliverables

design. Some of the above steps may be skipped when they are not applicable to the current user view or a user view is simple enough so that it is straightforward to find a relation to support the user view. Use the Database Design Language (DBDL) to express the database design for each user view as well as the cumulative database design after the user view design is merged to it. Also, use the entity-relationship diagram to express the cumulative database design after each user view design is merged to it. For each relation in your information-level design, create a SQL relation with the SQL create table command. The primary keys and foreign keys are not required to be implemented. Enter data to relations to create a sample database. Your sample database should contain at least 3 departments. In each department, there should be at least three faculty members and at least a dozen of students. There should be at least 3 semesters recorded in the sample database. For your sample database, perform the following data retrievals. a. Given the number of a student, display the student’s number and name as well as the course number, course description, semester, and grade for each course the student has taken. b. Given the course number, course description, and semester for one class, display the numbers, names, and majors for all the students in the class. c. Given the number of a faculty member, display his or her number and name as well as the numbers and names of all the students the faculty member advises. d. Given the number of a faculty member, display the name and research area of the faculty member as well as the numbers, names, and majors of all the students to whom the faculty member has taught at least one course. e. Given a semester, find the number of students in each course taught in that semester. Need to display course codes and the numbers of students. Submission Requirement Submit a hard copy of the term project that contains 1. The description of your database information-level design (The requirement about describing your information-level design process is already mentioned before.) 2. The content of each sample relation of your database implemented with SQL 3. The SQL command and the displayed data for each data retrieving requirement

## Platform

non specific platform

Διαχείριση Βάσεων Δεδομένων Μηχανολογία MySQL PHP Αρχιτεκτονική Λογισμικού Δοκιμή Λογισμικού SQL

Ταυτότητα Εργασίας: #2848829

Σχετικά με την εργασία