Write requirements in detail of the following senerio. . An organization publish
ID: 3620784 • Letter: W
Question
Write requirements in detail of the following senerio.. An organization publishes a monthly magazine. The
magazine is mailed to subscribers. The organization keeps
the information about subscribers (annual subscription) in a
register. The clerk manages the subscription on the register
. The main task performed by the clerk on the register is to
keep the subscribers list updated. The common tasks
performed to keep the list updated are:
.INSERT (a new subscriber into the register)
.MODIFY (an existing subscriber record: Change in address)
. DELETE (an existing subscriber record)
. Design a software product so that the organization has an
updated computerized list of subscribers for delivery of the
magazine to current subscribers
Explanation / Answer
Dear, For monthly magazine application requires all cost, performance, standards need to check. Create few tables and maintain database. Check complaints from users and modify accordingly. If any user wats to removal from subscription delete. Create table Subscriber ( SubscID Number(3), SubscName Varchar2(20), Address Varchar2(30), Payment Number(5,2) ); Create Table SubscFeed ( SubscriberID Number(3), Feedback Varchar2(35), Complaint Varchar2(40) ) / When we create table with subscriber fields. Insert fields on it. with this command Insert into Subscribter Values(123, 'Raj', '10-09, Stvenger', $100); Delete fields from the table with this command Delete From Subscriber Where(SubscID = 231); Modify Table with this command Update Table Subscriber Set SubscName = 'Madhu" Where SubscID='123' ;
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.