I really need help with this assignment question Please help me out Please
* Description*
You are hired to develop a laptop inventory information system for Sheridan College in order to keep track of the information about the laptops lent to the students. Users can add or remove data as well as perform searches on the database. Using your IDE (NetBeans or Eclipse), you should develop a Java application to provide these services by connecting to a database hosted by MySQL.
Mandatory Requirements
Database
The database should be designed in MySQL. For this purpose you will need to use the sheridancollege database we created in class. Create a table in the database named ââ?¬Å?LaptopPoolââ?¬Â?.
The LaptopPool table should contain the following fields:
StudentID, FirstName, LastName, LaptopModel, HDDSize, RAM, Year
Notice that ââ?¬Å?Student IDââ?¬Â?, ââ?¬Å?First Nameââ?¬Â?, ââ?¬Å?Last Nameââ?¬Â?, and ââ?¬Å?Laptop Modelââ?¬Â? should not be left unspecified. The ââ?¬Å?Yearââ?¬Â? field should also be specified. However if user does not provide any data for year, set a default value: the current year. Also be mindful of relevant, valid data types for each field.
Submit your SQL statement for creating the table.
View Answers
Related Tutorials/Questions & Answers:
Advertisements
Please help me out Please help me out
Description* You are hired to develop a laptop inventory information system for Sheridan College in order to keep track... should be designed in MySQL. For this purpose you will
need to use
i need a help in this pleasei need a
help in this please The factorial of a nonnegative integer n is written n! (pronounced â?? n factorialâ??)
and is defined as follows:
n!=n...=input.nextInt();
long num=m;
for(int
i=m;i>1;
i help me please help me please Hello
I want helping for this
question ,
Please
Write a program that reads some friends� names, stores them in an array, and then prints
out on the screen all friends who start by a particular letter
urgent...pleAse help me.....please!urgent...
pleAse help me.....
please!
please help me urgent! how can
i do dictionary with the use of array code in java, where
i will type the word then the corresponding meaning for that word will appear...thanks
please help me.please help me.
Please send
me a code of template in opencms and its procedure.so
i can implement the code.
Thanks
trinath
please help me.please help me.
I have three table in mysql,and
i hava create a excel sheet and add this sheet.but my
question is in every sheet
i can display one one table result.how can
i do
need help pleaseneed help please Dear sir, my name is logeswaran.
I have a big problem that
I can't find the solution for a program. How can
I block a user from enter a page second time.
Please help me.
By the way I'm using Access database
please help me to solve this question about arrayplease help me to solve this
question about array write a program thatt stores vowels (a,e,
i,o and u)in an array. Ask the user to enter any... main(String[] args) {
char arr[] = { 'a', 'e', '
i', 'o', 'u' };
String
please help me.please help me.
I have a jsp page under that
i add a list box under
i get the countries through my database.
so how can
i do
please help me.please help me. How to read a properties file in java with a suitable example.
Please send
me.
Thanks
Trinath
Please visit the following link:
Java read properties file
please help me.please help me.
Please send
me the validation of this below link.
the link is http://www.roseindia.net/answers/viewqa/JSP-Servlet/9584-JSP-Servlet-Search-and-Edit.html
Thanks
Trinath
Please help me.Please help me. Hi
i am trinath in below there is a url.In that url there is a code of edit a jsp page.I understand that code but only one thing
i not get it i.e; What is the work of "id".and what is the data type of id?
http
please help me to this problem..please help me to this problem..
i wrote a program like keyboard... inside the JTextField) but
i want to make this program to let
me write where
i clicked (i.e allows
me to write any thing at the field where
i clicked
please help meplease help me Dear sir,
I have a problem. How to write JSP coding, if a user select a value from drop down list for example department, the another... before. This name list should get from the database.
Please help me.
By the way, I'm
please help me.please help me. How to move the edits.jsp in below link?
http://www.roseindia.net/answers/viewqa/JSP-Servlet/9584-JSP-Servlet-Search-and-Edit.html
need help...................pleaseneed help...................please
I have a problem in my JSP Coding... should show in texfield that already create in the web page. I'm
really stuck on this area.
Please help me.
By the way, I'm using access Database and JSP coding
please help me...please help me... write an application that print number in the following order using a FOR-Loop
1 2 3 4 5
2 4 6 8 10
3 6 9 1215
4 8 121620
5 10152025
please help me in these progplease help me in these prog
create 2 jdbc programs including awt
create 2 jdbc programs including swing
create 2 jdbc programs including command line argument
create 2 jdbc programs including io class
4 jdbc prog using
please help me hereplease help me here
please show
me how can this show the right output that
i need please continue doing this program using only if else and do while...] Deposit [W] Withdrawal [
Q] Quit select you OPtions:
once
i have chosen an option
please help me hereplease help me here
please show
me how can this show the right output that
i need please continue doing this program using only if else and do while...] Deposit [W] Withdrawal [
Q] Quit select you OPtions:
once
i have chosen an option
Please help mePlease help me program for when a user enter his card number, it has to create default security pin in the database
Please help mePlease help me Hi Sir,
please send
me the code for the following progrems...
1) all sets are integer type:
input:
set1={10,20,30,40...(" ");
for(int
i=str.length-1;i>=0;
i--){
buffer.append(str[
i please help meplease help me interface Test1 { String toString(); }
public class Test {
public static void main(String[] args) {
System.out.println(new Test1() {
public String toString() { return "test
help me pleasehelp me please how can
i do dictionary with the use of array code in java, where
i will type the word then the corresponding meaning for that word will appear...thanks
Please help me urgent...........Please help me urgent........... For what kind of a problem would use a Tree Set and not a Tree Map
For what kind of a problem would use a Tree Map and not a Tree Set
Hello Friend,ADS_TO_REPLACE_1
If you want
Please help me??Please help me?? Question_1: Using one-dimension array of primitive type elements.
Objective: The purpose of this lab exercise is to practice how...?
Iterator
i=myList.iterator();
System.out.println("Printing element by element
please help meplease help me how to use two browse buttons, one browse button for displaying the first image and second for the second image along with its file path and also to display text file along with its path using layouts or panels
please help meplease help me how to use two browse buttons, one browse button for displaying the first image and second for the second image along with its file path and also to display text file along with its path using layouts or panels
please help me?please help me? Define a class named Circle with the following properties:
List item
An integer data field named radius with protected access modifier, and a String data field named colour with private access modifier. Both
Help me please!!! - Java BeginnersHelp me please!!! im badly needing the complete code for this project in java!!!
can you
please help me???!!!
it is about 1-dimensional array... the answers 8Hours from now!!!
Kindly
help me!!
please!!
please!!!
NOTE
HQL Statement: Please help me = Product.productGroupVersionId and
Product.lobId = ?
Can you
please help me equallent HQL...HQL Statement:
Please help me Select ProductFamily.*
from
ProductFamily, ProductGroup, Product
where
ProductFamily.productFamilyVersionId
Begineer in coding please help meBegineer in coding
please help me
I have
Person class{
int pid... address to a person object..
please help me... add;
}
i know
i should create a
class Address{
String state;
Sting country
Please help me understand this queryPlease help me understand this query Hi,
Could someone
please help me understand the following query. Im finding difficulty relating it :-( Pls
Help!
select * from cbpartner where CBPartner.IsSummary='N' and salesrep_id
please help me - Java Beginnersplease help me I have some error in this programe
//write...[])
{
for( int a=1;b=2 ;
i++)
a=a+2;
b=b-2;
System.out.print... b=2;
for(int
i=100;i>0;
i--){
System.out.print(a);
System.out.print
would you please help me?would you
please help me? Write a class Amount which stores sums of money given in pounds and pence. Your con-
structor should take two ints, for pounds and pence seperately. The class should also
provide methods to add