QUESTION 2 a. Differentiate between () Single value and multiple valued atribute. (n) Relational Database and Objected Oricnted Databause b. What is a database? C. Consider the following relations with underlined primary keys. Product(PCode, Description, Stocking date, QpOnlland, MinQy, Price, Discount, VCode) Vendor(YCode, Name, Address, Phone) Here a vendor can supply more than one prodact but a product is supplied by only one vendor. Write SQL queries for the following ) List the names of all the vendors who supply more than one product. (6) List the details of the products whose prices exceed the average product price. (i) List the Name, Address and Phone of the vendors who are currently Jof 4

QUESTION 2 a. Differentiate between () Single value and multiple valued atribute. (n) Relational Database and Objected Oricnted Databause b. What is a database? C. Consider the following relations with underlined primary keys. Product(PCode, Description, Stocking date, QpOnlland, MinQy, Price, Discount, VCode) Vendor(YCode, Name, Address, Phone) Here a vendor can supply more than one prodact but a product is supplied by only one vendor. Write SQL queries for the following ) List the names of all the vendors who supply more than one product. (6) List the details of the products whose prices exceed the average product price. (i) List the Name, Address and Phone of the vendors who are currently Jof 4

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

All of you must be familier with human resources system (employee database). Soplease design database for a human resources system that at least has 4 entitiesinvolved and for the 4 entities please do the following:a. Create the tables that conform to 3NF.b. Draw the Crow’s Foot ERD to reflect the dependency and relationshipdiagrams;c. For all entities/tables created please write the MASTER and TRANSACTIONdata accordingly!d. Use SQL commands to to do selection which involve 1 table, 2 tables, and 3tables.
I want to create logical database design: 1. Normalize the relations to at least third normal form (3NF) using proper standard E-R diagram notation. Provide the appropriate relational schema reduction. 2. Identify the primary and foreign keys for each relation (using appropriate notation). Maybe either list the primary and foreign keys or generate a schema diagram??? 3. Identify and describe any indexes needed to speed up searches on non-key attributes – can you explain it too? So I would understand why you come up with the answer please? 4. Identify and describe unique, conditional (check), non-null, referential integrity, or other constraints needed to guarantee the integrity of the database. 5. Describe the set of business or workflow rules applicable to your project. Next, describe at what point in the workflow you will implement the business or workflow logic and the justification for doing so.Below are my conceptual design.
7. In the context of database design, consider the following scenario: There is database table that contains columns for employee ID, employee name, department, department location, and project details. Upon analyzing the table, you notice that there are multiple rows with the same employee name, department, and department location, but different project details. Based on this scenario, which of the following best describes the normalization process that should be applied to improve the database design? A) Split the table into two: one containing employee ID and employee name, and the other containing department, department location, and project details. B) Combine all columns into a single table to reduce redundancy. C) Normalize the database to the third normal form by creating separate tables for employee details, department details, and project details, and establish relationships between them. D) No action is required as the table already follows the normalization principles.
a) If you were designing a Web-based system to make airline reservations and sell airline tickets, which DBMS architecture would you choose and why? Why would the other architectures not be a good choice? b) Specify all the relationships among the records of the database shown in Figure 1. c) Discuss the differences between the candidate keys and the primary key of a relation. d) Write SQL update statements to do the following on the database schema shown in Figure 1.i. Insert a new course, <‘Knowledge Engineering’, ‘CS4390’, 3, ‘CS’>.ii. Delete the record for the student whose name is ‘Smith’ and whose student number is 17.
Take a few minutes to examine the sample completed survey. Based on your understanding of the sample data in this file, design a database through the following process: 1- What is your database design solution in the third normal form? How does your solution meet the requirements of third normal form? Support your third normal form design with your assumptions and your understanding of the given sample data.
Complete a database design for both the Invoice_printed and Real Estate Agent Listings problems / cases. Display your normalized tables as as demonstrated in the following format: TABLENAME(Field 1 (pk), Field 2, Field 3........)
Don't copy again and again that is wrong. Please help me with this question.
4) List all candidate keys of the books relation. 5) List all of the candidate keys of the publishes relation. 6) List all of the superkeys of the publishes relation. 7) Are there any attributes in considered logically non-atomic? Briefly explain why or why not. 8) Assuming tuple (4,83,200,1990) into the publishes table failed. Why did this happen? What database principle was violated?
urgent The below entity consist one of multivalued attribute. Identify the multivalued attribute and solve the problem cause by multivalued attribute into a more proper database design.
Discuss the concept of normalization in database design. Why is it important, and what are the normal forms up to 3NF?
In the definition of a relational database, explain what is meant by "normalized relations" ?