Hello I need help with HW in database class I HAVE to choose DATA for any company and put them in SQL. HERE is WHAT TEACHER WANTS IT IN THE DATA. then we have to write the 2 page paper about that describing. AFTER THAT YOU also have to MAKE PRESENTATION should have around 5 to 6 slides. FOR all THIS I have instruction in bottom.
|
To help users evaluate your database vision and its usability, you generally create prototype queries and views (reports) to illustrate your specific design and its features. Create example queries and views (reports) in SQL; employing some sample data, verify your ER model(s) will support those use cases, or accomplishments, or activity, etc. demanded by your chosen area of application. Turns out there were some questions that probably should have been asked in class. Designs generated by Vertabelo include all relevant FOREIGN KEY constraints, and this can sometimes create issues in SQLITE if you try to add a new record so you can input sample data. The problem is that if you don’t specify a default value for an INTEGER foreign key, when SQLITE creates an new empty record, it will try to insert a key value of zero (0). If you don’t already have a record for key value zero (0), the attempt to create a new record using the ‘New Record’ button will usually fail, particularly if NOT NULL is also specified for integer foreign keys. The issue with text/string foreign keys is a bit different as sometimes for a NOT NULL type text constraint, the default value is an empty string (i.e. blank) which is sometimes different from a Null value, or nothingness. If you’re having problems creating data, and getting queries completed, then perhaps some of the problem is in the CONSTRAINTS defining Primary and Foreign Keys, and the mechanism in SQLITE for creating new records. |
|
INSTRUCTIONS FOR PAPER.
As stated in the syllabus: “Students are required to submit a paper describing a business situation that would benefit from a database implementation to store and retrieve data. They must apply their knowledge of relational databases to define the business constraints, design considerations and implementation techniques.”
Your paper should be Consistent with the submitted topic and the associated ER model; substitutions if necessary will require submitting revised topic/ER model and obtaining necessary approval for the proposed topic change.
MAKE PRESENTATION
FINAL PRESENTATION SHOULD BE DESCRBING HOW DID WE GOT ALL THIS NUMBERS AND HOW DID YOU MADE IT in STEPS
PLEASE MAKE IT ACCURATE
Thank you for your help.
0 comments