Credit score not only determines whether one can get a loan, but also affects how much on

rt.

ns.

w car, house, computer, or get a student loan. However, that there is a special number that can determine whether you can do these things, or at least how much it will cost you. A credit score is a number that is calculated based on your credit history to give lenders a simpler "lend/dont lend" answer for people who are applying for credit or loans. This number helps the lender identify the level of risk they may be taking if they lend to someone. The credit score is quicker and less subjective. Its the credit score that makes it possible to get instant credit at places like electronics stores and department stores. [B] Although there are several scoring methods, the method most commonly used by lenders is known as a FICO because of its origins with Fair Isaac Corporation. Fair Isaac is an independent company that came up with the scoring method and software used by banks and lenders, insurers and other businesses. Each of the three major credit bureaus (Experian, Equifax and TransUnion) worked with Fair Isaac in the early 1980s to come up with the scoring method. [C] The three national credit bureaus each have their own version of the FICO score with their own names. Equifax has the Beacon system, TransUnion has the Empirica system, and Experian has the Experian/Falr Isaac system. Each is based on the original Fair Isaac FICO scoring method and produces equivalent numerical results for any given credit report. Some lenders also have their own scoring methods. Other scoring methods may include information such as your income or how long youve been at the same job. [D] Think of your credit score, like your grade in school. A teacher calculates grades by taking scores from tests, homework, attendance and anything else they want to use, weighting each one according to importance in order to come up with a final single number (or letter)score. Your credit score is calculated in a very similar manner. Instead of using the scores from pop quizzes and reports you wrote, it uses the information in your credit report. [E] 35 percent of the score is based on your payment history. This makes sense since one of the primary reasons a lender wants to see the score is to find out if (and how timely)you pay your bills. The score is affected by how many bills have been paid late, how many were sent out for collection, any bankruptcies, etc. When these things happened also comes into play. The more recent, the worse it will be for your overall score. [F] 30 percent of the score is based on outstanding debt. How much do you owe on car or home loans？ How many credit cards do you have that are at their credit limits？ The more cards you have at their limits, the lower your score will be. The rule of thumb is to keep your card balances at 25% or less of their limits. [G] 15 percent of the score is based on the length of time youve had credit. The longer youve had established credit, the better it is for your overall credit score. Why？ Because more information about your past payment history gives a more accurate prediction of your future actions. [H] 10 percent of the score is based on the number of inquiries on your report. If youve applied for a lot of credit cards or loans, you will have a lot of inquiries on your credit report. These are bad for your score because they indicate that you may be in some kind of financial trouble or may be taking on a lot of debt (even if you havent used the cards or gotten the loans). The more recent these inquiries are, the worse for your credit score. FICO scores only count inquiries from the past years. [I] 10 percent of the score is based on the types of credit you currently have. The number of loans and available credit from credit cards you have makes a difference. There is no magic number or combination of types of accounts that you shouldnt have. These actually come more into play if there isnt as much other information on your credit report on which to base the score. This information is compared to the credit performance of other consumers with similar histories and profiles. [J] Your credit score doesnt just affect whether or not you get a loan; it also affects how much that loan is going to cost you. As your credit score increases, your credit risk decreases. This means your interest rate decreases. There are other factors that influence the interest rate you get for a loan besides your credit score. Things like the type of property you are using the loan to buy, how much of your own money is going into it, the costs the lender has to make the loan, etc. [K] In. addition to banks and lenders, there are landlords, merchants, employers and insurance companies jumping on the credit score bandwagon (风靡的活动). Of all of these, the fact that insurance rates are being determined by credit scores is causing consumers the most alarm. To most, it seems that your credit history and your driving record have little in common. Insurers, on the other hand, have found that using credit scores to predict how likely someone is to pay premiums has helped them cut their losses. They dont use the same score that banks and lenders use, however. They use a slightly different formula for their calculations and actually call it an "insurance score".[ LJ Credit scores arent static numbers. Because they are calculated based on your current credit report, they change every time your credit report changes. While this change may be very slight, it can also be much more dramatic. Here are some things some financial advisers say to do to try to improve your score. [M] Review your credit report and correct any errors you find. Getting rid of inaccurate information can sometimes improve your score dramatically. [N] Advice used to be given to close old and unused credit card accounts in order to reduce your "potential" available credit, which could change your debt ratio after youve been approved for a loan. Now, however, the ratio of your debt to your credit limit is more critical, so closing old accounts only raises that ratio-which you dont want to do. Some people have moved debt from several credit cards to one card and then closed the old accounts. Since creditors look at the debt-to- credit limit ratio, this can have a bad affect on your credit score because you have the same amount of debt but less available credit. So dont close old credit card accounts just because youre not using them. [O] Creditors also now look at the average age of your accounts so, again, keep those old accounts. Reduce your balances on credit cards to 75% or less of your available credit (25% is preferable). Pay your bills on time. (This is probably the most important of all!)Dont let anyone make an inquiry on your credit report unless you absolutely have to. The more inquiries, the lower your score. Dont open new credit card accounts just to increase your available credit in the hopes of raising your score. Also, remember that some improvements-such as better efforts at making payments on time-may take time to impact your score. So, time is also a factor. The credit score based on ones payment history accounts for 35 percent.

已知有下面三张表：

Student(Sno,Sname,Sage,Ssex,Sdept) 学生表

其中Sno：学号;Sname：学生姓名;Sage：学生年龄;Ssex：学生性别;Sdept:学生所在系。

Course(Cno,Cname,Credit) 课程表

其中Cno：课程编号;Cname：课程名字;Credit：学分。

SC(Sno,Cno,Score) 选课成绩表

Sno：学号;Cno:课程编号;Score：成绩。

根据以上的内容，写出以下问题的SQL语句。

1.查询全体学生的学号与姓名。

2.查询所有年龄在20岁以下的学生姓名及其年龄。

3.查询选修1号课程的学生最高分数。

4.查询选了至少3门课的同学的姓名和所在系。

5.查询选修了课程名为“信息系统”的学生学号和姓名。

A.光线路终端

B.光网络单元

C.光网络终端

D.光分配网络

A.FC/PC

B.SC/PC

C.FC/APC

D.SC/APC

A.select * from student where score＞60 and score＜80;

B.select * from student where score between 80 and 60;

C.select * from student where score＞= 60 or score＜=80;

D.select * from student where score＞= 60 and score＜=80;

A.select student_id,student_name,sum(score) from student where score＜60 order by score;

B.select distinct student_id,avg(score) from student where score＜60 order by avg(score);

C.select student_id,student_name,avg(score) av from student where score＜60 group by student_id order by av asc;

D.select student_id,student_name,avg(score) av from student group by student_id where score＜60 order by av asc;