To hire a writers, fill the order instructions form & checkout—guaranteed a top college graduate to write your essay & NO AI-Plagiarism in the
final papers! Pursuing an 8-16 week course? The best in completing ace my homework & online class help, will assist you today!
Posted: June 14th, 2021
XML, mnemonic of eXtensible Markup Language is one of the most extensively used data format and is used as a standard for exchange of data over the internet. As large amount of data is represented as XML documents, techniques like RDMS have to be used to store and query these XML documents.
We assign writers based on your topic, academic level, and specific needs, ensuring expertise and a perfect match for your project. Our system prioritizes the best fit for quality results. Our advanced matching algorithm considers both subject specialization and your assignment complexity. You can also browse profiles to choose your writer. Students seeking an essay writer benefit from our intelligent matching system that pairs expertise with requirements.
There are two well known approaches for parsing an XML document to convert into relational DBMS: SAX and DOM parsing. In this research, both these methods are studied and then the performance is compared. Some alternative ways of data structuring and tagging from tables of RDBMS as a hierarchical XML document has been studied. As a final result, the best alternative which will provide with the best and effective performance for capturing and querying XML data using RDBMS can be found out.
When a large amount of data is to be loaded into an XML document, it becomes important to execute the request query and save the process at XML document. One way is to use XML native data base system. This has two weaknesses –
1. eXtended Markup Language resident database system is not ample to save data and it cannot contain the complicated query at relational DBMS.
2. It is impossible for the users to access XML documents and data that are stored in a relational DBMS.
Yes, our proofreading service catches errors, improves clarity, and ensures your paper is polished and ready for submission. We enhance your work while keeping your voice intact. Our editors focus on grammar, punctuation, and flow to elevate your academic writing. Upload your draft to get started today. Essay helper professionals refine your writing while maintaining your authentic academic voice.
To overcome the above mentioned weaknesses, querying and storing XML data techniques using RDBMS are used. The steps for this approach are-
1. Data or an XML document is saved by making relational table design.
2. XML data is divided by separating them into columns in the presented table.
3. SQL Queries are used to get access to the XML document format obtained in RDBMS dta format.
We guarantee on-time delivery, but if we miss a deadline, you are eligible for a partial refund or free revisions as compensation. Your time is valuable, and we take deadlines seriously. Our tracking system monitors every order to prevent delays and ensure punctual delivery. Contact support if you have concerns. My assignment help includes strict deadline management to protect your academic schedule.
To transfer data from XML to data base, the strategy is to use C# as middleware. This research can be done by parsing technique with the help of SAX parser or by using XML Tree Class.
To do the vice versa, the present format of XML document from relational SQL SERVER 2008 database supported by C# script, used as middleware; is converted with the help of tagging and structure. All alternatives (outside engine) done by tagging and structuring process implies that a part of the task was done outside the relational database engine.
For comparing the XML document and RDBMS from the point of speed in loading the process in the browser following tasks were performed:-
Searching of the data in the XML document is done with the help of DATA binding technique.
Presentation of the XML data from RDBMS is done by searching data from XML document which was saved into SQL database, than with the help of DOM Tree method the result of the query is saved as a XML Document
From biology to philosophy, our writers specialize in diverse fields, ensuring your paper is handled by an expert in your subject. We match expertise to your topic for top results. Each discipline requires unique methodologies and terminology that our specialized writers master. Share your discipline details in the order form. Research study bay connects you with subject specialists across all academic disciplines.
They are hard to update.
We cannot implement the constraints.
It’s difficult to optimize the xml database.
Hard to maintain the consistency
These two are different concepts. In data storage we store data and while storing it we need to check the validity of the data. In Data Transmission we simple transfer the data from one system to the other. XML are generally used for the Data Transmission purpose.
Use our order form or account dashboard to upload files like rubrics or sources, and your writer will incorporate them seamlessly. This ensures your paper meets all requirements. Multiple file formats are supported, including PDFs, Word documents, and images. Our support team can assist if you need help. Paper writing projects benefit from comprehensive material uploads for precise execution.
META DATA Definition
CREATE TABLE
DEFINE XML SCHEMA
Persistence of DATA
INSERT,UPDATE
Submit a sample of your writing, and we will mimic your style, tone, and vocabulary to make the paper feel authentically yours. This creates a seamless fit with your work. Our writers analyze writing patterns to ensure natural consistency with your previous submissions. Just upload your sample when ordering. Assignment writer experts replicate your voice to maintain consistency across all submissions.
CREATE XML DOCUMENT
QUERY
SELECT
XPath ,XQuery
We have tackled everything from quantum mechanics to comparative literature, with writers ready for any academic challenge. No topic is too tough for our team. Our diverse expert pool includes specialists in both theoretical and applied fields. Tell us your needs, and we will deliver. Ace tutors handle even the most challenging subjects with expertise and confidence.
Speed is the major advantage of creating database with objects. In OODBMS (Object oriented Database Management System) data is stored as objects but not in the form relational rows and columns such as in relational DBMS that is why OODBMS is faster than relational DBMS.
OODBMS is more applicable than relational DBMS (RDBMS) for some tasks. This is because OODBMS performs many operations using navigational interfaces where as RDBMS uses declarative interfaces. OODBMS follows pointers to implement navigational access to data in an efficient manner.
One disadvantage of RDBMS ‘s is we need relational mapping layer to map the entire model for application objects to the database object model, whereas in OODBMS there is no need to match those layers. In RDBMS due to this mapping there may be an impedance mismatch and there is no such problem in OODBMS and it also increases the performance.
OODBMS has some drawbacks like:-
Our detailed outlines include section breakdowns, key arguments, and source plans, giving you a clear path before writing starts. They are perfect for planning complex papers. A strong outline serves as both roadmap and quality checkpoint for your project. Request one with your order for added structure. Research essay service includes comprehensive outlines to guide your academic writing process.
As it is said above OODBMS uses pointers to implement navigational access to data this is one of the drawback as in general purpose queries this will lead to delay the output and also becomes complicated than relational
One more drawback is that there is no mathematical foundation for OODBMS, unlike RDBMS. This makes OODBMS weaker than RDBMS in supporting queries.
The difference between data-base centric thinking and oop is in the way it views the world. The first one views the world through a viewpoint which is declarative and attribute-driven. The latter one views through a viewpoint which is behavioural. This is one of the major differences between databases and OOP. Many consider database technology as a failure. Hence attempt are being made in research and industrially to closely integrate database functionality into object programming languages.
Different approaches for the database design includes data model approach design approach and so on. Starting with the data model approach:
We use strict protocols to protect sensitive orders, ensuring your data and paper details remain private and secure. Your privacy is our priority. All staff sign confidentiality agreements, and data encryption protects every transaction. Rest assured, your information is safe with us. Essay writer confidentiality guarantees complete privacy protection for every academic order.
For effective project implementation database design is most important aspect that’s why should be completed within given time line to give economical approach in project developing phase. Data model construction and updating on change of data deign in necessary as every application will need data storage. It is one of the most crucial parts of an application for developer and user as well. The different normal forms are:-
Similar group should be stored in different table and tables should be provided by primary key to identify columns.
To protect data redundancy foreign key must be introduced.
Primary key plays a prominent role making every column in the table related. This makes every column a dependent of the primary key of the table. Those fields not satisfying above property should be stored in a new table with a new key.
Yes, we craft compelling personal statements for college or job applications, tailored to highlight your strengths and goals. We make your story shine for maximum impact. Our writers understand what admission committees seek and craft narratives that resonate. Share your goals in the order form to get started. Ace my homework extends to application materials that open doors to opportunities.
Independent relationship should be removed from the relation database.
Many to many relationships can be related logically that’s why it’s also known as Exists in never-never land.
Followed by the data model approach is the design approach which is explained as below:
2nd and 3rd form designs should be used for large application having enhancement scope. Scalability should be kept in mind during designing phase of application.
Our Ph.D. writers have extensive experience with dissertations, delivering comprehensive research and chapter-by-chapter support. We guide you through every step of the process. From proposal to defense, we provide structured assistance for this culminating academic milestone. Your dissertation will meet the highest academic standards. My assignment help covers extensive dissertation projects with doctoral-level expertise.
Third form can ask you to make host of tables with less number of entity which reduces data replication across tables. While talking to a fellow developer i came to know that they used 3rd form as they were quite sure that it would not create dependency problem for their application as they used comma to differentiate primary values in a defined field of a table.
Classes that can be used as data object which contain properties, actually a description and quality of entity element and these properties are introduced by getter and setter, should be designed at the time of creating class diagram for an application. Both object and property shows real life entity. For creating the database tables we need following constraints and relationships to be there in that table so that final database developed will be more effective and understandable. These are explained in the Constrains section under the database design part with the help of query tools.
LO2 DEsign and implementation:
This assignment is to understand the database design concepts, implement the database designed and execute the queries to obtain the required result with the help of SQL Server database. It also helps in developing Client side application to modify, update and view the results through C#. Net.
Deeveedeezee, the online DVD shop records the customer details, DVD details which includes title, genres, Studio, classification, actors, directors and other information. It provides the users to rate a DVD using star scaling ranging from 1 to 5 and also allows them to create their own wish list.
We use advanced plagiarism detection tools like WriteCheck to ensure your paper is 95%+ original, giving you confidence in its uniqueness. A free originality report comes with every order. Every paper is written from scratch with properly cited sources and fresh perspectives. Your paper is crafted from scratch, every time. Paper writing authenticity is verified through multiple plagiarism detection systems for guaranteed originality.
Our objective is to understand how the database of this DEEVEEDEEZEE is maintained, practically implementing it with the help of SQL Server and develop an client end application that interacts with SQL Server and provides the user the authority to view and add details.
The WindowsFormApplication1 is the project tile and the client application can be run by opening the solution in MS Visual studio and Debugging the Code. It can be done by clicking on Build->Start Debugging.
Deeveedeezee.com as mentioned above provides the online customers various details about the DVDs, their reviews, ratings, synopsis and also allows them to create their own wish list. To maintain such a database, it has to be well designed and effectively handled by the administrator or the team of database continuously monitoring and assessing the required information.
Every user is provided with unique user-id and password with which they can login and access the required information about the DVDs. They can even provide their comments, reviews and ratings as well which are again recorded under their user-id and are provided when ever required or asked for. Also deeveedeezee handling such large information from the website requires an Administrator or a team working on databases so that it is well managed and maintained. Thus every administrator and the team member again have got their own user-ids and passwords so that they can login into the databases and do their assigned tasks. These discussed details are presumed to be handled and the rest of the discussion focuses on the database designing, implementation and development of a client application which interacts with SQL server to provide them the easier access to add and view data from the database.
Thus the backend database has got various data rules, definitions and constraints to be handled. Recording distinct information and accessed by different types of users, database has got different tables and views with appropriate fields and attributes. The database design diagram shown below shows the clear picture of how the database is designed, the various tables it maintains, attributes it holds and their properties.
We analyze your rubric to align structure, content, and formatting, with editors double-checking to meet every requirement. This ensures your paper hits all the marks. Our systematic approach checks each rubric criterion individually for complete coverage. Upload your rubric for precise results. Assessment help includes meticulous rubric analysis to maximize your grade potential.
The diagram shown below depicts the various tables and its attributes. This design is modified and improved further with the help of Entity Relationship Diagram. The Entity Relationship diagram of the report is as below.
The rectangle boxes are considered as entities
The ovals are treated as attributes.
Rhombus represents relationship between the entities.
Our writers excel at case studies, combining research and analysis to deliver insightful, well-structured papers for any field. We bring clarity to complex scenarios. Case study methodology requires careful attention to context and evidence-based conclusions. Provide your case details, and we will handle the rest. Research study bay professionals master case analysis across business, healthcare, and social sciences.
The diagram represents all entities, attributes and also the relations between the entities.
It is a graphical representation of the relations.
The ER diagram is a good means of understanding the relationships between the entities and attributes.
In the below diagram, different users can be uniquely determined by its attributes like userId, email, firstName etc.
User entity is related to DVD by Reviews.
Request revisions within 7 days, and our writers will refine your paper based on your feedback, ensuring it is perfect. We are committed to your satisfaction. Our revision system allows unlimited changes within the timeframe to meet your exact specifications. Use your account to submit revision requests easily. Essay helper support includes responsive revision services for complete satisfaction.
The ratings given to the movie by viewers are recorded through Ratings.
Comments are the reviews of viewers.
DVD on the other hand can be uniquely determined by its attributes like dvdId, title, studio etc.
Role connects DVD and People.
Role can be various tasks of people like actors, producer, and director.
People have attributes of peopleId and peopleName.
title
We can write specific sections for group projects, matching your teams style and ensuring cohesive integration. Our writers ensure seamless collaboration. Coordinating group work requires attention to unified voice and consistent formatting throughout. Upload shared guidelines to keep everything aligned. Assignment writer coordination ensures smooth collaboration on team projects.
retailPrice
releaseDate
runningTime
synopsis
genres
studio
Urgent orders are prioritized with dedicated writers, ensuring quality delivery even within 3-6 hour timeframes. We thrive under pressure to meet your needs. Our rush-order specialists are trained to maintain excellence while working efficiently. Chat with support to confirm your deadline. Ace tutors specializing in urgent delivery maintain quality standards under pressure.
initials
firstName
surname
dateOfBirth
address
mobileNo
telephoneNo
Yes, we incorporate primary sources when requested, ensuring robust research and proper citation for academic rigor. We can also find credible sources if needed. Primary source integration strengthens arguments with authentic, firsthand evidence. Just specify your preferences in the order form. Research essay service includes primary source research for scholarly depth and credibility.
password
timestamp
studio
peopleId
dvdId
role
userId
wishlist
dvdId
Every paper undergoes editing, plagiarism checks, and quality reviews to ensure it meets academic standards and your expectations. We leave no detail unchecked. Our multi-stage quality control includes subject experts who verify accuracy and depth. Your paper is guaranteed to impress. Paper writing quality passes through multiple expert review stages before delivery.
classification
description
peopleFirstName
userId
Yes, use our secure messaging system to discuss your order, share ideas, and get updates directly from your writer. This keeps you in the loop at every step. Direct communication ensures clarity and allows real-time collaboration on your project. Log in to your account to start chatting. Essay writer communication channels enable seamless collaboration throughout the writing process.
dvdId
review
rating
timestamp
peopleName
Our loyalty program rewards repeat customers with discounts and perks, making each order more cost-effective. Save more with every paper you order. Accumulated points unlock exclusive benefits and priority service for returning clients. Check your account for your loyalty status and benefits. My assignment help becomes increasingly affordable through our generous loyalty rewards system.
peopleId
people
Role
dvdId
We craft persuasive scholarship essays, highlighting your achievements and goals to boost your applications impact. Our writers make your story stand out. Scholarship committees seek authentic narratives that demonstrate merit and potential. Share your aspirations in the order form for a winning essay. Essay helper expertise transforms scholarship applications into compelling funding opportunities.
title
retailPrice
releaseDate
runningTime
synopsis
genres
Yes, we run promotions during peak academic seasons, like 10% off for summer orders—check our site for current deals! These savings make our services even more affordable. Seasonal promotions help students manage academic expenses during high-demand periods. Visit our website to catch the latest offers. Assessment help becomes more accessible through regular promotional pricing throughout the year.
studio
DVD
RatingComment
Review
userId
dateOfBirth
surName
firstName
initials
User
telephoneNo
mobileNo
address
password
The designed database discussed with the help of database design diagram and entity relationship diagram are implemented in SQL with the help of MS visual studio.
All the attribute and tablenames are in used as per the conventions like using camel case, singular table name and so on. The output tables, conents nd query results are recorded with the help of screenshots and are shown as below:
The details of the users like firstName,email, DOB, address, contact details are recoderd.
In this table Primary key contraint,Not Null constraints are present.
Datatypes of each attribute as per the given data rules are being implemented as shown above.
Comments:
It stores the all details of DVD like running time ,release date,title and creates an unique dvd id.
In this table Primary key contraint,Not Null constraints are present
Datatypes of each attribute as per the given data rules are being implemented as shown above.
It stores the reviews and the rating i.e No. Of stars given to the DVD by the user.
It has not null contraints ,check constraints which checks that the rating field have value greater than 0 and less than 5,foreign key contrains.’email ‘ is the foreign key which is refrencing to the primary key of the users table.
‘userId’ and ‘dvdId’ the combination of these two is used as a primary key.
Comment :
It stores the name of the people involved in the movie or DVD and gives a unique id to each of them that is ‘peopleId’.
It stores the role of the each people involved in the movie like director,producer,actor etc.
It has a foreign key ‘dvdId’ which refrences to the dvdDetails ‘dvdId’.’id ‘ is the primary key which is a identity with a seed 1.
It stores the wishlist of each user in comma seprated form.
In this table ‘id’ is the identity with seed 1 and userId is the primary key and ’emai’l is the foreign key.
It stores the classification of the dvd with a little description about the dvd.
‘dvdId’ is the foreign key and ‘id’ primary key and also a identity with seed 1.
This is a constraint which restricts the user from entering the null value or leaving it blank.
The user needs to provide the details for that field.
It becomes necessary for the user to enter.
In the given example ‘id’,’email’,’userId’ fields can not be left empty. User need to provide these details otherwise it will through error.’wishlist can be left empty.
CREATE TABLE wishList
( id int NOT NULL,
email varchar(100) NOT NULL ,
userId int ,
wishList varchar(MAX) NOT NULL)
This constraint is used to uniquely identify the row in the table.
This field is not repeated in any of the other row.
Primary key of one table can be used as the reference or foreign key of the other table.
In the above example ‘userId’ is the primary key. All the rows in this table will have different userId.
In the above figure it is clealy shown that the userId is different for different rows.
This is the constraint used for uniquely identifying a particular column.
All the values in a particular column are different.
In the above figure userId field has a unique constraint.It is a identity with a seed of 1.Every time a new row is inserted is automatically increments the value of the userId which ensures that in userId column no value is repeated.
In the above figure in ‘userId’ column no value is repeated . ‘userId’ has a unique constraint.
This constraint ensures that the database has a refrential integrity.
Foreign key is works on the refrence of the primary key of some other table.
CREATE TABLE wishList
(id int ,
userId int PRIMARY KEY,
email varchar (100) references users(email)
wishList varchar(MAX)
In the above figure ’email’ is the foreign key which refrences the ’email’ i.e the primary key of the users table.
This constraint makes sure that all values in a column satisfy certain specific criteria.
CREATE TABLE review
( reviewId int NOT NULL,
userId int NOT NULL,
dvdId int NOT NULL,
review varchar(200) NOT NULL,
rating float CHECK (rating<6 AND rating>0)
timestamp timestamp)
This check constraint helps in validation of ensuring the star rating to be between 0 and 5.
Or
CREATE TABLE dvdDetail
( dvdId int NOT NULL primary key identity(1,1),
retailPrice int NOT NULL,
title varchar NOT NULL,
synopsis varchar NOT NULL,
runningTime int CHECK (runningTime>10 AND rating<5000) NOT NULL
genres varchar NOT NULL
studio varchar NOT NULL)
This check constraint ensures that the running time to be between 10 and 5000.
LO3 Use of Manipulation and Query tools
Manipulation and Query tools in database include those commands and statements that on execution would help in data manipulation. SQL maintains certain standards which includes DML or Data Manipulation Language. The major SQL commands that include in this DML are INSERT, UPDATE, ALTER and so on. These tools or query commands help in modification of tha data and constant updates that have to be made. SQL Server 2008 offers a very good platform that provides access to database and also it provides the query window for executing various commands that include in the Data Manipulation Language. They are very much useful in making it easier for the user to modify the data and update some information. A fine picture of these tools and their functioning can be understood in the sections below:
Query for viewing all DVDs belonging to the Romantic Comedy genre in order of price.
SELECT dvdId, title, retailPrice, releaseDate, runningTime, synopsis, genres, studio
FROM dvdDetails
WHERE (genres = ‘Romantic Comedy’)
ORDER BY retailPrice
The query when executed would result into the table as shown below:
Query for viewing all DVDs belonging to the Universal Pictures UK
studio.
Table:Initial data in dvdDetails table
SELECT dvdId, title, retailPrice, releaseDate, runningTime, synopsis, genres, studio
FROM dvdDetails
WHERE (studio = ‘Universal Pictures UK Studio’)
Table: Result of the query
Query for viewing all DVDs in which Johnny Depp or De Caprio have acted.
Table: Initial data in dvdDetails table
Query:-
SELECT dvdDetails.dvdId, dvdDetails.title, dvdDetails.retailPrice, dvdDetails.releaseDate, dvdDetails.runningTime, dvdDetails.synopsis, dvdDetails.genres, dvdDetails.studio, choose.dvdId AS Expr1 FROM dvdDetails INNER JOIN (SELECT DISTINCT [NATURAL].dvdId
FROM roles AS [NATURAL] INNER JOIN people ON people.peopleId = [NATURAL].peopleId
WHERE (people.peopleFirstName = ‘Shahrukh’) OR (people.peopleFirstName = ‘Amir khan’))
AS choose ON choose.dvdId = dvdDetails.dvdId
Table: Result of the query
View all the DVDs which Steven Spielberg has directed.
Table:Initial data in dvdDetails table
SELECT dvdDetails.dvdId, dvdDetails.title, dvdDetails.retailPrice, dvdDetails.releaseDate, dvdDetails.runningTime, dvdDetails.synopsis, dvdDetails.genres, dvdDetails.studio, choose.dvdId AS Expr1
FROM dvdDetails
INNER JOIN
(SELECT DISTINCT [NATURAL].dvdId
FROM roles AS [NATURAL]
INNER JOIN people ON people.peopleId = [NATURAL].peopleId
WHERE ([NATURAL].role = ‘Director’) OR (people.peopleFirstName = ‘Farah Khan’)) AS choose ON choose.dvdId = dvdDetails.dvdId
View of all the DVDs suitable for a Valentines Gift.
Table: Initial data in dvdDetails table
SELECT dvdId, title, retailPrice, releaseDate, runningTime, synopsis, genres, studio
FROM dvdDetails
WHERE (genres = ‘Romantic’)
Table: Result of the query
View of all the DVDs suitable for children (under 10s) to watch.
Table: Initial data in dvdDetails table
SELECT dvdId, title, retailPrice, releaseDate, runningTime, synopsis, genres, studio
FROM dvdDetails
WHERE (genres = ‘under 10’)
Table: Result of the query
DVDs on the wishlist for a specified customer
Table:Initial data in wishlist table
SELECT wishList
FROM wishlist
WHERE (userId = 1)
Table: Result of the query
DVDs in order of release date
Table: Initial data in dvdDetails table
SELECT dvdId, title, retailPrice, releaseDate, runningTime, synopsis, genres, studio
FROM dvdDetails
ORDER BY releaseDate
Table: Result of the query
DVDs belonging to a specified studio in order.
Table:Initial data in dvdDetails table
SELECT dvdId, title, retailPrice, releaseDate, runningTime, synopsis, genres, studio
FROM dvdDetails
ORDER BY studio
Table:Result of the query
To add a sample DVD.
Table: Initial data in dvdDetails table
INSERT INTO dvdDetails
(retailPrice, releaseDate, genres, studio, runningTime, title)
VALUES (99, CONVERT(DATETIME, ‘1990-05-02 00:00:00’, 102), ‘under10’, ‘Coke Studio’, 1100, ‘Tom’)
Table: Result of the query
Table:Data in dvdDetails table after executing query
An update query to change the review star rating assigned by a customer to a DVD.
Table: Initial data in review table
UPDATE review
SET rating = 3.5
WHERE (userId = 1)
Table:Result of the query
Table:Data in review table after executing query
Queries can be simple and complex. For the complex queries we make the stored procedures, views and trigger which we can use later in our code and for the simple query we can directly embed in the code. Stored procedures contain more than one query and the stored procedure is pre compiled method for accessing the data from the database. Queries including select, insert, update etc are written in the procedures. After committing the query if any error occurs then we roll back and ignore the result of that query.
If the correct relationship is present between the tables than only we can get the correct result from the data
LO4 Use, documenting and implementing of Relational Database Management System
Queries in the section 3.2 produce the result correctly i.e. the output of different queries are correct and as we know that queries will give the correct output only when the relation between the tables are correct i.e. the relational database is correctly made. Queries in the view section and the also in the client application desired view produce a correct result which shows that the implementation of the relational database is correct.
Microsoft Visual Studio has been used for developing the client application in C#.NET. Our main objective was to provide the user with the facility to add and view the data from the database so that proper updating can be done and relevant information can be provided to the user through the online website of deeveedeezee.com.
The prerequisites for this application are:
MS Visual Studio installed in the computer system with C#.NET and SQL server.
The MDF file or the database has to be loaded into the application through MS Studio by Data-> Add new datasources-> Database.
Once the database is loaded, the SqlConnection string path has to be modified to the path where the database is located.
Every user of this client application is provided with unique username and password through which he can log in into the application. The application only highlights the required and mentioned features in the assignment of VIEW and ADD. The figure below represents the Client Application as it looks after logging in successfully.
afterlogin client app.JPG Fig: Client Application
The user allowed viewing and adding the data, on clicking the respective buttons would be directed to the forms as shown below:
view and add.jpg
One can view the details of DVDs, Reviews posted by the customers through online website, Ratings provided by them, their wish lists and the user data.
One can add up details to be displayed about DVD to the customer, roles played by various actors, actress and other working staff for that particular product, rating as per the reviews and rating awarded by the customers and also new users data.
The following sets of figures describe how the data and various details are added to through the client application into the database:
add dvddetails.JPG Fig: Add dvdDetails
On clicking the submit button, in the coding section the query to insert the details of DVD which includes dvd Name or title, Price, Genres, Date of Release of the DVD, Studio and synopsis is executed and the table of dvdDetails is updated as shown above in the query section.
add ratings.JPG
Viewing the details of review and rating provided by the customers through online, the user of this client application can rate the dvd accordingly. He has to identify the dvd ID and based on the information he has got he can provide the rating on a scale of 1 to 5. As explained above similarly on clicking the submit button, the query gets exected in the back and the table of concerned gets updated as shown above in the query section.
add roles1.JPG
This helps in providing the customer regarding the cast details of the product.
add users.JPG
This helps in validating the user by adding them into the database.
Similarly viewing would allow the user with the following output:
dvdDetails includes title, price, date of relase and such other features that described the dvd. dvdID is uniquely and automatically generated and is considered as the primary key. From the data available in this table dvds can be classified based on their genre and studio as per requirement.
This table helps in updating the online site with the roles played by various persons involved in making this product. The persons can be identified by their unique ids.
As provided online by the customers their wishlist gets updated in the database ad can be viewed for knowing required information about the user and his preferences for future use.
Users or customers using deeveedeezee.com online and th staff using this application, all the details are provided in this table from which one can know about their personal details and contact information to be used for various purposes.
Based on the data provided in the reviews by online viewers, the users of this application can add the modified rating based on data collected from many sources.
In all the above view forms, GRIDVIEW t
College students want the best grades in their courses and that’s our FOCUS
Our team consists of outstanding writers who have specialized knowledge in specific subject areas and are scholars experienced in academic research;custom paper writing following assessment task, assignment brief and grading rubric criteria. They hold at least a graduate degree—230 with Masters and MSN qualifications, experts carefully selected and trained to ensure the best final paper quality of our work. .
We’re dedicated to bringing on board top-notch writers who can provide excellent work at prices that make sense for college students; affordable papers for all the course subjects. Our goal? To give you the best bang for your buck without ever compromising on the quality of our essay writing services—or the content of your paper. We give special extra discounts for regular clients and also for long research papers, dissertations and capstone projects. #Don’t forget to use the DISCOUNT code in the COUPONS section of the order form before checking-out!.
The Online Homework Ace Tutors service guarantees that our final work is 100% original, researched, and expertly human-written. Our professional academic writers craft every custom essay and research paper from scratch, ensuring your assignment is tailored to your exact instructions. We are committed to delivering plagiarism-free and AI-free work to each university/college student's 'write my paper' request. To uphold this promise, we check every draft for any possible instances of duplication, wrong citation, grammar errors, and artificiality before we send it to you. Thus, you can always rely on us to write genuine and high-standard content for your essay assignments.
When you trust to place an order with Sample Essays, here is what happens: