Question

In: Computer Science

Create an ER diagram, a Relational Schema, and tables with Data, based on the following requirements:...

Create an ER diagram, a Relational Schema, and tables with Data, based on the following requirements:

The database will keep track of students and campus organizations.

- For each student, we will keep track of his or her unique student ID, and his or her name and gender.

- For each organization, we will keep track of its unique organization ID and the location.

- Each student in the database belongs to at least one organization and can belong to multiple organizations.

- Each organization in the database has at least one student belonging to it and can have multiple students.

- For every instance of a student belonging to an organization, we will record the student's function in the organization (e.g., president, vice president, treasurer, member, etc.).

Solutions

Expert Solution


Related Solutions

Using MYSQL in terminal, create the tables for your above designed relational schema and populate your...
Using MYSQL in terminal, create the tables for your above designed relational schema and populate your tables with appropriate data. All except time slot and the relationship it participates in. Use the names for the tables and attributes from the ER schema. Use ON DELETE CASCADE for foreign keys. Each basic table (corresponding to an entity in the ER schema developed for Part 1) should have 5-10 rows. Campus can have just 2. Building should have at least 6. At...
• Relational Schema Create a relational database schema consisting of the four relation schemas representing various...
• Relational Schema Create a relational database schema consisting of the four relation schemas representing various entities recorded by a furniture company.   Write CREATE TABLE statements for the following four relation schemas. Define all necessary attributes, domains, and primary and foreign keys. Customer(CustomerID, Name, Address) FullOrder(OrderID, OrderDate, CustomerID) Request(OrderID, ProductID, Quantity) Product(ProductID, Description, Finish, Price) You should assume the following: Each CustomerID is a number with at most three digits, each OrderID is a number with at most five digits,...
Company X database Create an ER Diagram using UML notation for the following tables, then write...
Company X database Create an ER Diagram using UML notation for the following tables, then write out in the Relational model. Company X is a manufacturing company that binds and sells books. They have hired you to create database to track their Employees, Products, customers and their orders. All employees work with book Binding, Only some are designated as Reps for customers. Reps may have many customers. But each customer can only have 1 rep. They count to record each...
Create an ER diagram for the requirements below. - Parts have a unique number, name, and...
Create an ER diagram for the requirements below. - Parts have a unique number, name, and production year. - Car company has a unique number, name and country information -Automakers make multiple cars. It has a serial number and a name. but, There can be no more than two companies making one car. -Parts are used in many cars. When a part is used in a car, Save the part usage date and quantity information.
Every relation in an ER diagram must translate to an individual relation in the resulting relational...
Every relation in an ER diagram must translate to an individual relation in the resulting relational database schema. True/ Flase For any SQL query, there exist a unique translation into relational algebra. True or False IF a relation schema is in 3NF, it is in BCNF. True or false
Design an ER Diagram for the given problem. Link the tables that are related and implement...
Design an ER Diagram for the given problem. Link the tables that are related and implement your design using MySQL. Insert at least a minimum of 5 records. Ensure that the data to be added are related to other tables. Post here the screenshot of the following: Entity Relationship Diagram with attributes, PK, and FK. Use the "describe" command to view the structure of the tables. Use the "select" command to view the contents of the tables. Company ABC has...
Draw the ER diagram for the following: Emerging Electric wishes to create a database with the...
Draw the ER diagram for the following: Emerging Electric wishes to create a database with the following entities and attributes: (10) • Customer, with attributes Customer ID, Name, Address (Street, City, State, Zip Code), and Telephone • Location, with attributes Location ID, Address (Street, City, State, Zip Code), and Type (values of Business or Residential) • Rate, with attributes Rate Class and RatePerKWH After interviews with the owners, you have come up with the following business rules: • Customers can...
Create an ER diagram for each of the following descriptions: (a)          Each company operates four...
Create an ER diagram for each of the following descriptions: (a)          Each company operates four departments, and each department belongs to one company. (b)          Each department in part (a) employs one or more employees, and each employee works for one department.[with a startdate] (c)           Each of the employees in part (b) may or may not have one or more dependents, and each dependent belongs to one employee. (d)         Suppose company with attributes cnumber, cname, caddress, President. department with...
Create ER diagram for the following: A database has been designed for a Human Resources for...
Create ER diagram for the following: A database has been designed for a Human Resources for a school in the UK. The database includes records of the teachers and their holidays. The Dean of this school has the power to approve those holidays for all teachers in the school.    For each teacher, Human Resources keeps track of the Teacher's ID, name, Cell phone number(s), total number of holidays for each year, number of unemployed holiday days remaining in the...
create an entity relationship diagram to describe the data requirements of the system. Your client is...
create an entity relationship diagram to describe the data requirements of the system. Your client is a local real estate company that wants to automate some of their processes. Here is how some of the business is described: - In a real estate transaction, there is a buyer, a seller, a property, a purchase agreement and a real estate agent - A seller may have one or more properties to sell - A buyer wants to buy only one property...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT