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
Ads
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 please
i 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
need help please
need 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.
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
please help me to solve this question about array
please 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...[] args) {
char arr[] = { 'a', 'e', '
i', 'o', 'u' };
String brr;
boolean
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
please 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
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
need help...................please
need 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 in these prog
please 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...
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
Please help me program for when a user enter his card number, it has to create default security pin in the database
please help me here
please 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 here
please 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
Please 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 me
please 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 please
help 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??
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 me
please 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 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