Question

Your project will require you to develop a database design to solve a real-life data management problem. It can be any problem in your work environment or for another organization, for example, a bookstore (think of how Amazon uses databases), a course management system (think of how a university manages courses), a bank (think of how your bank works), and an online auction site (think of how Ebay works). You will develop a database to solve this problem

You will use Oracle DBMS throughout the project.

You need to start thinking about the problem now that the base database design fundamentals have been discussed. Try to answer the following questions:

I NEED PART THREE ALSO VERY IMPORTANT

• Who will use this database for what purpose? Remember there may be different types of users and different purposes. E.g., customers and your boss.

• What operations the database needs to provide to support such purpose? Imagine yourself is the customer to use the database.

What data needs to be stored in database to support such operations?

What assumptions you are making when you design the database, are they reasonable?

You cannot use the examples used in the textbook. If you do not have a real-life problem, you can work with someone who does or the instructor may be able to help you with some project ideas.

The question that everyone asks is "how big does the project have to be?" A project that is too small will probably not provide you with an adequate opportunity to display your skills. On the other hand, you do not want to choose too large of a project. It may be possible to find a portion of a large project that could be appropriate. At a minimum, you need to design 4 to 5 significant tables. You will undoubtedly need additional lookup tables. etc., but they do not count as "significant". Each table should have a certain amount of data. You will also have to define the integrity constraints and write at least 5 SQL queries (at least 2 of them contain joins).

Part 3 (40%): SQL commands specific to your application, including the creation of tables, the input of data, and the querying of data in the tables. You shall also test it using Oracle SQL*Plus. You need to include at least 5 select queries, and at least two of them contain joins.

PART 1) The organizations keeps conducting conferences. For this purpose they require various arrangements to be done. This conference database keeps the record of different conferences, who all are attending the conference, who are the speaker, details about the venue, catering services etc Different entities are involved for this purpose. Below is the ER diagram of the conference management system. It consist of 6 entities connected via the relationship. The various entities are- Conference- Keeps the record of Name, duration and time of the conference Venue- Connected to entity conference via the relationship held_at and keeps the record of the venues. Attendees - Keeps the record of all the attendees of the conference and connected to the conference via the relationship attended_by Speaker-This entity keeps the record of the speaker and connects to conference via the relationship given_by Topic- This stores the topic information which speaker chooses and is connected to Speaker via the relationship speaker. Caterer- This entity stores the infonmation about the caterer who is providing the catering service in the conference and is connected to the entity conference via the relationship catered_by. Date & Time hore by Capacity Rating Sersker 1 Tepic

DO PART 3

Answer 1