Question

In: Computer Science

Database: Question 11 Using the ERD from problem 10, create the relational schema.(Create an appropriate collection...

Database:

Question 11

Using the ERD from problem 10, create the relational schema.(Create an appropriate collection of attributes for each of the entities. Make sure you use the appropriate naming conventions to name the attributes.)

Solutions

Expert Solution

ANSWER;

Relation data model -

Relation Data Model was an advance model that took over the Hierarchical Model and Network Model as these data models were very complex, and did not provids structural indepenmdence or data independence .

The Relation Data Model allows the data in the databases to be manipulated using relation calculus/relation algebra.

The data is represented in a table that is set of n- tuples.

A table is a matrix which is the collection of rows and colums.

Each intersection forms a cell wich contains a record.

The columns contain entries of same type and have a predefined set of allowed values called domain.

The tables are linked to each other by using keys and constraints to form relationships as represented in the real world.

Relation data model for united Broke Artists (UBA)

Taking the case of united Broke Artists (UBA),

there can be following tables in the model;

1. PAINTING-

The PAINTING table can have the following fields. The fields are also known as attributes. The fields are P _NAME , P_ EXHIBITION, P_PRICE, P _DT_CREQATED, G_ID and PT_ID

2. PAINTER_

The PAINTER table can have the following fields . The fields are PT_LNAME, PT_FNAME, P_NAME, PT_ADDRESS, PT_PH_NUMBER , P_ID and PT_ID.

3. GALLERY_

The GALLERY table can have the following fields are G_NAME, G_ADDRESS, G_DATE, G_ARTIST, and G_ID.

Relationship;

Between PAINTING and PAINTER table , there is a 1;M relationship. This is because each painting is created by a single painter but a painter can create many paintings.

Between PAINTING and GALLERY table, there is a 1;M relationship. This is because each painting is can be exhibited in only a single gallery but a gallery can have many paintings on exhibitions.

The relational model is shown below;


Related Solutions

• 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,...
Question 2: consider the following library relational database schema Write a program segment to retrieves the...
Question 2: consider the following library relational database schema Write a program segment to retrieves the list of books that became overdue yesterday and that prints the book title and borrower name for each. 1- Use JDBC with Java as the host language
Q3. Convert the conceptual database into a relational database schema. Identify the primary key and foreign...
Q3. Convert the conceptual database into a relational database schema. Identify the primary key and foreign key constraints. Q4. Show all the functional dependencies that should hold among the attributes. Q5. Design relation schemas for the database that are each in 3NF. Specify the primary and foreign key attributes of each relation. Hi expert! Can you help me with the above questions? I'm not asking you to solve my questions but want to find what each questions actually requires me...
1- Paper evaluation scenario a) Draw an ERD for the following relational schema: STUDENT (STD_ID, STD_First_Name,...
1- Paper evaluation scenario a) Draw an ERD for the following relational schema: STUDENT (STD_ID, STD_First_Name, STD_Last_Name, STD_Admit_Semester, STD_Admit_Year, STD_Enroll_Status) PAPER (PP_ID, PP_Title, PP_Submit_Date, PP_Accepted, PP_Type) The two entities are related with the following business rule: • Each student may write many papers Explain your choice of minimum and maximum cardinalities. b) Extend the existing ERD with an EVALUATOR entity. The job of the evaluator is to grade each paper. The following business rules apply: • Each paper is evaluated...
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...
Use MYSQL to create the set of database tables of the relational database model and complete...
Use MYSQL to create the set of database tables of the relational database model and complete the associated queries given. Procedure: 1) Write all the SQL statements, necessary to create all tables and relationships, with Primary & Foreign keys. 2) Execute each statement in the correct order to create the relational database in MYSQL. 3)Insert some data into each table. 4) Use all your SQL create and Insert statements (from MS Word) to execute in the MYSQL WorkBench 5) Write...
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate....
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must...
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...
Create a database to hold a collection of numbers to be searched and sorted: 1) Create...
Create a database to hold a collection of numbers to be searched and sorted: 1) Create a main class and a database class 2) Collect 5 random numbers from the user in the main class and store in an array. (not in ascending or descending order) 3) Create an instance of the database class in your main class and store the numbers array in the database using its constructor. 4) In the Database class, create a method that performs a...
For this question, normalize the table to 3NF and draw the relational schema showing cardinalities. UCLA...
For this question, normalize the table to 3NF and draw the relational schema showing cardinalities. UCLA just purchased several servers that are to be used for enterprise resource planning (ERP). The individual servers were purchased from different suppliers and these servers are running different software applications. UCLA also trained several of its staff to use these servers and each trained staff has an authentication code that allows the staff to use a specific software application on a specific server for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT