database systems

create conceptual diagram and ERD

Draw ERD ERD: Complete ER diagrams for all the given scenarios. It is necessary to specify all entities, attributes, constraints, relationships

National Solutions Convention (NaSCon) The biggest flagship event of FAST National University, Islamabad campus, the National Solutions Convention (NaSCon) is just around the corner. The university has assigned you the duty of efficiently managing all the records of this event. You have to design the ERD for NaSCon Management System. NaSCon is managed by a president, vice president, and management team. The management team is divided into departments such as sponsorship, marketing, operations, security, logistics, etc. Each department will have its own executive body. The executive body consists of a secretary and a team. There will be a separate event head for each event. All members have a unique id (roll number), first name, last name, age, email, and role. NaSCon organizes a number of events of different categories such as EE (Robo Wars, Speed Wiring), CS (Game Jam, Bug Hunt), Business (Marketing Plan, Finance Guru), and Sports, etc. Each event will have a time, date, registration price, participants, and information about prizes. Each participant can participate in more than one event. The participants can either be from FAST University or any other university. The students of FAST will have a special discount on all ticket prices so you will have to maintain the difference between both kinds of participants. All participants will have a unique id, first name, last name, age, and contact. The participants of FAST will also have their roll numbers saved. Non-FASTians will have a university name. Some events will also have teams of participants rather than a solo participant. You must manage this as well. Many different organizations sponsor NaSCon. You will also have to save their record. Each sponsoring organization will have the name of the company, the name of the representative, CNIC, and the name of the category/event for which they are willing to sponsor. Each sponsor can sponsor multiple events. Similarly, an event can be sponsored by multiple sponsors