Question

In: Computer Science

(Q)Choose a DBMS that you’d like to use. Provide some evidences to show that you have...

(Q)Choose a DBMS that you’d like to use. Provide some evidences to show that you have some basic knowledge of the software. For instance, use the software to define a name and address database of your business associates, friends, classmates etc. You can use the following relation: (LAST NAME, FIRST NAME, SEX, ADDRESS, POSTCODE, CITY, PHONE). Enter at least five people in your data file. Print/screen shot a copy of the records. There should be no blank records. (20)

please mention which dbms that you used and please give detail explanation in the answer thank you.

Solutions

Expert Solution

I have used MySQL dbms.


Related Solutions

Baye suggests some ways to assess markets. Choose any market that you’d like and assess the...
Baye suggests some ways to assess markets. Choose any market that you’d like and assess the concentration of firms and its impact on competition. ~1-2 pages.
Identify some bottlenecks in DBMS performance and propose some solutions used in DBMS performance tuning. Provide...
Identify some bottlenecks in DBMS performance and propose some solutions used in DBMS performance tuning. Provide your recommendations and discuss some industry best practices.
Suppose that you have data on restaurant meal sales. You’d like to find out which type...
Suppose that you have data on restaurant meal sales. You’d like to find out which type of customer group – families or business meetings – generates the most sales. You also have data on which day of the week your observations come, the server who served them, and the drinks that they ordered. How would you write a regression model to test this relationship?
Program Slicing Assignment 1- Choose a program you’d like to analyze. Explain what the program’s purpose...
Program Slicing Assignment 1- Choose a program you’d like to analyze. Explain what the program’s purpose is and how many lines of code it has. 2- Browse the tools necessary for slicing and install if you haven’t already done so. If there is a problem with the tool, and you would not like to use it, explain: What the tool is used for, and why wouldn’t use it. 3- demonstrate static, dynamic, forward, and backward slicing using a slicing criterion....
We have provided you the Hotel database to be used with SQLite DBMS. You should use...
We have provided you the Hotel database to be used with SQLite DBMS. You should use this database in SQLite to extract the necessary information as per the following query requirements. The sqlite script is based on the following relational schema: •Hotel (hotelNo, hotelName, city) • Room (roomNo, hotelNo, type, price) • Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) •Guest (guestNo, guestName, guestAddress) Note the following details of the hotel database; •Hotel contains hotel details and hotelNo is the primary key;...
Do you think that Amazon is monopoly? Provide evidences to support your choice.  
Do you think that Amazon is monopoly? Provide evidences to support your choice.  
Q. In this question, you will do some resampling and show results in graphics. This is...
Q. In this question, you will do some resampling and show results in graphics. This is related to bootstrap technique. The population distribution is a normal with µ = 10 and σ^2 = 4. The statistic is the sample mean. Hence in theory we know exactly what the density function of the sample mean is. (a) Simulate a sample, say x, with sample size n=100. Report its mean, sd, min, and max. (b) Use R functions sample and replicate to...
You’d like to buy a house. You can borrow $600,000 but you can only afford to...
You’d like to buy a house. You can borrow $600,000 but you can only afford to make monthly payments of $2,750. The lender agrees to allow you to make this payment on a 30 year mortgage, but then you must make a balloon payment to cover any shortfall. What is the dollar amount you’ll still owe if your mortgage rate is 4.349% $154,611 $174,763 $189,305 $217,206
You’d like to buy a house. You can borrow $600,000 but you can only afford to...
You’d like to buy a house. You can borrow $600,000 but you can only afford to make monthly payments of $2,750. The lender agrees to allow you to make this payment on a 30 year mortgage, but then you must make a balloon payment to cover any shortfall. What is the dollar amount you’ll still owe if your mortgage rate is 4.349% $174,763 $217,206 $189,305 $154,611 You have $12,000 in credit card debt and have finally decided to start to...
You’d like to buy a small ranch when you retire in 40 years. You estimate that...
You’d like to buy a small ranch when you retire in 40 years. You estimate that in 40 years you’ll need $7 million to do so. If your savings can earn 1.1% per month, how much will you need to save each month (for 40 years), starting next month, in order to reach your goal? Round to the nearest cent. ​[Hint: Note that the question gives us the monthly interest rate. This is the periodic rate, which is i/m in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT