Question

In: Computer Science

what are teo attributes for financial aid, would either use as primary key why or why...

what are teo attributes for financial aid, would either use as primary key why or why not

two

1st part what are the two attributes for financial aid?

2nd whould either of them use a primary key why or why not?

Based on your knowledge/experience with a College application, Financial aid application, or your College Transcript, what two ATTRIBUTES/FIELDS do you think might be stored in a Student Database? Would either of your attributes be able to serve as a Primary Key? Why or why not?

Solutions

Expert Solution

Financial Aid refers to the support or help to the students in the form of scholarship, placements or loans in order to meet the financial obligations of a student. A Financial Aid can have attributes like name(name of student), course, amount(scholarship amount) etc regarding the student. For deciding the primary key for Financial Aid relation or table, we can provide studentid as the primary key as it will not have same value for any two students.

A student can have two attributes : studentid, rollno either of these can be used as a primary key as both will not have same values for any two students at any time. Moreover a Student database can also hold attributes like name, course, address, marks etc. The primary key for student database will be used to refer another relation or table uniquely.


Related Solutions

What is an input mask used for? What is the purpose of a primary key? Why...
What is an input mask used for? What is the purpose of a primary key? Why is redundancy of data undesirable? What is a wildcard character? How would you use it to find a record?
what is solvency ratio? why would a financial institution or investor use this ratio? what would...
what is solvency ratio? why would a financial institution or investor use this ratio? what would the ratio results tell you about this business?
what is super key,  candidate key, and primary key, and foreign key in terms of database? and...
what is super key,  candidate key, and primary key, and foreign key in terms of database? and plz provide some examples, thanks.
What options would you use to gain financial capital for a real estate business? Why? What...
What options would you use to gain financial capital for a real estate business? Why? What are the positives and negatives to the funding options you chose, and how could that possibly impact your business?
What is a financial market? What is a financial institution? Why are they so important? Would...
What is a financial market? What is a financial institution? Why are they so important? Would you let one or many financial institutions fail?
What is the primary goal of management? What are the primary tasks of a Chief Financial...
What is the primary goal of management? What are the primary tasks of a Chief Financial Officer (CFO) and others in finance function of an organization?
List and describe the key features of the 3 primary financial statements. Is the balance sheet...
List and describe the key features of the 3 primary financial statements. Is the balance sheet a report over a period of time or at a specific point in time? What about the income statement?
1. What are the key components to GAAP? Why is it important that GAAP governs financial...
1. What are the key components to GAAP? Why is it important that GAAP governs financial reporting?
An audit team would be most likely to use attributes sampling in which of the following...
An audit team would be most likely to use attributes sampling in which of the following situations? Multiple Choice a. Performing analytical procedures during the planning stages of the audit. b. Evaluating management's integrity during the client acceptance process. c. Determining the effectiveness of the audit committee in evaluating the entity's control environment. d. Examining purchase requisitions for proper authorization.
What are some of the key arguments for increased aid funding to low-income countries?
  What are some of the key arguments for increased aid funding to low-income countries? What are some debates on what this aid should look like?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT