Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
i want someone to write a tsql function that returns the name of the odbc dsni will use the queries below to get information about the connection but
seeking a programmer to design a legal document with pre-existing fields that could allow the auto-population of clients information ie name account
i have a pascal source file that needs to be compiled into a service in addition there are various functions pascal procedures i guess that need to
i would like to have a custom ms access database designed and coded that would help me schedule my customers orders and that would help me track my
lightweight system to provide and take info from workers in the field and office have basic design outlined already just require build and
i need a query for plsql selecting names with cursor goes down the list assigns usernames initials001 based on initials in the name if two names have
how do i display usernames for students from a student table assigning each student a username initials001 initials is the actual student initials
questionconsider the following relations primary keys are underlinedauthor ano aname address speciality publisher pno pname location book bno title
problema define the following termsi data miningii olapb differentiate between snowflake schema and star schema support your answer with appropriate
questiona given the following relationlocationlocid bldgcode room capacitythe underlined field is a primary keyi write a plsql program using the
question 1 compare sql and plsqlquestion 2 write a database trigger to implement the following check
questiona in the context of database security explain how the following database features help to enforce security in the database systemi
a what are decision support systems and what role do they play in the business environmentb data warehousing is defined as a subject-oriented
questiona the objective of query optimization is to choose the most efficient strategy for implementing a given relational query thereby improving
due to an increase in overhead costs the buying price of all items needs to be increased management wants to see a report before deciding how much
hiam developing a library system and relating all the table is somehow complexcould you kindly assist
1a write a trigger that fires when a parts price is updated the trigger will write a record into a table called priceupdates the record should
a create a table odetailsnew it has all the attributes of odetails and an additional column called cost whose values are the product of the quantity
a write an anonymous block that contains a plsql function given an order number orderno the function will calculate the total number of the parts in
write an anonymous block that contains a plsql procedure the procedure takes two input parameter oldzip and newzip and it updates the zipcodes table
demonstrate your knowledge of plsql programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce
hi there i have the final part of a submission to do it is a demonstration that takes place tomorrow i do not have to use
the sql lsquocreate table scripts for all the tables you have implemented note that your tables must correspond exactly to the erd you have provided
i need to write one function and one procedure to query a oracle 101 db using pl sql i have the schema and exact queriesalong with work ive started
write a program to implement the inverted file shown in the slides simple index file labelid file and data file use the availlist to point at the