Topic read a text file and build a localdbproblem read a, Ask an Expert

Programming

Topic: Read a text file and build a localDB

Problem: Read a text file and build a localDB.

Entity Framework Database First - Build an app that executes a query against the Students table of the studentGrade database.

1. Create database file (name it as studentGrade.mdf ) and insert all records in text file csvDBData.txt. You may choose to use whichever way that you like to create/populate your database file.

Note: You should add extra records in your database.

"YourLastname, YourFirstname",JR,77,4,CSCI1170,1170,A,8,4

"YourLastname, YourFirstname",JR,77,4,CSCI2170,2170,A,8,4

2. LINQ to DB - Entity Framework Database First

Your program will generate:

List of students for each class Class (FR, SO, JR, SR) ordered by GPA (large to small) then ordered by CSCI GPA.

Each student detail to be displayed should have concatenated "Course" and "FinalGrade".

For example the record to display for "Barrett, Philip"

"Barrett, Philip",JR,87,1.6664, CSCI1000 B+ CSCI1160B CSCI1170D CSCIELLED B 1910B 1920 C MATHELLED B ,8,2

Attachment:- Assignment Files.rar

View complete question

DBMS, Programming

Category:- DBMS
Reference No.:- M92778735

Have any Question?Write your Review or question?

Related Questions in DBMS

You are responsible for keeping track of meal expenses for

You are responsible for keeping track of meal expenses for ten employees while at a business lunch to which your employer has invited you to attend. Write an algorithm that inputs the lunch costs for each the ten employe ...

Question sql injection is in the top 10 owasp and common

Question : SQL Injection is in the top 10 OWASP and Common Weakness Enumeration. Using MySQL and PHP, show your own very short and simple application that is vulnerable to this attack. Provide another version that mitiga ...

Question create an erd for the following scenarioa small

Question: Create an ERD for the following scenario. A small company ABC wants a database to keep track of internal company information. Â Given the following information create an ERD. The ABC Company has several departm ...

Case study problem 1 the case study company has experienced

Case Study: Problem 1 The case study company has experienced rapid growth in both the size of its client base and also in the services provided to clients. Unfortunately, the growth in data management policies, procedure ...

We can represent a data set as a collection of object nodes

We can represent a data set as a collection of object nodes and a collection of attribute nodes, where there is a link between each object and each attribute, and where the weight of that link is the value of the object ...

In sql developercreate a table userpermissions provide

IN SQL DEVELOPER Create a table UserPermissions (provide create and insert statements code) Document UserName Policy SYSTEM Menu JDOW W2 USAM Permissions SYSTEM W2 JDOW Form 1040 USAM Policy JDOW W2 SYSTEM Write a PL/SQL ...

Relational database exerciseyou have been assigned to a new

Relational Database Exercise: You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future. ...

Quesiton 1 what is data-manipulation language dml there are

Quesiton: 1. What is Data-Manipulation Language (DML)? There are four types of access in DML, explain each one. 2. Assume we have a Library Database consists of the following relations: author(author_id, first_name, last ...

You can work on this assignment individually or in a group

You can work on this assignment individually or in a group of 2. If you are working in a group please establish a group in Assignment 2 Group on Canvas In this assignment you are asked to explore the use of neural networ ...

Database and information retrieval assignment - data

Database and Information Retrieval Assignment - Data Privacy Essay Task - Write an essay (aim for 750 words) that addresses issues associated with data proivacy. Use the Australian Privacy Principles - discussed in class ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask DBMS Expert