The figure below shows an ER schema for a university database. Map this ER schema into a relational schema by using the mapping algorithm discussed in the class. Specify all primary keys and foreign kevs, List the final relational database base schema. Please show your work. COffice Rank Office Name Name IPhone COLLEGE DEAN INSTRUCTOR (O,N) CStartDate (O,N) CHAIR ADMINS Name LName EMPLOYS ld Name (O,N) Addr Phone Major DCode DEPT HAS STUDENT DOffice (O,N) DPhone (O,N) (O,N) Grade HES OFFERS TAKES (5,N) COURSE SECS SECTION Credits (O,N) Sem CDesc Time Year Bldg Fgure aram for a UNIVERSITY database An ER diagram for a UNIVERSITY database schema.
Q: QUESTION 3 Consider the following database schema for a library. Book (BookiD:int,…
A: Answer :-- True
Q: Write a relational mode for each of the case below. You can create our own attributes and provide…
A: The given are the requirements of how and what data is stored for a clinic which includes the…
Q: Consider the following example database and query and then show the value of…
A: distance(volvo,Volvo_Distance) Volvo_Distance = speed (volvo, Speed) * time (volvo, Time) = speed…
Q: You are given the following database schema: Sailors(sid, sname, rating, age) Boats(bid, bname,…
A: Given Data : Number of pages in main memory = 9 Sailors : Tuples = 100000 pages = 1000 Sailors…
Q: QUESTION 3 Consider the following database schema for a library. Book (BookID:int,…
A: Foreign key :- A foreign key is a set of attributes in a table that refers to the primary key of…
Q: List productList = [Select Id, Name, Parent_Product__c, IsActive, Description, Account__c, (Select…
A: Given that Computer engineering lab ApexSOQL - salesforce object query languageWhy i am getting this…
Q: Consider the database schema below. Fruit (ID: integer. Name: String ) Vitamin (FruitID: Integer.…
A: In the Fruit table, Name is not a primary key. Key constraint states thate all the values of primary…
Q: Let R and S be two relations with the following schema: R (P.Q. R1, R2, R3) S (P.Q S1, S2) Where (P,…
A: Let R and S be two relations with the following schema R(P,Q−−−−,R1,R2,R3)R(P,Q_,R1,R2,R3)…
Q: Given the following relation R and its functional dependencies: R(workerNumber, repairNumber,…
A: Given information: - A relational schema R is: R(workerNumber, repairNumber, workerName,…
Q: Consider the following schema for a company database and answer the following questions: DEPARTMENT…
A: The question did not say which DBMS platform has to be used.So MS SQL Server has been used to…
Q: Consider the schemas for the table people, and the tables students and teachers, which were created…
A: Given: Consider the schemas for the table people, and the tables students and teachers, which were…
Q: First step is to built the database schema using the following query- CREATE SCHEMA `organization`…
A: The new attributes will get added in the primary table form in the database table .
Q: In this project, you will design and implement a database for keeping track of information about a…
A: The entities identified based on the given requirements and its business rules are :- • CUSTOMER •…
Q: Creating a database Diagram. Does the attached image meet these criteria? Week 6: Lab…
A: Answer: We have draw the relationship between the table in the brief where the relation ship one to…
Q: ISBN(PK) Title Publisher Stock Price C Programming Database Systems 1123 Pearson 300 89 2111…
A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…
Q: We need to create a database for the Circulation Department of a public library. The database will…
A: The database schema would have the following structure. The primary keys are underlined and foreign…
Q: Suppose in a movie database, a movie is identified by id, name, year and ratings where a movie might…
A: Answer
Q: QUESTION 6 Consider the following database schema for a library. Book (BooklD:int,…
A: The answer is True.
Q: # Question 1 #Using the World database, in the city table, insert a new city for the Tasmania…
A: What is SQL: SQL is a language for interacting with databases. SQL is the standard language for…
Q: Normalize the following schema, with given constraints, to 4NF. books(accessionno, isbn, title,…
A: In the normalization process.
Q: We need to create a database for the Circulation Department of a public library. The database will…
A: Database schema: The database schema would have the following structure (primary keys are italicised…
Q: The following is a relational schema for a database to document shark sightings for a research…
A: Answer: Relational Algebra Expressions: Relational Algebra Tree:
Q: Consider the following structure of an inventory Oracle database. HUMERC (B) WOWR) VIMOHAR ( S DECL…
A: Neither not we have to select customers not from new york or grade value greater than 100 i.e less…
Q: Question 12.1 Use the object definition language ODL of the ODMG object model to specify an object…
A: Publication(Catalog, Title) Publisher(Name, City ,Address) Book(Page_count, Format)…
Q: Take a look at the database structure for cities in nations below. There are numerous cities in a…
A: A city can have any names from as the variable type is string
Q: Question 2. (To be done using 'R’). For this question, you will have to work with Pima Indians…
A: I have to provide a solution to the above question.
Q: Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin (FruitID:…
A: The question is to choose the correct option from the given options in the question.
Q: Store the following fields for a library database: AuthorCode, AuthorName, BookTitle,…
A: The following fields have to be stored for a library database:…
Q: You are given the following database schema: Sailors(sid, sname, rating, age) Boats(bid, bname,…
A: Given Data : Number of pages in main memory = 9 Sailors : Tuples = 100000 pages = 1000 Sailors…
Q: Based on the following domain model class diagram, develop the relational database schemas. Owner…
A: Answer : I attached an relational schema please have a look once.
Q: Computer engineering labApexSOQL - salesforce object query languageWhy i am getting this error in…
A: Given: SOQL - salesforce object query language Why i am getting this error in the below query Here…
Q: Question 1 We need to create a web site for an online health center Create a database containing…
A: <?php$con = mysql_connect("localhost","fadi","abc123");if (!$con) { die('Could not connect: ' .…
Q: The following relational schema form a university database which is implemented in a relational…
A: Here have to determine about sql query for given problem.
Q: consists of undertak es NextOKin Paper frstname papercode Assessment lastnam e H relationship phone…
A: Required: We have to develop Sql queries according to the given database schema.
Q: We have the following functional dependency A -> B. The following is a well-formed database design.…
A: The answer is
Q: Consider the following relations for a Guest Room reservation application database. Room (room_id,…
A: Given Guest room reservation system contains two relations Room and Customer. Room relation contains…
Q: For these questions, there exists 4 relations: R(A,B,C), S(C,D), T(D,E,F), and U(B,G). The size of…
A: Solution : As per given data : 4 Relations are given below : R(A,B,C), S(C,D), T(D,E,F), and…
Q: We need to create a database for the Circulation Department of a public library. The database will…
A: The database schema would have the following structure (primary keys are italicised and foreign keys…
Q: QUESTION 5 Consider the database schema below. Fruit (ID: integer. Name: String (unique)) Vitamin…
A: Two tables are given with primary key ID in fruit table. Vitamin table has composite key fruitID…
Q: Consider the relational schema for a library system as given below: Member (mem _no, name, dob)…
A: Answer i)- select * from Member m where m.mem_no not in(select b.mem_no from Borrowed b); Answer…
Q: lotor Vehicle Dealership Database: Consider Aaron's dealership, a multi-brand vehicle deale atabase…
A: Below is the solution:-
Q: With the following Object Oriented Relational Database schema, select the attributes that a tuple in…
A: Actually, A relational database is a type of database that stores and provides access to data…
Q: Consider the following database schema for a library. Book (BookID:int, BookTitle:string(unique),…
A: CPR is the type of int
Q: 3) Draw a domain class diagram according to the below scenario: Suppose that you are designing a…
A: Actually, UML stands for Unified Modeling Language.
Q: Q2/ write the schema that descibes the following relations: 1- The course relation course id title…
A: Drawing the schema for given relation Here, PK means Primary Key and FK means Foreign Key.
Q: TRUE OR FALSE In the Relational Data Model, Referential Integrity Constraint is a special kind/case…
A: Solution: In the Relational Data Model, Referential Integrity Constraint is a special kind/case of…
Q: Consider the following schema for a company database and answer the following questions: DEPARTMENT…
A: Q1. SQL DDL statements CREATE DATABASE EmpDepProjDBGOUSE EmpDepProjDBGO CREATE TABLE…
Q: ere is the database design for the personnel data: employee(id, name, address) employeeMap(id,…
A: Actually, database is a used to stores the data\information.
Q: Question3-A: Map this ER Diagram into a relational schema and specify all primary keys and foreign…
A: The relational Schema is given below with primary and foreign keys
Q: Given the tables create table T (A int primary key, B int); create table U (C int primary key, A…
A: As mentioned: There are two tables. Table T and Table U Table T has A(P.K), B two columns. Table U…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- Computer Science Design an OO schema for a database application that you are interested in.Construct an EER schema for the application, and then create the corresponding classes in ODL. Specify a number of methods for each class, andthen specify queries in OQL for your database application.The following relations kind a part of a on-line database (the relations area unit self-explanatory): CUSTOMER/CLIENT/SHOPPERS/BUYERS(Cust#, CAddress, Ctown, Balance,Cname) ORDER(Order.#, Date, Cust#.) ORDERLINE(Order#, Part#., Amount-Ordered) PART(Part#., Desc, Stock, Item-Class, Unit -Price) Design a physical ER for the above scenario. With respect to this relative schema, write SQL statements for the subsequent queries: List the name of the client United Nations agency has placed Order 123 (i.e. Order: = 123). List the names of shoppers United Nations agency in Cardiff and have ordered half 456 (i.e. Part. 456). List the order numbers (Order) for orders that contain a minimum of three elements and also the quantity ordered are minimum of ten. List the outline (Desc), of these elements that the typical quantity ordered is bigger than the number ordered for half .6 (Part. = 456) so as 123.(Order. .123).Based on the following database schemas: Homestay (homestayNo (PK), homestayName, address, telNo, city)Room (roomNo, homestayNo (PK), type, price)Booking (homestayNo, guestNo (PK), dateFrom, dateTo, roomNo) Guest (guestNo (PK), guestName, guestAddress, guestTelNo) Assume the following indexes exist:a) a hash index with no overflow on the roomNo and homestayNo as a composite primary key in Room;b) a clustering index on the foreign key attributes homestayNo in Room;c) a B⁺-tree index on the price attribute in Room;d) a secondary index on the attribute type in Room. nTuples(Room) = 20000 bFactor(Room) = 200nTuples(Homestay) = 100 bFactor(Homestay) = 40nTuples(Booking) = 100000 bFactor(Booking) = 60nDistincthomestayNo(Room) = 50 nDistinctroomNo(Booking) = 150nDistincttype(Room) = 10…
- Based on the following database schemas:Homestay (homestayNo (PK), homestayName, address, telNo, city)Room (roomNo, homestayNo (PK), type, price)Booking (homestayNo, guestNo (PK), dateFrom, dateTo, roomNo)Guest (guestNo (PK), guestName, guestAddress, guestTelNo)Assume the following indexes exist:a) a hash index with no overflow on the roomNo and homestayNo as a composite primary key in Room;b) a clustering index on the foreign key attributes homestayNo in Room;c) a B+-tree index on the price attribute in Room;d) a secondary index on the attribute type in Room.nTuples(Room) = 20000 bFactor(Room) = 200nTuples(Homestay) = 100 bFactor(Homestay) = 40nTuples(Booking) = 100000 bFactor(Booking) = 60nDistincthomestayNo(Room) = 50 nDistinctroomNo(Booking) = 150nDistincttype(Room) = 10 nDistincthomestayName(Homestay) = 50nDistinctprice(Room) = 500 maxprice(Room) = 500minprice(Room) = 200 nLevelstype(I) = 2nLevelshomestayNo(I) = 2 nLfBlocksprice(I) = 50nLevelsprice(I) = 2 Log2100 = 6.64Log250 =…Based on the following database schemas: Homestay (homestayNo (PK), homestayName, address, telNo, city)Room (roomNo, homestayNo (PK), type, price)Booking (homestayNo, guestNo (PK), dateFrom, dateTo, roomNo) Guest (guestNo (PK), guestName, guestAddress, guestTelNo) Assume the following indexes exist:a) a hash index with no overflow on the roomNo and homestayNo as a composite primary key in Room;b) a clustering index on the foreign key attributes homestayNo in Room;c) a B⁺-tree index on the price attribute in Room;d) a secondary index on the attribute type in Room. nTuples(Room) = 20000 bFactor(Room) = 200nTuples(Homestay) = 100 bFactor(Homestay) = 40nTuples(Booking) = 100000 bFactor(Booking) = 60nDistincthomestayNo(Room) = 50 nDistinctroomNo(Booking) = 150nDistincttype(Room) = 10 nDistincthomestayName(Homestay) = 50nDistinctprice(Room)…Based on the following database schemas: Homestay (homestayNo (PK), homestayName, address, telNo, city)Room (roomNo, homestayNo (PK), type, price)Booking (homestayNo, guestNo (PK), dateFrom, dateTo, roomNo) Guest (guestNo (PK), guestName, guestAddress, guestTelNo) Assume the following indexes exist:a) a hash index with no overflow on the roomNo and homestayNo as a composite primary key in Room;b) a clustering index on the foreign key attributes homestayNo in Room;c) a B⁺-tree index on the price attribute in Room;d) a secondary index on the attribute type in Room. nTuples(Room) = 20000 bFactor(Room) = 200nTuples(Homestay) = 100 bFactor(Homestay) = 40nTuples(Booking) = 100000 bFactor(Booking) = 60nDistincthomestayNo(Room) = 50 nDistinctroomNo(Booking) = 150nDistincttype(Room) = 10…
- We have the following functional dependency A -> B. The following is a well-formed database design. MYTABLE (TheKey, A, B, C) True FalseQuestion 1 A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (CIT 170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The…Create a database Entity and Relationship Diagram (ERD) for the following application (Submitted An image of the Diagram By using Any Application:The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community. Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list of users Messager…
- branch(branchhame, branch+citysassets} customer (HD, Customer name, customer street, customer city) loan loan number branch_name, amounty borrower(ID; loan_number account (account_number, branch name, balance)e depositor (HDs account number)- Figure le Consider the bank database in Figure 1, where the primary keys are underlined. Each branch might have many loans or accounts, associated with borrowers or depositors, respectively. Construct the following SQL queries for this relational database. 1. Find the name of each branch that has at least one customer who has an account in the bank and who lives in the "Harrison" city. Make sure each branch name only appears once. 2. Find the ID of each customer who lives on the same street and in the same city as customer "12345". (1) Please use "tuple variables". e (2) Please use "derived relations" or “with". 3. Find the ID of each customer of the bank who has an account but not a loan. 4. Find the total sum of all loan amounts for each branch…Consider the following schema for a company database and answer the following questions: DEPARTMENT Dname Dnumber Mgr_ssn Mgr start date M EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Dno M WORKS ON Essn Pno Hours M PROJECT Pname Pnumber Plocation Q1//create all tables of this schema and apply any necessary constraints Q2// Write SQL statements that carry out the following tasks: 1-alter the employee table to add column city of 20 characters. 2- alter the employee table to apply the following business rule The minimum salary is 3000 and maximum salary is 10000 3- insert sample data in each table. 4- display a list of each employee SSN , Name and Salary. 5- display a list of each employee SSN, Name and Salary for employees working in department no 2.Store the following fields for a library database: AuthorCode, AuthorName, BookTitle, BorrowerAddress, BorrowerName, BorrowerCardNumber, CopiesOfBook, ISBN (International Standard Book Number), LoanDate, PublisherCode, PublisherName, and PublisherAddress. A one-to-many relationship exists between publishers and books. Many-to-many relationships exist between authors and books and between borrowers and books.a. Name the entities for the library database b. Without creating a set of dependency diagrams, write the relational schema that meet 3rd NF requirements. c. Draw the Crow’s Food entity-relationship diagram for the library database.