Consider a database for a bank, including mation about customers and their accounts. Infor- mation about a customer includes their name, ad- dress, phone, and Social Security number. Accounts have numbers, types (e.g., savings, checking) and balances. Also record the customer(s) who own an account.

Consider a database for a bank, including mation about customers and their accounts. Infor- mation about a customer includes their name, ad- dress, phone, and Social Security number. Accounts have numbers, types (e.g., savings, checking) and balances. Also record the customer(s) who own an account.

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

Consider the following database schema for University Library database. A student can borrow many books and a given book can be borrowed by any student if it is available in the library. For each borrowing, the borrowing and return dates are registered in the database. Student (SID: long, CPR:long (unique), Name:string, tel:number, major:String, gender:Character {'F' or 'M'}) Book (ISBN:long Title:string (unique), Author:string) BorrowedItems(stSID:long, book|SBN:long, serialNo:int (unique), BorrowingDate:date, ReturnDate:date) Write SQL statements to: 1. List ISBN, Title, Author of all books that include the word 'Database' in their titles in a descending order of ISBN. 2. List SID, Name, and Major of all female students doing major in CS'and their name starts with 'S'. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
You are given the requirement for a simple database for the national football league(NFL). The NFL has many teams, and each team has a name, a city, a coach, a captain and a set of players. Each players belong to only one team and each player has a name, a position (such as left wing, mid fielder or a goal keeper) , a skill level, and a set of injury records. A team captain is also a player who guide other player and a game is played between two teams(referred as host team and guest team) and has a match date( such as june 11, 2018) and score (such as 2 to 5) Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.
Let's say there is only room for one student in a course, and two people are seeking to sign up. What property of a database system makes it impossible for both students to be placed in the last open seat?
Consider a situation where there is one open seat in a class with two enrolled pupils. Why can't both students in a database system be assigned to the last seat that is open?
A database about magazine subscribers typically contains a list of subscribers to each magazine but does not contain a list of those who do not subscribe. How then does such a database determine that a person does not subscribe to a particular magazine?
Consider a database that includes four relations Student, Staff, Program, Advisor Student BannerID FName LName PCode 8003778543 James Oloye PO01 8765990453 Paul Carter P002 8002786543 Anita Boris PO01 8307563321 Jane Eyre P001 Staff BannerID FName LName PCode 8014768954 Chimamanda Adichie PO02 8001876565 Paulette Davis P001 Program PCode PName PO01 Library Science PO02 Management and Information Science
ASSESSMENT 02 1. You are required to design and implement a database system for a pharmacy shop with only one branch. The following is the description from the manager, Mr. Seth Akoto. "here, medicines that require prescriptions are sold only to people that have prescriptions. It is the pharmacy attendant that serves customers when they enter the pharmacy. Usually, people walk in and either give the prescription or mention the medicine they wish to purchase. The worker then searches to see if the medicine is in stock. If in stock, worker accepts payment from customer and gives the medicine and a receipt to the customer.“ 1. Determine all the entities from the description given by Mr. Akoto. 2. Assuming Mr. Akoto only wants a database system that would keep records of medicine{name of medicine, amount in grams in stock} and purchases{medicine bought, amount in grams bought, who attended to customer, when it was sold, contact and name of customer that bought the medicine} a. Draw and ER…
Let's say there is only room for one student in a course, and two people are seeking to sign up. What property of a database system makes it impossible for both students to be placed in the last open seat?
Imagine a database of students where the StudentID is the main key, and there are other indexes on Major, Age, Marital Status, and HomeZipCode (all secondary keys). Let's assume the institution wanted a list of MIS or computer science majors who were over 25 and married and were from the 45462 postcode code OR computer engineering majors who were single and were from the 45462 zip code. In any case, they wanted the list to come from the 45462 zip code. How can indexes be used to guarantee that individuals will only have access to the info that fulfills this prerequisite?
The problems for this chapter use a database for a simple department store that sells items to customers and wants to keep track of the invoices, the selling price (if an item is on sale), and the sales tax (7%) to be collected on some items. Every customer and invoice are assigned unique numbers. All items have a Universal Product Code (UPC) number and bar-code assigned to each unique item. Food and non-carbonated beverages are not taxed, but clothing, home goods, and most other items are.
An E-learning website needs your help to design its database. They need to store information about teachers and online tutorials. Each teacher has a unique ID, name, and at least one field of specialty. Teachers form groups to prepare online tutorials. Each group has unique name and at least one teacher as a member. Each online tutorial has a title, date and organized by exactly one group. The title of the tutorial is unique for the group. Each tutorial consists of several sessions, described by their titles and durations. Naturally, each session is presented by one teacher and belongs to exactly one tutorial. In addition, sessions on the same tutorial have different titles. Design an ERD for this application. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.
Consider the following database scheme Employee (SSN, fname, lname, salary, deptno) Department (deptno, dname, total_salary) Where total salary is a derived attribute that represents the total salary of employees working in a specific department. Write a trigger to compute the total_salary in the event of inserting one or more new employee record(s) in the employee table.