Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
What are the purpose for having variable length records? What kinds of separator characters are required for each? Variable-Length Records - Variable-length records are those records that are of various sizes. A file may holds variable-length records in any of the subsequent situations:
• Records having variable length fields - In this case, the end-of-field symbol along with end-of-record symbol could be used as the separator characters.
• Records having repeating fields - In this case, the number of repetitions of repeating area can be used along with end-of-record symbol as the separator characters.
• Records having optional fields - In this case, the end-of-field symbol along with end-of-record symbol could be used as the separator characters.
• File containing records of various record types - In this case, a special field (or control field) can be prefixed with every record and end-of-record symbol could be used as the separator characters.
In each of the above situations either we can use end-of-record symbol or the length of every record can be prefixed at the starting of the record for the separation of the variable-length records.
Niles Video Inc. wants to create a website for online sales of movies (DVD and videotapes). People will be allowed to register as customers on the website and to update their store
What is conceptual schema? The schemas at the view level are known as subschema that describe dissimilar views of the database.
Suppose that in an organisation, an employee may do different roles in dissimilar projects. Say, RAM is doing coding in one project and doing designing in another. Suppose that the
Express the subsequent query in SQL assumes which the data is stored within EMPLOYEE table with relevant fields (i) Display name, job, salary, and hire date of employee who are
Define query optimization. Query optimization refers to the process of search the lowest -cost method of evaluating a given query.
What is a Name? A user-supplied name is used for identity. This form of identity is used for files in file systems. The user gives every file a name that uniquely identifies it
What is Thread splitting A thread of control is a path by which a set of state diagrams on that a single object is active at a time. Objects are shared between threads
What does Aggregation mean?
What is an ERD?
Related fields in a database are grouped in which form? Related data fields in a database are grouped to form a data record. (A record is a collection of related fields)
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd