Design the database using the given fields and criteria

Assignment Help Database Management System
Reference no: EM131132159

Create an Android app that will be used to enter student grades for college courses.

Develop three screens as follows:

• The first screen should allow the entry of a student id, first name, last name, class id, and class name.

• The second screen should allow the entry of a grade for each student and class that they took. The grade entry will be a number which can range from 0 - 100.

• The third screen should show the student name and overall letter grade for the semester based on the classes that they took. Note: Use the grade conversion table below:

Points              Grade

100-90                 A

80-89                   B

70-88                   C

60-69                   D

Below 60              F

Use the sample students and grades below:

Student ID      Student Name       Class ID       Class Name       Grade

1                       Sally Smith           100            Biology               70

1                       Sally Smith           110            Gym                   90

2                       Mark Front           120             English               40

2                       Mark Front           110             Gym                   10

3                       Rick Hart              130            Science                85

3                       Rick Hart              100            Biology                90

3                       ick Hart                110            Gym                    45

4                       Justin Jones         140            Computers           45

4                       Justin Jones         120            English                 70

Design the database using the following fields and criteria:

StudentID VARCHAR(8),

FirstName varchar(20),

Lastname varchar(20),

ClassID varchar(20),

Grade Integer(3),

Lettergrade Varchar(2)

Reference no: EM131132159

Questions Cloud

Write an eight to ten page project paper : write an eight to ten page project paper:- Business Introduce your business idea.-Describe the Business type (new business, franchise, operating business) and include rationale.
The gross requirement of dependent item is computed : The gross requirement of a dependent item is computed from the
Provide evidence of paleocultural behavior : How can the "Olduwan Industry" be said to provide evidence of "paleocultural" behavior and what is some evidence for hunting as the dominant component of early hominid economies?
Identify the different types of inventories : Identify the different types (list several items of each) of inventories (raw materials, WIP, and finished goods) carried in the following organizations:
Design the database using the given fields and criteria : Design the database using the following fields and criteria: StudentID VARCHAR(8), FirstName varchar(20), Lastname varchar(20), ClassID varchar(20), Grade Integer(3) and Lettergrade Varchar(2).
Which will change equilibrium output more : You hear the argument that a reduction in the deficit will increase consumer and business confidence and thus reduce the decline in output that would otherwise occur with deficit reduction. Is this argument valid?
Differences between the two approaches : In your own words, explain the relationship between JIT and Lean. In your answer, address (at a minimum), each of the following: Key elements of each approach to production and operations management. Similarities between the two approaches. Diifferen..
Major characteristics of processual archaeology : What are the major characteristics of processual archaeology? Use Koster to provide examples of these characteristics.
Briefly discuss how it is used in organizations and in hr : Create section headings for the key HR metrics for each of the 3 categories identified in the attached Matrix and discuss(table): Routine HR Metrics, HR Strategy Metrics, and HR Organizational Oversight Metrics.

Reviews

Write a Review

Database Management System Questions & Answers

  Display the number of seats that were in the cinema

Display the number of seats that were in the cinema and the name of the movie. A list of all screenings of PG movies during the month of January, 2015.

  Develop a complete system

The assignment will be chosen by the individual student with my approval. An ideal assignment will be one which involves at least four entity sets, but not too many since there will be critical time pressure to complete the assignment.

  Information-sucurity and ethical concerns with the system

A disscussion of the information used in the system. A disscussion of any information-sucurity and ethical concerns with the system. MPR system

  Develop basic tools to expedite use of oracles data

develop basic tools to expedite use of oracles data dictionarygoalsdevelop and demonstrate sql skillsdevelop your

  Write a select statement that joins the customers

Write a SELECT statement that joins the Customers, Orders, OrderItems, and Products Tables. This statement should return these columns: LastName, FirstName, OrderDate, ProductName, ItemPrice, DiscountAmount, and Quantity.

  Describe what the role of the database administrator is and

discuss what the role of the database administrator is and why it is such an important role in the company. do we

  Write down 400-600 in your own words why is it significant

write 400-600 in your own words why is it important to define the scope and perform requirement analysis for the

  Write an anonymous block that places a substitution variable

Write an anonymous block that places a substitution variable (&) into a local variable of type varchar2. You will need to convert the types and round them to nearest tens unit

  Binary 1-n relationship-optional-to-optional relationship

Give examples of binary 1:N relationships, for (a) an optional-to-optional relationship, (b) an optional-to-mandatory relationship,

  The packing list describes the ideal contents

The packing list describes the ideal contents of each package, but it is not always possible to include the ideal number of each item. Therefore, the actual items included in each package should be tracked. A package can contain many different ite..

  Database technologies what is lan based database management

what is lan based database management system ltbrgtgive an example of lan based database management system with a

  How important is the documentation of database environment

How important is the documentation of the database environment? Moreover, how do you think the advent of cloud computing has affected electronic data interchange (EDI)

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd