View the step-by-step solution to:

Assignment No. 02 Due Date: Uploading instructions: Assignment should be in .doc format. bx020200786. Assignment submission through email is highly...

You have the following scenario in which bank maintains their ATM information.

You are given three tables:
ATM_Acc (Table of ATM Card Account), Person (Table of the Person Detail), Transactions_Details:

1. ATM_Acc: atmcardno, bankacc_no, person_id, pin_code, branch_name, branch_id, security_question, issue_date, expiry_date, card_type, card_limit, multiple_transaction, status_of_card.
2. Person: person_id, name, temp_addr, permanent_addr, phone_no, mobile_no, father_name, date_of_birth, NIC.
3. Transaction_Details: amount, bankacc_no, date, branch, balance, atmcardno,

Assignment No. 02 Due Date: Your assignment must be uploaded/submitted before or on 06-05-2010 . Uploading instructions: Please view the Assignment Submission Process document provided to you by the Virtual University for uploading assignments. Assignment should be in .doc format. Save your assignment with your ID (e.g. bx020200786.doc). Assignment submission through email is highly discouraged. Rules for Marking: It should be clear that your assignment will not get any credit if: The assignment is submitted after due date. The submitted assignment file is corrupted. The assignment is copied. Note: Your answer must follow the below given specifications. You will be assigned zero marks if you do not follow these instructions . Font style: “Times New Roman” Font color: “Black” Font size: “12” Bold for heading only. Font in Italic is not allowed at all.
Background image of page 1
No formatting or bullets are allowed to use. Assignment: (Marks:20) You have the following scenario in which bank maintains their ATM information. You are given three tables: ATM_Acc (Table of ATM Card Account), Person (Table of the Person Detail), Transactions_Details : 1. ATM_Acc: atmcardno, bankacc_no, person_id, pin_code, branch_name, branch_id, security_question, issue_date, expiry_date, card_type, card_limit, multiple_transaction, status_of_card. 2. Person: person_id, name, temp_addr, permanent_addr, phone_no, mobile_no, father_name, date_of_birth, NIC. 3. Transaction_Details: amount, bankacc_no, date, branch, balance, atmcardno, Note: ATM transaction can only be performed from the bank which issued the person ATM card. You can consult the tables given in lecture slides (ppt slides for lecture # 11) to determine the complexity of ILF, EIF, EI, EO, and EQ: You should consider only the above given tables for the following operations being performed: Add a ATM card (with all its details) Delete the record of a ATM Card Update the record of the ATM card Add a new person (with all its details) in the system Do the transaction using ATM Card. Generate a report that shows the number of Transactions between two given dates.
Background image of page 2
Show entire document

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question