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.)

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;

venereology answered 1 year ago

• 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

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 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...

Consider the following relational database schema: employee(employee-name, employee-id, street, e-city) works(employee-

Consider the following relational database schema: employee(employee-name, employee-id, street, e-city) works(employee-id, company-id, salary) company(company-name, company-id, c-city) manages(employee-id, manager-id) Specify the following queries on this database schema using the relational operators we discussed in class. Write your answers on a separate sheet of paper in the order that they are specified below. Retrieve the name and address of employees who work for First Bank Corporation. Retrieve the name, street address, and city of residence of all employees...

Database Management Question: Choose a database recovery problem and then propose a solution using the techniques,...

Database Management Question: Choose a database recovery problem and then propose a solution using the techniques, such as log-based recovery or shadow paging, etc. Briefly describe the technique, when it is appropriate to use, and what recovery problem it solves.

QUESTION: The following tables describe the content of a relational database: a) Identify and classify the...

QUESTION: The following tables describe the content of a relational database: a) Identify and classify the tables as either entity or relationship The first step in building an E-R model is to identify the entities. Having identified the entities, the next step is to identify all the relationships that exist between these entities. Using the content of the relational database above: b) Using the relations in the relational database, explain how one can transform relationship in E-R model into a...