TutorMe homepage
Subjects
PRICING
COURSES
SIGN IN
Start Free Trial
Matthew W.
Business Analysis Unit Manager at EMS Service
Tutor Satisfaction Guarantee
SQL Programming
TutorMe
Question:

Create a view for a table, Acme with the following fields: acmeId int (primary key) num int descr int List all fields in the table, and combine the descr with the number field

Matthew W.
Answer:

create view [View_Acme] as select [View_Acme].[acmeId] ,[View_Acme].[num] ,[View_Acme].[descr] ,[View_Acme].[descr] + ': ' + CAST([View_Acme].[num] as nvarchar(64)) FROM [dbo].[Acme]

Databases
TutorMe
Question:

What are the names of the different types of key relationships that are used in modern relational databases?

Matthew W.
Answer:

Primary Key & Foreign Key

C Sharp Programming
TutorMe
Question:

Write a code snippet that show an example of how to properly store and print a dictionary the number of cars in an inventory segregated by color (make up data).

Matthew W.
Answer:

Dictionary<string, int> inventory = new Dictionary<string, int>; inventory.add("blue", 5); inventory.add("red", 15); inventory.add ("yellow", 5); inventory.add("purplue", 1); foreach (KeyValuePair<string, int> item in inventory) { Console.WriteLine("Cars of color {0}: {1}", item.Key, item.Value); }

Send a message explaining your
needs and Matthew will reply soon.
Contact Matthew
Ready now? Request a lesson.
Start Session
FAQs
What is a lesson?
A lesson is virtual lesson space on our platform where you and a tutor can communicate. You'll have the option to communicate using video/audio as well as text chat. You can also upload documents, edit papers in real time and use our cutting-edge virtual whiteboard.
How do I begin a lesson?
If the tutor is currently online, you can click the "Start Session" button above. If they are offline, you can always send them a message to schedule a lesson.
Who are TutorMe tutors?
Many of our tutors are current college students or recent graduates of top-tier universities like MIT, Harvard and USC. TutorMe has thousands of top-quality tutors available to work with you.