Fundamentals of Information Systems
8th Edition
ISBN: 9781305082168
Author: Ralph Stair, George Reynolds
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 3, Problem 2PSE
Program Plan Intro
List of 10 entries in a single user
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The Motor Vehicle Department Database
The Motor Vehicle Branch administers driving tests and issues driver's licenses.
Any person who wants a driver's license must take a learner's exam at any Motor
Vehicle Branch in the province.
If he/she fails the exam, he can take the exam again any time after a week of the
failed exam date, at any branch.
If he passes the exam, he is issued a license (type = learner's) with a unique
license number.
A learner's license may contain a single restriction on it. The person may take
his driver's exam at any branch any time before the learner's license expiry
date (which is usually set at six months after the license issue date).
If he passes the exam, the branch issues him a driver's license.
A driver's license must also record if the driver has completed driver's education, for
insurance purposes.
Requirement Design an entity relationship diagram
for the motor vehicle department database and
build the design using a data modeling tool such as
Visio.
The Motor Vehicle Department Database
The Motor Vehicle Branch administers driving tests and issues driver's licenses.
Any person who wants a driver's license must take a learner's exam at any Motor
Vehicle Branch in the province.
If he/she fails the exam, he can take the exam again any time after a week of the
failed exam date, at any branch.
If he passes the exam, he is issued a license (type = learner's) with a unique
license number.
A learner's license may contain a single restriction on it. The person may take
his driver's exam at any branch any time before the learner's license expiry
date (which is usually set at six months after the license issue date).
If he passes the exam, the branch issues him a driver's license.
A driver's license must also record if the driver has completed driver's education, for
insurance purposes.
TASK:
Examples of the UNION operator, the use the DISTINCT operator.
TOPIC : DATABASE
Chapter 3 Solutions
Fundamentals of Information Systems
Ch. 3 - Prob. 1LOCh. 3 - Prob. 2LOCh. 3 - Prob. 3LOCh. 3 - Prob. 4LOCh. 3 - Prob. 1.1DQCh. 3 - Prob. 1.2DQCh. 3 - Prob. 1.1CTQCh. 3 - Prob. 1.2CTQCh. 3 - Prob. 2.1DQCh. 3 - Prob. 2.2DQ
Ch. 3 - Prob. 2.1CTQCh. 3 - Prob. 2.2CTQCh. 3 - Prob. 1SATCh. 3 - Prob. 2SATCh. 3 - Prob. 3SATCh. 3 - Prob. 4SATCh. 3 - Prob. 5SATCh. 3 - Prob. 6SATCh. 3 - Prob. 7SATCh. 3 - Prob. 8SATCh. 3 - _______________ is a special purpose programming...Ch. 3 - Prob. 10SATCh. 3 - Prob. 11SATCh. 3 - Prob. 12SATCh. 3 - Prob. 13SATCh. 3 - Prob. 14SATCh. 3 - An in-memory database (IMDB) is a database...Ch. 3 - Prob. 16SATCh. 3 - Prob. 17SATCh. 3 - Prob. 18SATCh. 3 - Prob. 19SATCh. 3 - Prob. 20SATCh. 3 - Prob. 1RQCh. 3 - In the hierarchy of data, what is the difference...Ch. 3 - Prob. 3RQCh. 3 - What is meant by data archiving? Why is this an...Ch. 3 - What is an entity-relationship diagram, and what...Ch. 3 - Identify four basic data manipulations performed...Ch. 3 - Prob. 7RQCh. 3 - Prob. 8RQCh. 3 - Prob. 9RQCh. 3 - Prob. 10RQCh. 3 - Prob. 11RQCh. 3 - Prob. 12RQCh. 3 - Prob. 13RQCh. 3 - Prob. 14RQCh. 3 - Prob. 15RQCh. 3 - Prob. 16RQCh. 3 - Prob. 17RQCh. 3 - Prob. 18RQCh. 3 - Prob. 19RQCh. 3 - Prob. 20RQCh. 3 - Prob. 21RQCh. 3 - Prob. 1DQCh. 3 - Outline some specific steps an organization might...Ch. 3 - 3. Briefly describe the ACID properties to which...Ch. 3 - Prob. 4DQCh. 3 - Prob. 5DQCh. 3 - Prob. 6DQCh. 3 - Prob. 7DQCh. 3 - Prob. 8DQCh. 3 - Prob. 9DQCh. 3 - Prob. 10DQCh. 3 - Prob. 11DQCh. 3 - Prob. 12DQCh. 3 - You have been hired to set up a database for a...Ch. 3 - Prob. 1PSECh. 3 - Prob. 2PSECh. 3 - Prob. 3PSECh. 3 - Using a graphics program, develop an...Ch. 3 - Prob. 1WECh. 3 - Prob. 2WECh. 3 - Prob. 1CECh. 3 - Prob. 2CECh. 3 - Prob. 1.1CSCh. 3 - Prob. 1.2CSCh. 3 - Prob. 1.1aCSCh. 3 - Prob. 1.2aCSCh. 3 - Prob. 2.1CSCh. 3 - Prob. 2.2CSCh. 3 - Prob. 2.1aCSCh. 3 - Prob. 2.2aCS
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- A book is identified by its ISBN number, and it has a title, a price, and a date of publication. It is published by a publisher, which has its own ID number and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time.arrow_forwardTable name: Products Column Role Data Type Length Constraint Name P ID Stores the ID of a product Number 8. Primary key P Name Stores the name of a product Varchar2 25 P_entryDate Stores the entry date of a product Stores the expiry date of a product Date Cannot be null P_Expiry P Expiry date should be greater than P entryDate Date P Price Stores the price of a product Number 3,2 Cannot be null a) Write in SQL a command that creates the table Products according to the above description (2 marks). b) Write in SQL a statement that adds to the table Products a new column named supplierID of type Number(5). This column should be defined as a foreign key that relates the table Products to the table Supplier (1.5 marks). c) Write in SQL a query that lists all the details of products arranged in descending order according to the entry date (1.5 marks).arrow_forwardEXPERIMENTAL PROCEDURE Patients visit the hospital and their visit history is maintained by the hospital staff. Different physicians may be available on different dates. They diagnose and treat the patients of all categories. Some of treatments are free while others are to be paid by the patients. Sample data of the case is shown in the following chart. Patient History Report PatientID Name Address Visit Date Physician Diagnosis Treatment P-100809 A City: X 12-02-2007 20-02-2007 29-02-2007 15-03-2007 Dr. Z Dr. F Dr. R Dr. L Chest Infection Cold Hepatitis-A Eyes Infection Free Free Paid Paid P-200145 N City: Y 10-01-2007 15-02-2007 25-03-2007 Dr. L Dr. K Dr. A Bone Fracture Cough Flu Paid Free Free Task 1 Draw a dependency diagram and transform the above data to first normal form by eliminating repeating groups such that each row in the relation is atomic. Be sure to create an appropriate name for the…arrow_forward
- A unique identifier for a data row that consists of more than one field is commonly called a: primary plus key composite primary key foreign key none of the abovearrow_forwardWhat is the price of the least expensive item in the database?arrow_forwardList all information for each order item. Include an item total, which can be calculated by multiplying the Quantity and Paideach columns. Use a column alias for the calculated value to show the heading Item Total in the output.arrow_forward
- An employee has only one job code, but a job code can be held by many employees. ERDarrow_forwardPATHS is a table that contains information about paths on a number line. The structure of PATHS is as follows, where x1 and x2 represent that there is a path from Coordinate x1 to Coordinate x2 (You can't move from Coordinate x2 to Coordinate x1 ). NAME ΤΥΡE NULLABLE X1 INT FALSE X2 INT FALSE Problem Please write an SQL statement that returns the beginning and end point of each path in PATHS . Sort them by the value of the beginning point in ascending order. Constraints • In the case where a direct path from Coordinate a to Coordinate b is available, no path from Coordinate b to Coordinate a will be given. |x1-x2| = 1 • No path will overlap with one another. Example Suppose that PATHS is as follows: x1 x2 1 2 2 3 4 7 7 6 This table can be visualized as follows: START END END START 7 8. 9 Therefore, your SQL statement must return the following: start end 1 4 8 6arrow_forwardQ9) find the least expensive priceQ10) List the UNIQUE v_code of vendors that provide productsQ11) find the most expensive priceQ12) List the number of products by vendor with the average price, include only the rows withaverage price below 10.00Q13) List all vendor rows (including the ones that have no matching products) and all matchingproduct rowsarrow_forward
- Computer Science A study conducted by Netflix’s consumer relations department has revealed that customers are more likely to review horror and thriller movies during certain months of the year. To discourage seasonal variations in these movie ratings, Netflix has called for your help to analyze horror and thriller movie rating counts over the past 15 years. Your query should display each month of the year (name of the month not the number) and the total number of ratings given during that month. A third column titled “Promotion Recommendation” determines whether a promotion should be applied to increase the number of ratings given during that month. If a month has less than 2200 ratings the final column should display ‘10% discount promotion’, if between 2201 and 4500 then display ‘5% discount promotion’, and if more than 4500 ratings then output ‘No Promotion’. Order your results by months. Do not hardcode the current date. ORALCE CODE PLEASE.arrow_forwardMatching Typearrow_forwardin a shop ,there are 10 employee and 20 kinds of goods,goods id between 1-20 EMPLOYEE id first name last name gender 10001, 'Tom', 'Brown', 'F'10002, 'Elizabeth', 'Tremblay', 'F'10003, 'Gladys', 'Julie', 'F10004, 'John', 'Taylor', 'M10005, 'Amelia', 'Smith'10006, 'Logan', 'Katherine'10007, 'Leo', 'Brown'10007, 'Lem', 'Thompson'10009, 'Tom' 'Smith'10010, 'Emma', 'Campbell' ------------ and I want to add a name library in it ,like this how could i create a HTML file ,with will randomly create customers with these employee . there is a start button on the page . press "start "bottom ,and it will It will randomly match 10 items, customers, and goods, display goods id ,customername and gender ,employer name , id and gender . how to do such a page ?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
- Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:CengageProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage LearningEnhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
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
How to Design DB Tables for any Application? (The Basics); Author: Studytonight;https://www.youtube.com/watch?v=XUdNVaSikqY;License: Standard YouTube License, CC-BY
Create a Table (Introduction to Oracle SQL); Author: Database Star;https://www.youtube.com/watch?v=BiV1IrzB1sY;License: Standard Youtube License