Pearson eText for Computer Science: An Overview -- Instant Access (Pearson+)
13th Edition
ISBN: 9780137503216
Author: Glenn Brookshear, Dennis Brylow
Publisher: PEARSON+
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 9CRP
Program Plan Intro
Relational
- A database Management System is a software application for managing the database in a well-organized form.
- It provides a systematic way to create, retrieve and update the database.
- In DBMS, the schema explains the logical structure of the data base system.
- It provides the capability to the user to self-analyze the database and perform the necessary operations.
- A relational database comprises of rectangular tables known as relations.
- Every row in relation is known as tuple.
- Each column in table is termed as field or attribute.
- It describes the characteristics of entity represented by corresponding tuple.
Relational database design process:
- It is designed to meet requirements of particular application.
- There are no two databases that are alike.
- The design choice is based on user preference.
- The steps used in this process includes:
- Step 1 – Define the database purpose
- Step 2 – Gather data and organize in table
- Step 3 – Refine and normalize design, it includes adding columns, creating new relation and splitting large relation into smaller relations.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The following tables describe the content of a relational database:
SQL DDL corresponding to this schema (i.e. the CREATE TABLE statements
Database Schema:branch ( branch_name, branch_city, assets )customer ( ID, customer_name, customer_street, customer_city )loan ( loan_number, branch_name, amount )borrower ( ID, loan_number )account ( account_number, branch_name, balance )depositor ( ID, account_number )
Question
A city college would like to maintain their academic information in a MySql database system. The following are the interested information:
Courses:
Catalog # (M170 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 class…
Chapter 9 Solutions
Pearson eText for Computer Science: An Overview -- Instant Access (Pearson+)
Ch. 9.1 - Identify two departments in a manufacturing plant...Ch. 9.1 - Prob. 2QECh. 9.1 - Summarize the roles of the application software...Ch. 9.2 - Prob. 1QECh. 9.2 - Prob. 2QECh. 9.2 - Prob. 4QECh. 9.2 - Prob. 5QECh. 9.2 - Prob. 6QECh. 9.3 - Prob. 1QECh. 9.3 - What is a persistent object?
Ch. 9.3 - Identify some classes as well as some of their...Ch. 9.3 - Prob. 4QECh. 9.4 - Prob. 1QECh. 9.4 - Prob. 2QECh. 9.4 - Prob. 3QECh. 9.4 - Prob. 4QECh. 9.4 - Prob. 5QECh. 9.4 - Prob. 6QECh. 9.5 - Prob. 1QECh. 9.5 - Prob. 2QECh. 9.5 - Prob. 3QECh. 9.5 - Prob. 4QECh. 9.5 - Prob. 5QECh. 9.5 - Prob. 6QECh. 9.5 - Prob. 7QECh. 9.6 - Prob. 1QECh. 9.6 - Give an additional example of a pattern that might...Ch. 9.6 - Prob. 3QECh. 9.6 - How does data mining differ from traditional...Ch. 9.7 - Prob. 1QECh. 9.7 - Prob. 2QECh. 9.7 - Prob. 3QECh. 9.7 - Prob. 4QECh. 9 - Prob. 1CRPCh. 9 - Prob. 2CRPCh. 9 - Prob. 3CRPCh. 9 - Prob. 4CRPCh. 9 - Prob. 5CRPCh. 9 - Prob. 6CRPCh. 9 - Prob. 7CRPCh. 9 - Prob. 8CRPCh. 9 - Prob. 9CRPCh. 9 - Prob. 10CRPCh. 9 - Prob. 11CRPCh. 9 - Prob. 12CRPCh. 9 - Using the commands SELECT, PROJECT, and JOIN,...Ch. 9 - Answer Problem 13 using SQL. PROBLEM 13 13. Using...Ch. 9 - Prob. 15CRPCh. 9 - Prob. 16CRPCh. 9 - Prob. 17CRPCh. 9 - Prob. 18CRPCh. 9 - Prob. 19CRPCh. 9 - Empl Id Name Address SSN Job Id Job Title Skill...Ch. 9 - Empl Id Name Address SSN Job Id Job Title Skill...Ch. 9 - Prob. 22CRPCh. 9 - Prob. 23CRPCh. 9 - Prob. 24CRPCh. 9 - Prob. 25CRPCh. 9 - Write a sequence of instructions (using the...Ch. 9 - Prob. 27CRPCh. 9 - Prob. 28CRPCh. 9 - Prob. 29CRPCh. 9 - Prob. 30CRPCh. 9 - Prob. 31CRPCh. 9 - Prob. 32CRPCh. 9 - Prob. 33CRPCh. 9 - Prob. 34CRPCh. 9 - Prob. 35CRPCh. 9 - Prob. 36CRPCh. 9 - Prob. 37CRPCh. 9 - Prob. 38CRPCh. 9 - Prob. 39CRPCh. 9 - Prob. 40CRPCh. 9 - Prob. 41CRPCh. 9 - Prob. 42CRPCh. 9 - Prob. 43CRPCh. 9 - Prob. 44CRPCh. 9 - Prob. 45CRPCh. 9 - Prob. 46CRPCh. 9 - Prob. 47CRPCh. 9 - Prob. 48CRPCh. 9 - Prob. 49CRPCh. 9 - Prob. 50CRPCh. 9 - Prob. 51CRPCh. 9 - Prob. 52CRPCh. 9 - Prob. 53CRPCh. 9 - Prob. 54CRPCh. 9 - Prob. 55CRPCh. 9 - Prob. 56CRPCh. 9 - Prob. 57CRPCh. 9 - Prob. 58CRPCh. 9 - Prob. 59CRPCh. 9 - Prob. 60CRPCh. 9 - Prob. 61CRPCh. 9 - Prob. 62CRPCh. 9 - Prob. 1SICh. 9 - Prob. 2SICh. 9 - Prob. 3SICh. 9 - Prob. 4SICh. 9 - Prob. 5SICh. 9 - Prob. 6SICh. 9 - Prob. 7SICh. 9 - Prob. 8SICh. 9 - Prob. 9SICh. 9 - Prob. 10SI
Knowledge Booster
Similar questions
- name PERSON address salary fee EMPLOYEE STUDENT thesis RESEARCH TEACHING POST GRAD UNDER GRAD Year = 4 FINAL YEAR LECTURER TUTOR SUPERVISOR project courseno PART II: University Database in MYSQL • Create a database and its tables and constraints based on the relational model of PART I. • You can use my slides and any other resources to complete this exercise. • Submit the SQL statements you used to create the database and its tables (you can copy/paste directly from the mysql console).arrow_forwardThe following four tables form part of a library database: • Book (isbn, title, author, genre, price) • Copy (copyId, isbn) • Loan (userId, copyId, loanDate, dueDate) • User (userId, name, address, email) Where: • Book contains details of books and isbn is the primary key• Copy contains details of individual copies of books and copyId is the primary key• Loan contains details of loans and (userId, copyId, loanDate) forms the primary key • User contains details of library users and userId is the primary key 3.1 Identify the primary in the above schema. 3.2 Identify the foreign keys in the above schema. 3.3 Draw an Entity relationship model (ER-model) for the above schema, including: • all attributes• correct notation for primary and foreign keys • relationships• multiplicities 3.4 Draw sample tables for the above relations, ensuring relational integrity rules are met. 3.5 Explain the Entity Integrity constraint with reference to the Book relation.arrow_forwardThe relational schema shown below is part of a hospital database. The primary keys are highlighted in bold. Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Contains (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate) for CONTAINS nad PRESCRIBED table , which one is primary key and how to create table ?arrow_forward
- Subject: DatabaseQuestion: Draw an ERD based on the given infoarrow_forwardExplainarrow_forwardWrite the following queries in SQL on the relational database schema for COMPANY database given in page 4. Find the name of employees who have salary less than the average salary of employees who are in department 4.arrow_forward
- ormulate the following queries in Structured Query Language SQL The following tables form part of a database held in an RDBMS: Employee (empNo, fName, lName, address, DOB, sex, position, salary, deptNo) Department (deptNo, deptName, mgrEmpNo) Project (projNo, projName, deptNo) WorksOn (empNo, projNo, dateWorked, hoursWorked) where Employee contains employee details and empNo is the key. Department contains department details and deptNo is the key. mgrEmpNo identifies the employee who is the manager of the department. There is only one manager foreach department. Project contains details of the projects in each department and the key is projNo (notwo departments can run the same project). WorksOn contains details of the hours worked by employees on each project, and empNo/ projNo/dateWorked form the key. Formulate the following queries in Structured Query Language SQL List all the details of employees who are female and born after 1990. List employee numbers and names of all…arrow_forwardA database at a college must support the following requirements: a. For a department, store its number and name. b. For an advisor, store his or her number, last name, first name, and the department number to which the advisor is assigned. c. For a course, store its code and description (for example, DBA210, SQL Programming). d. For a student, store his or her number, first name, and last name. For each course the student takes, store the course code, course description, and grade earned. Also, store the number and name of the student's advisor. Assume that an advisor might advise any number of students but that each student has just one advisor. Design the database for the preceding set of requirements. Determine any functional dependencies. List the tables, columns, and relationships. In addition, represent your design with an E-R diagram.arrow_forwardThe relational schema shown below is part of a hospital database. The primary keys are highlighted in bold. Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Contains (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate) Formulate the following SQL statements: a) Find the names of all the patients being prescribed ‘Morphine’.b) What is the total cost of Morphine supplied to a patient called ‘John Smith’?c) For each ward that admitted more than 10 patients today, list the ward number, ward type and number of beds in each ward.arrow_forward
- Specify all the relationships among the records of the database shown in Figure 1.arrow_forwardIn a relational database, the number of columns in a table that are able to satisfy the constraints that have been defined may be decreased by the use of an operation called select. Which is it: the right answer or the erroneous answer?arrow_forwardA relational database has the following schema: Customer (Cno, name, address, age, loan_type, loan_amount, year) Solve following queries in relational algebra: Select the records where loan_type is 'Personal'. Select the records where age is geater than 30 and loan_type is ‘soft’. Select records from Customer table where loan_type is ‘Personal' and loan_amount is Rs200000 or those customers who opened an account after 2017. Project the columns name and address from the Customer table.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
- Enhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning