1. Develop a database application to demonstrate storing and retrieving of BLOB and CLOB objects.
2. Develop a database application to demonstrate the representation of multivalued attributes, and the use of nested tables to represent complex objects. Write suitable queries to demonstrate their use.
3. Design and develop a suitable Student Database application. One of the attributes to me maintained is the attendance of a student in each subject for which he/she has enrolled. Using TRIGGERS, write active rules to do the following:
a. Whenever the attendance is updated, check if the attendance is less than 85%; if so, notify the Head of the Department concerned.
b. Whenever, the marks in an Internal Assessment Test are entered, check if the marks are less than 40%; if so, notify the Head of the Department concerned.
4. Design, develop, and execute a program in a language of your choice to implement any one algorithm for mining association rules. Run the program against any large database available in the public domain and discuss the results.
sql ServerAmit tripathi September 26, 2011 at 3:55 PM
Design and develop a suitable Student Database application. One of the attributes to me maintained is the attendance of a student in each subject for which he/she has enrolled. Using TRIGGERS, write active rules to do the following: a. Whenever the attendance is updated, check if the attendance is less than 85%; if so, notify the Head of the Department concerned.
b. Whenever, the marks in an Internal Assessment Test are entered, check if the marks are less than 40%; if so, notify the Head of the Department concerned.
what is the syntax for the query "Select customer names having account but not loan"
the tables are
1. account
2. branch
3.loan
4.customer
with relationships:
customer-account: 1-M
customer-loan: 1-M
branch-loan: 1-M
branch-account: 1-M
had less than one MEGAbyte of memory. No hard disk, just two 360 kB fopply disk drives and 128K of RAM. I just got saddled with a data-mining project that will process tens of gigabytes of data in a networked environment. My analysis tools can use SQL to access the data. This book was the first thing I insisted on. (Kind of embarassing for a senior person to be seen carrying a thick yellow and black book with the word DUMMIES on it )This has proven to be an excellent starting point. I know plenty about computers and programming. I vaguely remember the essentials of relational databases (for those who don't, basic information is in the book, it should be enough to get started, even if you are absolutely ignorant!) Taylor packaged enough of the right information that I could read his book over the weekend and dive into the planning stages of our project on Monday sounding like I knew a thing or two. The book charts a course from the most basic elements of databases to modestly complicated database and query materials. The author discusses common pitfalls and useful strategies. This book isn't enough, by itself, to turn somebody into a database wonk, but it's a great starting point.I got a bit annoyed by some of the cute material used to make the subject seem less threatening, but that filler doesn't take up too much space and is easily skipped. Also, the book is overly Microsoft centered the author uses Windows applications as examples and champions Microsofts ODBC. A section about using SQL in a Unix/Linux environment should have been included (access from shell scripts, PERL, etc?). A solid four-star introduction to SQL and database technology in a Microsoft world.(If you'd like to discuss this book or review in more detail, please click on the about me link above and drop me some email. Thanks!)
hey there and thank you for your information â?? Iâ??ve cnrtaiely picked up anything new from right here. I did however expertise several technical issues using this site, since I experienced to reload the web site a lot of times previous to I could get it to load properly. I had been wondering if your hosting is OK? Not that I'm complaining, but sluggish loading instances times will sometimes affect your placement in google and could damage your quality score if ads and marketing with Adwords. Anyway I am adding this RSS to my e-mail and could look out for much more of your respective intriguing content. Ensure that you update this again very soon..
I have no word to express your uploaded handout so that be continue to upload news things and modified
thanks a lot
Your sensory
D/r Mulugeta Assefa
Bye bye
I would have thought that if a given optuut gap can tolerate a budget deficit of say 10% without making inflation accelerate, its better for this 10% deficit to be split 9% on targeted spending (with a proven multiplier effect) and only 1% on bond interest (which goes to capital owners and so has a low multiplier), instead of 7% vs 3%. In other words, if a govt pays out a lower amount of sovereign interest, it has more room to pay for more useful things.
when we do a project we create html pages such as registration forms etc,but my question is where do we store this data and how do we invoke this data(retrieve). when is xml used and when is jdbc connection used?
Just want to say your article is as aosnutding. The clearness in your post is simply nice and i could assume you are an expert on this subject. Fine with your permission allow me to grab your feed to keep up to date with forthcoming post. Thanks a million and please continue the gratifying work.
Very nice post. I just stumbled upon your webolg and wished to say that I've truly enjoyed surfing around your blog posts. In any case Iâ??ll be subscribing to your feed and I hope you write again very soon!
DECLARE
QUERY VARCHAR2(32767);
FIN_QUERY VARCHAR2(32767);
CURSOR C IS
(select distinct PORTFOLIO from MPE_TEST1);
CURSOR C2 IS
SELECT DISTINCT PORTFOLIO_LEVEL, PORTFOLIO FROM MPE_TEST1 ORDER BY PORTFOLIO_LEVEL;
TYPE ARRAY IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
PORTFOLIO_LEVEL ARRAY;
IDX NUMBER :=1;
BEGIN
QUERY := 'SELECT ';
for R IN C
LOOP
IDX := 1;
FOR R2 IN C2
LOOP
IF(R2.PORTFOLIO = R.PORTFOLIO)
THEN
PORTFOLIO_LEVEL(IDX) := R2.PORTFOLIO_LEVEL;
IDX := IDX + 1;
END IF;
END LOOP;
QUERY := QUERY || 'CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(1) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_SALE_ASS_C,
CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(1) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_SALES_ASS_EXP_DT,
CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(2) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_SALE_MST_C,
CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(2) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_SALE_MST_EXP_DT,
CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(3) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_SALE_PROF_C,
CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(3) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_SALE_PROF_EXP_DT,
CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(4) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_TECH_ASS_C,
CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(4) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_TECH_ASS_EXP_DT,
CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(5) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_TECH_MST_C,
CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(5) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_TECH_MST_EXP_DT,
CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(6) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_TECH_PROF_C,
CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(6) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_TECH_PROF_EXP_DT,';
END LOOP;
QUERY := SUBSTRING(QUERY,0,LENGTH(QUERY)-1);
QUERY := QUERY || ' FROM MPE_TEST1 F ';
--DBMS_OUTPUT.PUT_LINE('QUERY--'||QUERY);
FIN_QUERY := 'select ';
FOR R IN C
LOOP
FIN_QUERY := FIN_QUERY ||
'(case when '||R.PORTFOLIO||'_TECH_ASS_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL ASSOCIATE'')
then ''Elite Specialist, Specialist, Authorized''
when '||R.PORTFOLIO||'_TECH_ASS_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL ASSOCIATE'')
then ''Specialist, Authorized''
when '||R.PORTFOLIO||'_TECH_ASS_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL ASSOCIATE'')
then ''Authorized''
else ''Authorized''
end) '||R.PORTFOLIO||'_TA_LEVEL,
(case when '||R.PORTFOLIO||'_SALE_ASS_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES ASSOCIATE'')
then ''Elite Specialist, Specialist, Authorized''
when '||R.PORTFOLIO||'_SALE_ASS_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES ASSOCIATE'')
then ''Specialist, Authorized''
when '||R.PORTFOLIO||'_SALE_ASS_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES ASSOCIATE'')
then ''Authorized''
else ''Authorized''
end) '||R.PORTFOLIO||'_SA_LEVEL,
(case when '||R.PORTFOLIO||'_TECH_MST_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL MASTER'')
then ''Elite Specialist, Specialist, Authorized''
when '||R.PORTFOLIO||'_TECH_MST_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL MASTER'')
then ''Specialist, Authorized''
when '||R.PORTFOLIO||'_TECH_MST_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL MASTER'')
then ''Authorized''
else ''Authorized''
end) '||R.PORTFOLIO||'_TM_LEVEL,
(case when '||R.PORTFOLIO||'_SALE_MST_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES MASTER'')
then ''Elite Specialist, Specialist, Authorized''
when '||R.PORTFOLIO||'_SALE_MST_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES MASTER'')
then ''Specialist, Authorized''
when '||R.PORTFOLIO||'_SALE_MST_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES MASTER'')
then ''Authorized''
else ''Authorized''
end) '||R.PORTFOLIO||'_SM_LEVEL,
(case when '||R.PORTFOLIO||'_TECH_PROF_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL P'')
then ''Elite Specialist, Specialist, Authorized''
when '||R.PORTFOLIO||'_TECH_PROF_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL P'')
then ''Specialist, Authorized''
when '||R.PORTFOLIO||'_TECH_PROF_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL P'')
then ''Authorized''
else ''Authorized''
end) '||R.PORTFOLIO||'_TP_LEVEL,
(case when '||R.PORTFOLIO||'_SALE_PROF_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES P'')
then ''Elite Specialist, Specialist, Authorized''
when '||R.PORTFOLIO||'_SALE_PROF_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES P'')
then ''Specialist, Authorized''
when '||R.PORTFOLIO||'_SALE_PROF_C >=
(select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES P'')
then ''Authorized''
else ''Authorized''
end) '||R.PORTFOLIO||'_SP_LEVEL, ';
END LOOP;
FIN_QUERY := FIN_QUERY || ' i.* from (' || QUERY;
FIN_QUERY := FIN_QUERY || ') I ';
DBMS_OUTPUT.PUT_LINE(FIN_QUERY);
EXECUTE IMMEDIATE FIN_QUERY;
END;
write code i have five tables i want to build them html form and link between them database and php then make query between them
,,,,,,,,,,
Table of suppliers
Source no, resource name, Address mobile ,Tel , e-mail
,,,,,,,,,,,,
Customers table
Customer no , Customer name , Address ,mobile, Tel , e-mail
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Sales table
Sales invoice no , History , Statement, Item Goods number ,number price ,color ,payment, Delivery date , notes
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Table purchases
Purchase invoice ,number, Date , Number of purchase number, statement, item ,Price , color, payment Delivery date, notes
,,,,,,,,,,,,,,,,,,,,,,,,
Bucket table
Goods number ,Payment invoice, number, Purchases
Invoice number, statement, item ,number, Cost price ,Selling price , color Date of entry of the goods ,status
,,,,,,,,,,,,,,,,,,,
How to insert dynamically values into a table using JDBC MSACCESS
This COde is not working for me
COuld you please tell me the error in this code
import java.sql.*;
import java.util.*;
public class DBDemo3 // DBDemoInsert
{
public static void main(String[ ] args) throws Exception
{
String url = "jdbc:odbc:mydsn";
Properties p = new Properties();
p.put("user", "sa");
p.put("password","dss");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection( url, p );
String insertCommand = "INSERT INTO employee VALUES(" + args[0] + ",'" + args[1] + "'," + args[2] + ")";
Statement stmt = con.createStatement();
int count = stmt.executeUpdate(insertCommand);
System.out.println(count + " row(s) inserted");
con.close();
}
}
import java.io.*;
import java.sql.*;
import java.util.*;
class database
{
public static void main(String...a)throws IOException
{
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/ashish","root","sugamber");
Statement st=conn.createStatement();
Scanner sc=new Scanner(System.in);
String user_name=sc.next();
String password=sc.next();
ResultSet rs=st.executeQuery("SELECT * from user_master where login_name='"+user_name+"', password='"+password+"' ");
if(rs.next())
{
if(rs.getString("user_type").equals("admin"))
{
System.out.println("Welcome Admin");
}
else
{
System.out.println("Sorry u r not admin");
}
}
else
{
System.out.println("Invalid User");
}
}
catch(Exception e)
{
System.out.println(e);
}
}}
this is the code and i want connect with MYSQL database than i found java.lang.classnoyfoundexception <com.mysql.jdbc.driver>
how to solve this problem?
plz help me
create table DATA (IMAGE_ID ,IMAGETimestamp, IMAGEFilePath );
create table FRAME(FrameID,VideoStartTime, VideoEndTime,VideoFile path);
here the Image id is primary key and frame ID is foreign key
i want to join the tables in such a way that FrameID did not come in the joined table as the entries of the Imageid and frame id are same i applied the query by left outer join but it is huge can someone help to reduce the size...
select DATA.Img_ID,DATA.Img_Type,DATA.Img_FilePath,DATA.Img_TimeStamp,DATA.Img_Lat,DATA.Img_long,DATA.Img_Country,DATA.Img_City,DATA.Img_Landmark,
DATA.MPEG7FILEPATH,DATA.Img_Title,DATA.Img_Creator,DATA.Img_Description,DATA.Img_Keyword,DATA.Img_Genre,DATA.Img_Rate,DATA.Img_Copyright,
FRAME.VIDEOSTARTTIME,FRAME.VIDEOENDTIME,FRAME.VIDEOFILEPATH from DATA left join FRAME on DATA.Img_ID=FRAME.FRAMEID;
Can you please give a way forward to accomplish this:
You are provided with a database backup to aid you in performing a data import for a hospital. The backup contains a single table that will act as your extract/source data.
Required:
Create a normalized database that will capture the details for the patients and NOKs(next of kins). N.B. Only one address and telephone table respectively should cater for both NOK and Patient addresses and phone records respectively.
All fields must be mapped into the database structure you i create.
The following fields are lookup fields and so should be thus implemented; sex,title,maritalstatus,religion,ethnicity,noktitle,nokrelationship
Visibility of system status should be implemented and the messages should not be verbose (make them brief and to the point)
Customer ,sites,books and authors each is individual entity
but every entity has the notes entity is one many relation ship so how i need to design the table at database side.
databasekesego lesaso September 3, 2012 at 7:25 PM
Sir,
I have to work on many projects at the same time and each have some database. I even now could not found a very much suitable database with all appropriate drivers that can be used with java development and can be deployed also onto the client side. There are many types of problems I face, sometimes Database server could not start, somewhere required drivers cound not be found, some other time null values could not be inserted into a connected database table. In short I am very much exhusted when I am working on different project at the same time.
I think You are getting my point and thankfull very much to You if you can provide a guidance and suggest the best compatible database with java on every windows OS.
Yours,
Manish Dixit
insertion..!Divya Dhage September 21, 2012 at 5:07 PM
java with dbmschandra shekhar parmar October 13, 2012 at 9:23 AM
sir, i have a problem in jsp i want to write a code in jsp and the code of submit form(submit button) and code of insert data i want to write in same page but my program is not working....
why this is happing???
On added point to mention here is that with Access teabls you can store up to 255 fields not that I would recommend this as it can affect performance. The file size can grow to 2GB should you need the space.With MS Access queries, the capacity of the number of fields is the same but they can be combined from up to 32 teabls with 16 joins a heavy duty query!
for examnple
class.forName
DriverManager.getConnection
con.createStatement();
st.executeUpdate
com.mysql.jdbc.Driver
Connection con;
PreparedStatement ps;
Result set
please explain this ...
please send my email or give me url ..
thanks...
java and vb,internet,data structureramji meghwal May 24, 2011 at 1:26 PM
i want to know answer the question thanks
Sql Serverchveeranna June 2, 2011 at 10:58 AM
i need sql server tutorial
ResearchNasiru ope June 25, 2011 at 1:40 AM
What data are you likely to collect when you fail to anticipate the strategies for your data
Laptop needzama June 27, 2011 at 11:08 PM
I am a student of IT at majuba colledge in newcastle, but its impossible to study without a computer at home
Pro Cmeenakshi.H.N June 29, 2011 at 7:51 AM
do SQL server support embedding sql into C HLL? how to work on emkbedded SQL using C & Oracle
DBMSTanakala Srikant June 29, 2011 at 7:54 AM
I need a online trainer at Oracle Database,SQ L.
feedbackshere mitesh June 29, 2011 at 11:34 AM
this website is amazing... thanks a lot....
transport management system programming in javaAbhishek June 29, 2011 at 10:55 PM
plz mention
transport management system programming in javaAbhishek June 29, 2011 at 10:59 PM
plz mention program
Plz reply answers for this query..Basavaraj Patil September 23, 2011 at 5:44 PM
1. Develop a database application to demonstrate storing and retrieving of BLOB and CLOB objects. 2. Develop a database application to demonstrate the representation of multivalued attributes, and the use of nested tables to represent complex objects. Write suitable queries to demonstrate their use. 3. Design and develop a suitable Student Database application. One of the attributes to me maintained is the attendance of a student in each subject for which he/she has enrolled. Using TRIGGERS, write active rules to do the following: a. Whenever the attendance is updated, check if the attendance is less than 85%; if so, notify the Head of the Department concerned. b. Whenever, the marks in an Internal Assessment Test are entered, check if the marks are less than 40%; if so, notify the Head of the Department concerned. 4. Design, develop, and execute a program in a language of your choice to implement any one algorithm for mining association rules. Run the program against any large database available in the public domain and discuss the results.
sql ServerAmit tripathi September 26, 2011 at 3:55 PM
Hai..
c++MITHUN KUMAR October 5, 2011 at 11:36 AM
c++
dbmssatya prakash January 30, 2013 at 8:47 PM
Design and develop a suitable Student Database application. One of the attributes to me maintained is the attendance of a student in each subject for which he/she has enrolled. Using TRIGGERS, write active rules to do the following: a. Whenever the attendance is updated, check if the attendance is less than 85%; if so, notify the Head of the Department concerned. b. Whenever, the marks in an Internal Assessment Test are entered, check if the marks are less than 40%; if so, notify the Head of the Department concerned.
DBMSRamesh October 18, 2011 at 10:51 AM
On the bases of oracle is there any courses available for certification?Please answer me.
steps to create Procedures & functions in ASP.NETvamsi November 8, 2011 at 3:14 PM
Need Description............
asp.netrabia November 9, 2011 at 5:26 PM
know about how to do post button coding on discussion forum.
bank projectrupesh kumar November 18, 2011 at 6:03 PM
we need exe file of bank in vb
databasehussain November 25, 2011 at 10:45 PM
what is the syntax for the query "Select customer names having account but not loan" the tables are 1. account 2. branch 3.loan 4.customer with relationships: customer-account: 1-M customer-loan: 1-M branch-loan: 1-M branch-account: 1-M
bQflLuCHsTZzdNoviea March 5, 2013 at 8:47 PM
had less than one MEGAbyte of memory. No hard disk, just two 360 kB fopply disk drives and 128K of RAM. I just got saddled with a data-mining project that will process tens of gigabytes of data in a networked environment. My analysis tools can use SQL to access the data. This book was the first thing I insisted on. (Kind of embarassing for a senior person to be seen carrying a thick yellow and black book with the word DUMMIES on it )This has proven to be an excellent starting point. I know plenty about computers and programming. I vaguely remember the essentials of relational databases (for those who don't, basic information is in the book, it should be enough to get started, even if you are absolutely ignorant!) Taylor packaged enough of the right information that I could read his book over the weekend and dive into the planning stages of our project on Monday sounding like I knew a thing or two. The book charts a course from the most basic elements of databases to modestly complicated database and query materials. The author discusses common pitfalls and useful strategies. This book isn't enough, by itself, to turn somebody into a database wonk, but it's a great starting point.I got a bit annoyed by some of the cute material used to make the subject seem less threatening, but that filler doesn't take up too much space and is easily skipped. Also, the book is overly Microsoft centered the author uses Windows applications as examples and champions Microsofts ODBC. A section about using SQL in a Unix/Linux environment should have been included (access from shell scripts, PERL, etc?). A solid four-star introduction to SQL and database technology in a Microsoft world.(If you'd like to discuss this book or review in more detail, please click on the about me link above and drop me some email. Thanks!)
ELqLnMkcgIqwQGEkayzm March 6, 2013 at 12:52 AM
hey there and thank you for your information â?? Iâ??ve cnrtaiely picked up anything new from right here. I did however expertise several technical issues using this site, since I experienced to reload the web site a lot of times previous to I could get it to load properly. I had been wondering if your hosting is OK? Not that I'm complaining, but sluggish loading instances times will sometimes affect your placement in google and could damage your quality score if ads and marketing with Adwords. Anyway I am adding this RSS to my e-mail and could look out for much more of your respective intriguing content. Ensure that you update this again very soon..
DBMSmadhu December 16, 2011 at 6:42 PM
what is the type of an image in database?
fsdanu December 21, 2011 at 3:48 PM
need 2 improve
Data base mulugeta December 21, 2011 at 8:30 PM
I have no word to express your uploaded handout so that be continue to upload news things and modified thanks a lot Your sensory D/r Mulugeta Assefa Bye bye
nkoNdHjKhItWqGVeAFrankie March 6, 2013 at 8:55 AM
Too many compliments too little space, tkahns!
EEhqnpjAtrgrDKOXNJanine March 6, 2013 at 8:55 AM
Wow! Great to find a post with such a clear mssegae!
UJukhlTzsYdWfDoRAPrecious March 6, 2013 at 8:56 AM
Your awnser was just what I needed. It's made my day!
aACrYKBdtEIpQSPhilip March 6, 2013 at 9:28 AM
I would have thought that if a given optuut gap can tolerate a budget deficit of say 10% without making inflation accelerate, its better for this 10% deficit to be split 9% on targeted spending (with a proven multiplier effect) and only 1% on bond interest (which goes to capital owners and so has a low multiplier), instead of 7% vs 3%. In other words, if a govt pays out a lower amount of sovereign interest, it has more room to pay for more useful things.
regarding RDBMSGoldy Rawat December 26, 2011 at 7:26 PM
I like this website. its very helpful for us... Thankx
storing and retrieving the datasmitha January 14, 2013 at 11:58 PM
when we do a project we create html pages such as registration forms etc,but my question is where do we store this data and how do we invoke this data(retrieve). when is xml used and when is jdbc connection used?
dbmsujwala January 13, 2012 at 12:53 AM
wants more advance knowledge in dbase
everything about DBMSMosnat Ahmed Nayeem January 12, 2013 at 7:10 PM
I like it
i am looking for database coursekuldeep January 18, 2013 at 4:05 PM
hello
To know about the java MD.ASIF ANSARI January 26, 2012 at 9:45 PM
I want to connection with java and updating,deleting,viewing and many more.
projectvalarmathi February 2, 2012 at 9:42 AM
i will do my project in database.please help
D B M S inqury md saifee February 3, 2012 at 6:08 PM
D B M S me mai kiya use kar sakta hun .hai kiya
Database connectivity in c languageyogesh ukale January 10, 2013 at 4:17 PM
How to create database connectivity in language? Please, send me Answare....
tLuKgsedaMHernan January 19, 2013 at 7:54 AM
Just want to say your article is as aosnutding. The clearness in your post is simply nice and i could assume you are an expert on this subject. Fine with your permission allow me to grab your feed to keep up to date with forthcoming post. Thanks a million and please continue the gratifying work.
gTYlLFvtMdNkGbAmira January 19, 2013 at 7:55 AM
Very nice post. I just stumbled upon your webolg and wished to say that I've truly enjoyed surfing around your blog posts. In any case Iâ??ll be subscribing to your feed and I hope you write again very soon!
kiquekish February 17, 2012 at 4:53 PM
DECLARE QUERY VARCHAR2(32767); FIN_QUERY VARCHAR2(32767); CURSOR C IS (select distinct PORTFOLIO from MPE_TEST1); CURSOR C2 IS SELECT DISTINCT PORTFOLIO_LEVEL, PORTFOLIO FROM MPE_TEST1 ORDER BY PORTFOLIO_LEVEL; TYPE ARRAY IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER; PORTFOLIO_LEVEL ARRAY; IDX NUMBER :=1; BEGIN QUERY := 'SELECT '; for R IN C LOOP IDX := 1; FOR R2 IN C2 LOOP IF(R2.PORTFOLIO = R.PORTFOLIO) THEN PORTFOLIO_LEVEL(IDX) := R2.PORTFOLIO_LEVEL; IDX := IDX + 1; END IF; END LOOP; QUERY := QUERY || 'CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(1) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_SALE_ASS_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(1) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_SALES_ASS_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(2) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_SALE_MST_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(2) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_SALE_MST_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(3) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_SALE_PROF_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(3) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_SALE_PROF_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(4) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_TECH_ASS_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(4) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_TECH_ASS_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(5) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_TECH_MST_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(5) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_TECH_MST_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(6) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_TECH_PROF_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(6) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_TECH_PROF_EXP_DT,'; END LOOP; QUERY := SUBSTRING(QUERY,0,LENGTH(QUERY)-1); QUERY := QUERY || ' FROM MPE_TEST1 F '; --DBMS_OUTPUT.PUT_LINE('QUERY--'||QUERY); FIN_QUERY := 'select '; FOR R IN C LOOP FIN_QUERY := FIN_QUERY || '(case when '||R.PORTFOLIO||'_TECH_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL ASSOCIATE'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL ASSOCIATE'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL ASSOCIATE'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_TA_LEVEL, (case when '||R.PORTFOLIO||'_SALE_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES ASSOCIATE'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES ASSOCIATE'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES ASSOCIATE'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_SA_LEVEL, (case when '||R.PORTFOLIO||'_TECH_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL MASTER'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL MASTER'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL MASTER'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_TM_LEVEL, (case when '||R.PORTFOLIO||'_SALE_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES MASTER'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES MASTER'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES MASTER'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_SM_LEVEL, (case when '||R.PORTFOLIO||'_TECH_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL P'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL P'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL P'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_TP_LEVEL, (case when '||R.PORTFOLIO||'_SALE_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES P'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES P'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES P'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_SP_LEVEL, '; END LOOP; FIN_QUERY := FIN_QUERY || ' i.* from (' || QUERY; FIN_QUERY := FIN_QUERY || ') I '; DBMS_OUTPUT.PUT_LINE(FIN_QUERY); EXECUTE IMMEDIATE FIN_QUERY; END;
oracle projectgopal February 19, 2012 at 8:20 PM
i want to do project wth oracle having DB2 frontend. can somebody help me or suggest me something
simple questionsumit agarwal February 23, 2012 at 4:10 PM
sir/madam please send some dbms mcq question. (sumit agarwal)
apricationzag February 27, 2012 at 12:50 PM
Interseting tut
need answermalini March 3, 2012 at 7:48 PM
i want coding for online voting system ...i want to finish my project within a week
database sumera zulfiqar March 16, 2012 at 11:30 AM
plz provide me a project on bank management system
related to databaseshruti March 18, 2012 at 3:39 PM
How to inser pdfs into database?
sqlsaeed March 22, 2012 at 4:47 PM
Can i help me about diffrences of kinds of Sql?
projectrasha April 3, 2012 at 12:34 AM
write code i have five tables i want to build them html form and link between them database and php then make query between them ,,,,,,,,,, Table of suppliers Source no, resource name, Address mobile ,Tel , e-mail ,,,,,,,,,,,, Customers table Customer no , Customer name , Address ,mobile, Tel , e-mail ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Sales table Sales invoice no , History , Statement, Item Goods number ,number price ,color ,payment, Delivery date , notes ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Table purchases Purchase invoice ,number, Date , Number of purchase number, statement, item ,Price , color, payment Delivery date, notes ,,,,,,,,,,,,,,,,,,,,,,,, Bucket table Goods number ,Payment invoice, number, Purchases Invoice number, statement, item ,number, Cost price ,Selling price , color Date of entry of the goods ,status ,,,,,,,,,,,,,,,,,,,
JTable Connectivity with MSAccessmanoj singh April 3, 2012 at 1:55 PM
I want to access Table contents in JTable in java swing.. plz help me and provide source code for that
computer scienceadava April 23, 2012 at 3:04 AM
I am an fresh men in IT area . need someone give me some help. Thanks
JDBC MSACCESSravi April 10, 2012 at 5:14 PM
How to insert dynamically values into a table using JDBC MSACCESS This COde is not working for me COuld you please tell me the error in this code import java.sql.*; import java.util.*; public class DBDemo3 // DBDemoInsert { public static void main(String[ ] args) throws Exception { String url = "jdbc:odbc:mydsn"; Properties p = new Properties(); p.put("user", "sa"); p.put("password","dss"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection( url, p ); String insertCommand = "INSERT INTO employee VALUES(" + args[0] + ",'" + args[1] + "'," + args[2] + ")"; Statement stmt = con.createStatement(); int count = stmt.executeUpdate(insertCommand); System.out.println(count + " row(s) inserted"); con.close(); } }
jdbcsugamber April 17, 2012 at 12:22 AM
import java.io.*; import java.sql.*; import java.util.*; class database { public static void main(String...a)throws IOException { try{ Class.forName("com.mysql.jdbc.Driver"); Connection conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/ashish","root","sugamber"); Statement st=conn.createStatement(); Scanner sc=new Scanner(System.in); String user_name=sc.next(); String password=sc.next(); ResultSet rs=st.executeQuery("SELECT * from user_master where login_name='"+user_name+"', password='"+password+"' "); if(rs.next()) { if(rs.getString("user_type").equals("admin")) { System.out.println("Welcome Admin"); } else { System.out.println("Sorry u r not admin"); } } else { System.out.println("Invalid User"); } } catch(Exception e) { System.out.println(e); } }} this is the code and i want connect with MYSQL database than i found java.lang.classnoyfoundexception <com.mysql.jdbc.driver> how to solve this problem? plz help me
SQLrajesh April 28, 2012 at 11:54 AM
In OODBMS can sql implemented, is it possible?
CSEshovon May 5, 2012 at 6:44 AM
no comment
LollllAnarkali May 27, 2012 at 11:50 AM
Thanks
DB2tanya May 28, 2012 at 9:09 PM
I want the full explainatory tutorials of DB2.
dbmsshobhakant June 8, 2012 at 6:49 AM
i think better.
dbms & rdmsrachita June 9, 2012 at 3:08 PM
difrance between Dbms & Rdms
Sir,Venkatesh June 11, 2012 at 5:06 PM
It's very good to open one site for us to learn
database management systemmanelyn June 19, 2012 at 1:40 PM
collection of related records
DBMSbharath June 21, 2012 at 9:57 PM
how can we use this dbms software in IT industries?
registeredswitchcon July 3, 2012 at 1:50 PM
i want to post
About DBMSSatyanarayana Goud July 7, 2012 at 10:24 PM
VERY IMPRESSIVE WAY OF EXPLANATION,IF DIAGRAMATIC REPRESENTATION IS THERE IT WILL BE MORE INFORMATIVE TO REMEMBER
how insert the value in the data in data baserahul singh July 11, 2012 at 10:39 AM
iwants to answer in detail 1
pl sql pdf booksandip July 17, 2012 at 2:56 PM
nice
SQLITE query formationabhishek gaur July 26, 2012 at 5:23 PM
create table DATA (IMAGE_ID ,IMAGETimestamp, IMAGEFilePath ); create table FRAME(FrameID,VideoStartTime, VideoEndTime,VideoFile path); here the Image id is primary key and frame ID is foreign key i want to join the tables in such a way that FrameID did not come in the joined table as the entries of the Imageid and frame id are same i applied the query by left outer join but it is huge can someone help to reduce the size... select DATA.Img_ID,DATA.Img_Type,DATA.Img_FilePath,DATA.Img_TimeStamp,DATA.Img_Lat,DATA.Img_long,DATA.Img_Country,DATA.Img_City,DATA.Img_Landmark, DATA.MPEG7FILEPATH,DATA.Img_Title,DATA.Img_Creator,DATA.Img_Description,DATA.Img_Keyword,DATA.Img_Genre,DATA.Img_Rate,DATA.Img_Copyright, FRAME.VIDEOSTARTTIME,FRAME.VIDEOENDTIME,FRAME.VIDEOFILEPATH from DATA left join FRAME on DATA.Img_ID=FRAME.FRAMEID;
mysql code to do this.Jane July 27, 2012 at 1:19 PM
Can you please give a way forward to accomplish this: You are provided with a database backup to aid you in performing a data import for a hospital. The backup contains a single table that will act as your extract/source data. Required: Create a normalized database that will capture the details for the patients and NOKs(next of kins). N.B. Only one address and telephone table respectively should cater for both NOK and Patient addresses and phone records respectively. All fields must be mapped into the database structure you i create. The following fields are lookup fields and so should be thus implemented; sex,title,maritalstatus,religion,ethnicity,noktitle,nokrelationship Visibility of system status should be implemented and the messages should not be verbose (make them brief and to the point)
Database CorruptionGOODLUCK YOBANA August 14, 2012 at 1:08 PM
What could be done when the database is corrupt?
databasebalwinder kaur August 15, 2012 at 11:21 AM
how to perform normalization
sql/plsqlarunkumar August 15, 2012 at 7:24 PM
depth of sql/plsql
dbmsgaurav sharma August 25, 2012 at 2:46 PM
what is the mdi form
DB design for Fkrepresent multiple tablesRavisankar December 27, 2012 at 11:05 AM
Customer ,sites,books and authors each is individual entity but every entity has the notes entity is one many relation ship so how i need to design the table at database side.
databasekesego lesaso September 3, 2012 at 7:25 PM
examples of database
history of bioinformaticsSubha prasana jena September 4, 2012 at 11:24 PM
i am the student of North orisa univesity in bioinformatics. s
about talentvicks September 10, 2012 at 4:56 PM
u r very talented
differences between DBMS and SQLAshir September 14, 2012 at 8:44 PM
pls sent me the answer in my email pls
SQLsajid uddin December 13, 2012 at 5:51 PM
hey, I want the PLSQL tutorial covering all the concepts.. with appropiate examples.
Best Databse with Java on Windows & plateform.Manish Dixit September 20, 2012 at 11:05 PM
Sir, I have to work on many projects at the same time and each have some database. I even now could not found a very much suitable database with all appropriate drivers that can be used with java development and can be deployed also onto the client side. There are many types of problems I face, sometimes Database server could not start, somewhere required drivers cound not be found, some other time null values could not be inserted into a connected database table. In short I am very much exhusted when I am working on different project at the same time. I think You are getting my point and thankfull very much to You if you can provide a guidance and suggest the best compatible database with java on every windows OS. Yours, Manish Dixit
insertion..!Divya Dhage September 21, 2012 at 5:07 PM
What is DataBase insertion..?
jspgeorge fernandas September 30, 2012 at 5:22 PM
how to write a jsp program for student registration form and retrieve the value from the database
jspgeorge fernandas September 30, 2012 at 5:29 PM
how to write jsp program to create student information in randomly.using random button
dbmsRajendra singh October 3, 2012 at 3:11 PM
any ask qution
DATA BASE EMPLOYMENTSURESH October 4, 2012 at 6:04 PM
IT VERY FOR THIS FEILDS
java with dbmschandra shekhar parmar October 13, 2012 at 9:23 AM
sir, i have a problem in jsp i want to write a code in jsp and the code of submit form(submit button) and code of insert data i want to write in same page but my program is not working.... why this is happing???
crijwan October 15, 2012 at 11:42 AM
nice
DBMSTwesh srivastava October 26, 2012 at 6:36 PM
u give us a huge knowldge but its need some clarifies ofr every topic so if u do that we will helpful... thanku..
meWJTVyzKlKMNNoWCBagna October 26, 2012 at 7:17 PM
On added point to mention here is that with Access teabls you can store up to 255 fields not that I would recommend this as it can affect performance. The file size can grow to 2GB should you need the space.With MS Access queries, the capacity of the number of fields is the same but they can be combined from up to 32 teabls with 16 joins a heavy duty query!
database managementLingani Petros October 26, 2012 at 8:32 PM
i need steeps on desining database and exrcises on and its terminology, guide on how to make quiery,form and reports.
database managementLingani Petros October 26, 2012 at 8:35 PM
i need steps on desining database and guide on making quiery,form and reports
databasenaqib wazir November 11, 2012 at 2:29 PM
u have explained the term dbms very well
explain databasekush kumar May 8, 2013 at 12:44 PM
for examnple class.forName DriverManager.getConnection con.createStatement(); st.executeUpdate com.mysql.jdbc.Driver Connection con; PreparedStatement ps; Result set please explain this ... please send my email or give me url .. thanks...
objective cprudhvi May 9, 2013 at 12:29 PM
its nice to follow
Post your Comment